wcj
|

CSV File issues fixed – MS Excel

Updated on

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

Windows Server 2012 Standard WLAN Netgear WNA3100 USB

ByiUseful

I downloaded and installed the drivers for my Netgear WNA3100 usb adapter, inserted the device when prompted, nothing happened for a while.  I searched online (ethernet cable plugged in) and found that the feature needs to be enabled: Go to Server Manager  -> Features -> add a feature -> scroll to the bottom- > select…

Remove sidebar and make shop pages wider with Astra WordPress theme

Remove sidebar and make shop pages wider with Astra WordPress theme

ByiUseful

I had an issue with the Astra wordpress theme and my Woocommerce store pages. I was stuck with a sidebar that I wasn’t using. Astra sent me the following code to remove the sidebar: add_filter( ‘astra_page_layout’, ‘no_sidebar_shop_page’ ); function no_sidebar_shop_page( $sidebar ) { if ( is_shop() ) { $sidebar = ‘no-sidebar’; } return $sidebar; }…