Importing WooCommerce Products Using Microsoft Excel File

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 :

csv file — **Sample of excel spreadsheet**

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 No

On this page

Saving with .csv extension

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.

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 session on the website. The cookie is a session cookies 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 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, camapign data and keep track of site usage for the site's analytics report. The cookies store information anonymously and assigns a randoly 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 of how visitors use a website and helps in creating an analytics report of how the wbsite is doing. The data collected including the number visitors, the source where they have come from, and the pages viisted 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, used to improve user experience.
tk_lr	This cookie is set by 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 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, used to improve user experience.
tk_r3d	The cookie is installed by JetPack. Used for the internal metrics fo user activities to improve user experience

Cookie	Description
_fbp	This cookie is set by Facebook to deliver advertisement when they are on Facebook or a digital platform powered by Facebook advertising after visiting this website.
fr	The cookie is set by Facebook to show relevant advertisments 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

Leave a Reply
Cancel reply

Leave a Reply

Importing WooCommerce Products Using Microsoft Excel File

Saving with .csv extension

Share this post

Written by

Leave a Reply Cancel reply

Leave a Reply

Leave a Reply
Cancel reply