WordPress Icon Logo

Written by me@grafxflow

05 Mar, 2013



Import CSV into WP-eshop Magento error

I recently updated some CSV files in Excel (on my mac) then tried to import the CSV files into Wordpress eshop, but I kept getting back error messages. Plus I also had the same issue with a different CSV file in Magento.

I presumed that when saving the file using the Mac version of Excel, it was changing something in the CSV file format which was causing the error. Anyway I found a very easy solution!

  1. Import the csv file into excel and add/edit your products or content.
  2. After saving the file simply open it up in a text editor (I use Dreamweaver) and change nothing... just save the file again.
  3. Now you should be able to import the CSV file with no errors into WordPress eshop or Magento.

Why this works, I haven't got a clue... but it works!

Add comment

1 Response

  1. avatar

    Jessica Silber

    14 Mar 2013

    I am also getting same problem to import a CSV(Comma Separated Values) file to wordpress and now i am successfully import a csv file to wordpress with the help of your post. Thanks a lot.

Smart Search

132 Following


Hull, United Kingdom

I am a Full-stack Developer who also started delving into the world of UX/UI Design a few years back. I blog and tweet to hopefully share a little bit of knowledge that can help others around the web. Thanks for stopping by!