Showing results for 
Search instead for 
Did you mean: 

invalid column when importing csv

invalid column when importing csv

Trying to import and I keep getting an error about invalid "" columns I looked through the entire sheet to see maybe if there's a character somewhere..


No idea..


Help please


Re: invalid column when importing csv



Open the file in a text editor and save it as UTF-8 encoding.


Also if you are using Import/Export > Import, make sure that you have all the required by Magento fields and column names should be identical as database names (otherwise that might be simply not recognized).


Use export to have example of column names or check this tutorial on required columns and header names for CSV import -


Hope this helps.

Store Manager for Magento 1.x and 2.x - inventory management tool to automatically update products, customers, orders, and other data across multiple sales channels and suppliers.