Skip to main content
Best answer

Getting Sheets to split text to columns

  • September 9, 2020
  • 1 reply
  • 1010 views

I want to get my data that comes into sheets from my zap to split into columns without me have to click split text into columns, 

Any tips?

Best answer by AndrewJDavison

@LinKrl 

You’ll most likely be able to do this with a “Formatter->Text->Split” step.

You can break up the incoming string into multiple parts (using the “As separate fields” output type), which you can then map to different columns in your sheet.

https://zapier.com/blog/zapier-formatter-guide/

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

AndrewJDavison
Forum|alt.badge.img+11
  • Zapier Solution Partner
  • Answer
  • September 9, 2020

@LinKrl 

You’ll most likely be able to do this with a “Formatter->Text->Split” step.

You can break up the incoming string into multiple parts (using the “As separate fields” output type), which you can then map to different columns in your sheet.

https://zapier.com/blog/zapier-formatter-guide/