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.

Leave a comment

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