Cannot Upload .csv Files using Store Importer

[archer223]

I am trying in upload customer data in csv format from squarespace to shopify using store importer app as stated the link below:-

Migrating from Squarespace to Shopify · Shopify Help Center

However I keep getting error message

The following file(s) could not be added:

• Shopify.csv couldn’t be uploaded because it is not a recognized file. Ensure you’ve chosen the correct file or learn more about which files can be uploaded.

I do not know what is going on 

[peterloane]

Can you open the .csv file with something like Notepad++ (or even Excel)?

[archer223]

I created the .csv in excel 

[peterloane]

If you did not export the data from Squarespace as outlined here 

https://help.shopify.com/en/manual/migrating-to-shopify/shopify-import/squarespace-migration#step-1-...

then it looks like you need to use the templates provided at the link, for example for Customer data 

https://help.shopify.com/en/manual/customers/import-export-customers#customer-csv-template to import customer data.

I recreated the error you got by creating a simple .csv file in Excel and trying to import it with Store Importer, so its looking for a particular file content format.

I then used the customer template linked above, added an extra dummy customer and it imported all three customers without issue with Store Importer.

[channelup · Accepted solution]

Hi

In Excel try saving the file as CSV UTF-8 not the standard CSV format. Then test again in Shopify.

Another way people fix file format issues is by saving it in Google Sheets and then exporting it to csv format.

Regards

Tom

[archer223]

Thank you so much for that. It worked