Importing and Exporting Products to Google Spreadsheets – WooCommerce Product Import Export

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 40,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

WooCommerce Product Import Export plugin facilitates importing and exporting WooCommerce products into a CSV or a Comma Separated Value file. Once imported, the CSV file can be opened with a text editor on your computer. The values in the CSV are generally separated by a comma. The most convenient way of viewing or editing a CSV file is using spreadsheet programs like Microsoft Excel or Google Sheets.

Manipulating a CSV file using Google Sheet is very easy. To use Google Sheet for viewing or editing a CSV file you need to import the CSV file into Google Sheets. And when you are done making your changes you can export the file back to CSV file.

To import a CSV file into google sheets, say, the Product_variable_Sample file

  • Go to the Google Sheets account to start a new spreadsheet.
  • Open a blank spreadsheet.

Start new Google Spreadsheet

  • In the new blank spreadsheet, go to File > Import on the menu bar.

Import CSV file to Google Spreadsheets

  • From the Import FIle dialog box go to the upload tab to upload the CSV file.

Upload file dialog box

  • From your computer locate the CSV file and upload.

Import CSV file

  • Check the Replace spreadsheet and Detect automatically or the relevant radio buttons and then click Import.

This will import your CSV file into Google Sheets. Which then you can view and then edit and make changes easily.

CSV file exported to Google Spreadsheet

After you have done your changes, the files will be automatically saved and you can import the files as follows.

  • Go to File > Download as > Comma-separated values (.csv, current sheet)

Downlaod the CSV file from Google downloads

  • The file will be downloaded to your computer as CSV file.

Download CSV file

To know more about Product Import Export plugin read the documentation here.

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 40,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

Leave a Reply

Your email address will not be published. Required fields are marked *