Hi @Tugbota , Can you please elaborate your problem? What are you trying to build? Also what do you mean by line items csv?

Hello, I am importing Xero invoices and there is header detail that goes to one row, but there are multi line items in the invoice that are comma separated and I need to parse these into rows.

Understood @Tugbota , Can you share screenshot with me about the line items invoice that are comma separated?

Hi @Tugbota 

Here’s how to work with line items in Zaps using the Formatter: https://zapier.com/help/doc/how-use-line-items-formatterv2

Also, the Looping app can be used to handle line items: https://zapier.com/apps/looping/integrations

So I got the formatter to work to split the delimited data in some columns to the below, but it still imports into Airtable as delimited on the multi line items.

Do I require another step in the formatter to achieve this or must it be completed in Airtable? The documentation is not the greatest at explaining.

Cheers