Importing WooCommerce Products Using Microsoft Excel File

Last updated on August 27, 2021

To import the products using Microsoft Excel spreadsheet, activate the plugin Product Import Export for WooCommerce. The plugin supports only CSV or XML file formats as input file. CSVs should be in UTF-8 format.

Saving with .csv extension

Before importing, save your Excel file with the .csv extension, that’s as simple as clicking Save As and selecting Comma Separated Values(CSV) from the file type drop-down list.

The products in excel spreadsheet will appear as :

Note: Download Sample CSV.

Follow the steps mentioned in Import products using csv and finish the import.

For a detailed import process documentation, refer: How to import products.

Was this article helpful?
Yes, thanks!Not really

This article posted in Documentation, Import, Knowledge Base, Product Import Export Plugin for WooCommerce, WooCommerce and tagged CSV file utf-8 encoded, MicroSoft Excel, Product import, product import CSV, woocommerce

Written by

WebToffee Team

WebToffee Team is a group of WordPress and WooCommerce enthusiasts consisting of expert developers, testing engineers, technical support engineers, and SMEs.

Comments (2)

Shining Tech

December 13, 2021

Dear Sir,

We want to buy the pay version for this plugin.
May we know is it possible if we put the image into excel file instead of image url?

Thanks.

Reply
- Alan
  
  December 14, 2021
  
  Hi,
  Sorry, you cannot import images directly from the file. You need to include the image URL in the CSV for importing images.
  
  Reply

Cookie	Description
PHPSESSID	This cookie is native to PHP applications. The cookie is used to store and identify a users' unique session ID for the purpose of managing user sessions on the website. The cookie is a session cookie and is deleted when all the browser windows are closed.
viewed_cookie_policy	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not a user has consented to the use of cookies. It does not store any personal data.

Cookie	Description
_ga	This cookie is installed by Google Analytics. The cookie is used to calculate visitor, session, campaign data and keep track of site usage for the site's analytics report. The cookies store information anonymously and assigns a randomly generated number to identify unique visitors.
_gat_gtag	Identification code of website for tracking visits.
_gid	This cookie is installed by Google Analytics. The cookie is used to store information on how visitors use a website and helps in creating an analytics report of how the website is doing. The data collected including the number visitors, the source where they have come from, and the pages visited in an anonymous form.
_hjid	Hotjar cookie. This cookie is set when the customer first lands on a page with the Hotjar script. It is used to persist the random user ID, unique to that site on the browser. This ensures that behavior in subsequent visits to the same site will be attributed to the same user ID.
_hjIncludedInSample	This cookie is set to let Hotjar know whether that visitor is included in the sample which is used to generate heatmaps, funnels, recordings, etc.
has_recent_activity	This cookie is used to signal to the code repository website if the user has browsed other website resources during the current session.
tk_ai	Gathers information for our own first-party analytics tool about how our services are used. A collection of internal metrics for user activity and is used to improve user experience.
tk_lr	This cookie is set by the JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack.
tk_or	This cookie is set by the JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack.
tk_qs	Gathers information for our own first-party analytics tool about how our services are used. A collection of internal metrics for user activity and is used to improve user experience.
tk_r3d	The cookie is installed by JetPack. Used for the internal metrics for user activities to improve user experience.

Cookie	Description
_fbp	This cookie is set by Facebook to deliver advertisements when they are on Facebook or on a digital platform powered by Facebook advertising after visiting this website.
fr	The cookie is set by Facebook to show relevant advertisements to the users and measure and improve the advertisements. The cookie also tracks the behavior of the user across the web on sites that have Facebook Pixel or Facebook social plugin.

Importing WooCommerce Products Using Microsoft Excel File

Saving with .csv extension

Written by

Comments (2)

Got any query? Please leave a comment or reach out to our support
Cancel reply

Got any query? Please leave a comment or reach out to our support

Our plugins

Importing WooCommerce Products Using Microsoft Excel File

Saving with .csv extension

Written by

Comments (2)

Got any query? Please leave a comment or reach out to our support Cancel reply

Got any query? Please leave a comment or reach out to our support

Got any query? Please leave a comment or reach out to our support
Cancel reply