Unable to import CSV file with new products

[Lyt35]

Hi,

I try to import products in our new Shopify webshop, but we keep getting the error "Invalid CSV header: missing headers: Title" (Free translated from Dutch) The file is a CSV (UTF8) and all the headers are still in the original file I downloaded from Shopify. I tried a lot of different ways but I can't fix it. Is there anybody who can help me with this problem? 

[saim007]

@Lyt35 Can you please attach CSV file here so I can check.

[Lyt35]

Hereby the file. Thank you in advance for checking it! 

[saim007]

@Lyt35 Please use attached csv file format for product importing.

Please let me know if works and like mark as solve!

[Lyt35]

Thanks Sandy, import of this sheet works, but it's not an file I can edit by myself. If I open it in Excel as a CSV UTF8 and import it again I get the same error message. So this is not the solution for me.. 

[simon-skrod]

Hi@Lyt35 ,
From file you attached previously, it seems like tool you are using to edit csv files is configured to save files with semicolon delimiter, while it should use comma.

When you save files make sure you save then using comma delimiter, if you use microsoft office, you will have an option so save file as "CSV (Comma delimited) (*.csv)".

[Lyt35]

Hi Simon,

I tried, but the strange this is when I open the file in Notepad ++ again it shows the semicolon again instead of the comma. I tried it in Google Sheet now and it's working. Thanks anyway!

[Alok_Kasgar · Accepted solution]

Hi @Lyt35 

Go to google sheet and create new sheet

paste your all data here and download as a csv file then try with shopify

[Alok_Kasgar]

Hi

This is alternate solution. PFA sample csv file 

You can put your product data in this sheet and upload to new store