Question about invalid column when importing csv ?

[sprit_nea]

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

[gelanivishal]

Hello @sprit_nea ,

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 -

https://www.mag-manager.com/useful-articles/tipstricks/required-csv-file-values-for-error-free-magen...

Hope this helps.

--
If my answer is useful, please Accept as Solution & give Kudos