Home > Docs > Product Import Export Plugin for WooCommerce > Import WooCommerce Products Using Google Spreadsheet

Import WooCommerce Products Using Google Spreadsheet

Last updated on April 24, 2025

Importing WooCommerce products from a Google Spreadsheet is important for streamlining product management, especially when dealing with large inventories or team collaboration. Google Sheets allows multiple users to edit product data in real time, making it easy to prepare, update, and organize product information like titles, prices, SKUs, and descriptions. By importing directly from a spreadsheet, store owners can save time, minimize errors, and maintain consistency—making bulk product uploads, updates, or migrations faster and more efficient.

Importing WooCommerce products into your store can be done with ease using the plugin,  Product Import Export for WooCommerce. Different methods for importing include importing locally using a CSV/XML/TSV/XLS/XLSX file from the system, via FTP, using existing files and via URL. To import products using Google spreadsheet:

To begin with, you will have to create a google sheet with the required data in appropriate column headers.

WooCommerce Product Export-Google spreadsheet
WooCommerce Product Export-Google spreadsheet

Publish URL to the web

To publish your Google Spreadsheet URL to the web: 

  1. Open your Google Spreadsheet.
  2. Click File at the top left.
  3. Click Publish to the web.
  4. Publish your spreadsheet (If your spreadsheet is not yet published):
    • Click Publish.
      publish-to-web
    • Click OK in the pop-up window.
      publish-confirmation
    • Copy the URL displayed on the Link tab.
      get-link-of-spreadsheet

Steps to import

From the WordPress admin panel’s menu, click on WebToffee Import /Export (Pro) > Import.

  1. Select the required post type.
  2. Select either Quick or Advanced import method.
  3. Select URL under Import from and paste the Google Spreadsheet link in the field, Enter file URL.enter-file-url
  4. Click on Step3 to map the columns and move to step 4 to finish importing.