Blog

05 Mar
2013

WordPress Icon Logo

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!

Posted in: < CMS >
me@grafxflow avatar

me@grafxflow


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!

Visitors also viewed these posts

1 Thoughts

  1. 14 Mar
    2013

    avatar

    Jessica Silber

    Hi,

    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.

Add comment

Add comment