wcj
Software Tips | Wordpress

CSV File issues fixed – MS Excel

I was working with a WordPress plugin and I needed to import a load of products, no problem there is a CSV import option.

I tediously went through the products and entered them into a file, saved as CSV and uploaded.  Unfortunately, the file was not recognised as nothing was imported.

I tried entering the encoding UTF-8 option but still no joy.

Eventually, I found that saving the file as a MS DOS csv file in Excel and then uploading worked fine.

I use Excel 365 but it should be the same for the previous versions.

Similar Posts

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest DEALS, OFFERS and News before anyone else.

You are almost done - please check your inbox for confirmation!

Pin It on Pinterest

Share This