Papiral
PixelForge
Tabular
TabularCSV Cleaner for WooCommerce Import
Fix your WooCommerce product CSV before the importer rejects it.
WooCommerce's product importer is one of the most finicky in ecommerce. Whitespace in SKUs, blank required fields, and inconsistent category formatting all cause import failures or broken product listings. Tabular cleans your product CSV so WooCommerce accepts it on the first try.
Common WooCommerce CSV problems
These are the formatting issues that most often break WooCommerce imports — and the ones Tabular is built to fix.
- Whitespace in SKU fields causing 'invalid SKU' or duplicate product errors
- Blank required fields (Name, SKU, Regular Price) that block the import
- Inconsistent product category and tag formatting across rows
- Empty rows that WooCommerce tries to import as blank products
- Stale field values (old prices, discontinued tags) that need bulk updating
Recommended tools for WooCommerce
Each tool works directly in your browser — no download, no signup required.
Trim Whitespace
Strip leading and trailing spaces from every cell in your CSV or spreadsheet with one click.
Remove Empty Rows
Clean up blank rows from CSV and Excel files automatically. Get a compact, analysis-ready dataset.
Fill Empty Cells
ProReplace blank cells with a static value, or fill them from the cell above (forward fill) or below (backward fill).
Find & Replace
ProFind any text in your CSV and replace it across an entire column or the whole file — bulk editing made easy.
If you also need to bulk process product images, try PixelForge — our bulk image tool for resizing, converting, and optimizing product photos. Try PixelForge →
Frequently asked questions
Why does my WooCommerce product CSV import fail?
Common causes include: whitespace in the SKU column, empty required fields like Name or Regular Price, incorrect column headers, blank rows in the file, or incorrectly formatted product categories. Use Tabular's Trim Whitespace and Remove Empty Rows tools to fix the most common issues before importing.
What are the required columns in a WooCommerce product CSV?
WooCommerce's product importer requires at minimum: ID or SKU (for updates), Name, and Regular Price. Additional columns like Description, Categories, Tags, Stock, and Images are optional but must be correctly formatted. You can export a sample CSV from WooCommerce Products > Export to use as a template.
How do I fix duplicate SKU errors in WooCommerce CSV import?
Duplicate SKU errors are often caused by whitespace — 'SKU-123' and 'SKU-123 ' (with a trailing space) look like different SKUs in your spreadsheet but may conflict in WooCommerce. Use Tabular's Trim Whitespace tool to strip spaces from all cells, then re-import.
How do I bulk update product prices in a WooCommerce export CSV?
Export your products from WooCommerce, upload the CSV to Tabular, and use Find & Replace to update specific price values or use Fill Empty Cells to populate blank price fields. Download the cleaned CSV and re-import using WooCommerce's update mode.
Can I remove empty rows from a WooCommerce product CSV?
Yes. Use Tabular's Remove Empty Rows tool to delete any rows where all cells are blank. This prevents WooCommerce from trying to create empty product entries during import.
Ready to clean your WooCommerce CSV?
No account needed. Files are auto-deleted within 24 hours.
Start cleaning free