Skip to main content

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

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!


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 :(