importing CSV client list keeps on showing error "Missing header: Email"

[LaGirafeCouture]

Hello,

I am trying to import a CSV file of a customer list and I keep on getting the following message "Missing header: Email."

I checked and the header "Email" is in my CSV file which I built exactly as per the template provided by Shopify. 

Any idea how to fix this?

Thank you!

[productsync · Accepted solution]

Hi

Could you email the file to me and I can double check it? [email protected]

It might be something to do with how the file is being saved but probably quicker to just have a look myself.

Regards

Tom

[productsync]

Hi

I know you said it has the correct header information but have you tried using the example file to check if it successfully imports: https://help.shopify.com/en/manual/customers/customer-csv-issues#missing-header-or-missing-headers

If that one works then double check the file again and perhaps save it as CSV UTF-8 format and try reimporting. Let me know how you go.

Regards

Tom

[LaGirafeCouture]

Hello,

Thank you for your reply.

I downloaded the template file provided by Shopify and I tried to import it. I get the same message « Missing header: Email »

Any suggestion please?

[productsync · Accepted solution]

Hi

Could you email the file to me and I can double check it? [email protected]

It might be something to do with how the file is being saved but probably quicker to just have a look myself.

Regards

Tom

[EmielA]

Hi Tom,
Is it possible to check my CSV as wel?? Used the Shopify Template and should be all correct, but still got the "email-header" problem.

Thanks a lot!

Emiel

[productsync]

Hi Emiel

Best to delete the file from here and email us at [email protected]

Regards

Sam

[rosemolly]

Hello, can you help me too? im having the same issue. i have everything i need but its still saying error. 

[productsync]

Hi

You can email us the file and we can double check it for you.

Regards

Sam

[RaeChristine]

Hi, Can you help me with mine as well. I am getting the same error. 

[productsync]

Happy to help. You can send it using form below or email to [email protected] and we can take a look. Just be sure the column headers all match the Shopify template exactly and that there are no additional columns that Shopify template doesn't have.

[RaeChristine]

Thank you

[lmnl]

Hey Tom, I have the same issue, I used the sample template and just added the names, emails and numbers from a lead generation ad but it's still comes up with 'email header' as the issue even though I've used the sample template. I'll email you at this email address right with the csv I'm using? [email protected] 

[mindcollections]

Hi,

I am still having issues uploading my customers to Shopify. Can you help? 

[spulie]

Hi - I'm getting this same error - I did make sure it is commas....Any other ideas? 

[productsync · Accepted solution]

Hi

Just to note it here if anyone else has similar issue. 

Semi colons were the culprit as they replaced the commas in the file that are meant to separate columns therefore the required headers were not being detected.

Regards

Tom

[LaGirafeCouture]

Thank you so much Tom for going out of your way to fix my problem.

Issue fixed!

[Andrea_Slater-S]

So, I definitely had the semi-colon issue (fixed in google sheets) but I'm still getting the missing header error. This is so frustrating. I didn't have this issue when I bulk edited products before.

[productsync]

Hey

If you need another set of eyes to have a look over it just send a sample over and I can double check it.

Regards

Tom

[Andrea_Slater-S]

That would be most appreciated. Not sure how best to share a sample but happy to share the direct link, too?

I've dropped you a mail. Hope that's okay?

[Tenera123]

Hello Tom, 

I am having the same issue and could not manage to solve the issue...

[productsync]

Hi

Always double check the final file in notepad and see if the rows are set up correctly.

Another good idea is to download the Shopify template file and use the first row from that and add your data underneath it. If it still fails usually problem with how you are saving it.

If still no luck you can email it over. Just need the first couple of lines after header row so no need for full file.

Regards

Tom

[edlep23]

Hello i have the same probleme for the csv... the error is Missing header : email too, and i have already try to change in csv utf8 but it is the same, error again... excuse me for my english, im french ^^

[Beardedpup]

I’m having this exact same problem.  How do you edit any of it?? You’d think Shopify would fix this issue as it appears everyone has the same problem. I’m not a tech guy and I’ve spent 4 hours today trying to import my csv file and I’m still unsuccessful 

[nadiabiad]

I first Opened the file as Text with notepad, i replaced the semi comas with comas and saved the file with utf-8 encoding, and it worked