Written by me@grafxflow
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!
- Import the csv file into excel and add/edit your products or content.
- After saving the file simply open it up in a text editor (I use Dreamweaver) and change nothing... just save the file again.
- 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!
Smart Search
Latest Articles
Install Deus Ex GOTY with Wineskin for Mac M Series
221 views
The Ultimate Preservation? Reviewing the Stereoscopic 3D Fan Edits of Star Wars
192 views
The Falcon Needs a Refurb: The 3-Step Blueprint to Save the Star Wars Universe
905 views
Darth Maul and Micro-Organisms: Inside George Lucas's Cancelled Star Wars Sequel Trilogy
292 views
How to Automatically Convert DVD Subtitles to SRT on Mac
218 views
The $4 Billion Divorce: Inside the Awkward, Painful Sale of Lucasfilm to Disney
188 views
Popular Articles
Markdown Syntax Cheatsheet
461,246 views
How to install GitLab CE with Vagrant on macOS
310,354 views
Disable macOS 11 (Big Sur) 'kernel_task' which is throttling the CPU
226,749 views
Shadow Catcher plugin in Cinema 4D - Part 1
176,855 views
Defective AMD GPU fix on Macbook Pro 2011
153,996 views
Adding an email template for apple mac mail.app
146,442 views
Popular Tags
me@grafxflow
Founder, 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. I build lighting-fast dynamic content engines with Laravel, Winter CMS and Tailwind CSS. Thanks for stopping by!
Jessica Silber
14 Mar 2013
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.