Excel Output, Cell content split into different rows

Trying to split the cell content from an excel output I had automated in n8n into different rows in excel and can’t figure out how to do this. For context, if I have (a,b,c,d) in cell A1 as an output, but my goal was to create an output such that a, b, d & d are in different excel cells - A1, B1, C1, D1 - how do I correct this please. I am new to N8N and I do not have any coding experience.

image

Welcome to the n8n community @Sigmund

This workflow below shows you exactly how to split comma-separated values into separate Excel columns!

Add missing credentials and test the workflow, hope this helps!

2 Likes

@Miliaga - Amazing!! thank you.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.