Import an Excel (XLSX) file into WooCommerce
Exact error message
- Invalid file type. The importer supports CSV and TXT file formats.
WooCommerce's built-in product importer doesn't read Excel files: it accepts only CSV and TXT. Drop your XLSX below. The tool converts it to a UTF-8, comma-separated CSV, replaces formulas with their values, checks it against WooCommerce's columns and gives you a file the importer accepts.
Wording and rules verified on
Fixed in your browser – your file never leaves your device.
Files over 50 rows: 1 credit each ($0.75–$1 depending on pack), no subscription · See prices
Several files? Select or drop them together to fix them all at once.
Sample files with typical import errors, loaded in your browser. Fixing and downloading them is free.
Why it happens
The importer checks the file type before reading anything, so an .xlsx is rejected straight away. Renaming it to .csv doesn't help: an XLSX file is a compressed package, and WooCommerce then reports "The file is empty or using a different encoding than UTF-8".
Saving from Excel works with the right option, "CSV UTF-8 (Comma delimited)". The plain "CSV" option uses your Windows code page, and in much of Europe it separates columns with semicolons, which WooCommerce reads as a single column unless you change the delimiter in the importer's advanced options.
How to fix it manually
Excel
- File → Save As → "CSV UTF-8 (Comma delimited) (*.csv)".
- Save each sheet separately: a CSV holds only the active sheet.
- Check that SKUs, EANs and prices kept their format (leading zeros, no 1.23E+12).
Google Sheets
- File → Import the XLSX.
- File → Download → Comma-separated values (.csv).
Before and after
Name;Regular price;SKU
Wool beanie;24,00;00123Name,Regular price,SKU
Wool beanie,24.00,00123A sheet saved as CSV on a German or Czech PC: semicolons and decimal commas. The converted file uses commas and decimal points and keeps the leading zeros.
Fix it automatically
- Reads XLSX files in your browser.
- Replaces formulas with their calculated values.
- Writes a UTF-8, comma-separated CSV.
- Checks WooCommerce's columns: Name, Type, Published, prices, SKUs, parents, image lists and categories.
Checking and the preview are free. Downloads are free up to 50 rows; a larger file costs 1 credit.
Choose a fileThe file is read and repaired inside your browser. Nothing is uploaded: only the row count and the platform are ever sent to us, so supplier prices and customer data stay private.