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!

[channelup]

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?

[channelup · Accepted solution]

Hi

Could you email the file to me and I can double check it? tom@channelup.io

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

Regards

Tom

[channelup · 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.

[channelup]

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?