Skip to main content
Question

Trouble parsing CSV file line items using Formatter


Hi everyone,

I’m trying to import a CSV file from a new attachment in Gmail, but I’m getting some troubles using Formatter.

This is the sample CSV file:

 

And this is my Formatter set up:

 

The problem is that for every line item, Formatter is not assigning the values to the correct columns (header names):

 

 

 

 

Any help would be appreciated.

Thank you

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7472 replies
  • September 3, 2021

Hi @eortiz, welcome to the Community! :)

It looks as though row 1 is blank:

4842a4ada710ce974f92097d825b0f05.png

I think that may be what’s causing some issues in Formatter recognising the header row correctly.

Can you try removing the blank row 1 from the CSV file so that the header names move up into row 1. Then try re-importing it using Formatter to see if that does the trick? 

Please do keep us in the loop on how that goes!


  • Author
  • Beginner
  • 1 reply
  • September 13, 2021
SamB wrote:

Hi @eortiz, welcome to the Community! :)

It looks as though row 1 is blank:

4842a4ada710ce974f92097d825b0f05.png

I think that may be what’s causing some issues in Formatter recognising the header row correctly.

Can you try removing the blank row 1 from the CSV file so that the header names move up into row 1. Then try re-importing it using Formatter to see if that does the trick? 

Please do keep us in the loop on how that goes!

Thanks @SamB but I am not able to edit the input file :(