Magento 2 Import – Number of Columns Does Not Correspond to Rows in Header
importmagento2
I am trying to upload products in Magento 2.2.6 from default import using CSV. I am getting this error while checking data on CSV.
I have double check my CSV file has accurate columns and values in it.
Best Answer
This error comes in case of some of data are available in row, but column name is not available in first row of your csv. If it looks ok then might be csv break because of your some data has ,.
I suggest that upload csv in google sheet and export as csv then try to import.
Please let me know still if you are getting error.
The message is intended to mean that the filename of the file you are importing doesn't have a file extension. That is to say the file you are selecting to import is called something like customers rather than customers.csv. It attempts to validate the file extension as this determines what type of adapter to load (csv, xml, etc.).
Open your CSV file in Open Office where you have control over the save options. Now save the file specifying UTF-8 and making sure you have the correct field breaks (, or \t).
Read the file now and there should not be any character set problems.
Best Answer
This error comes in case of some of data are available in row, but column name is not available in first row of your csv. If it looks ok then might be csv break because of your some data has ,.
I suggest that upload csv in google sheet and export as csv then try to import.
Please let me know still if you are getting error.