Convert a supplier XLSX file to a WooCommerce-ready CSV

Choose and document the source sheet

List the worksheets and identify the one that contains the product records. Check for title rows, explanatory footnotes, hidden rows and repeated headers. Ask whether a separate sheet holds prices or variations. Do not combine sheets by row position unless their relationship is explicitly guaranteed.

Make a working copy and create a clean export sheet with one header row and one record per intended product or variation. Preserve a source row reference in your private review notes so a disputed value can be traced back. Keep internal notes out of the final importer mapping.

Resolve values before saving

Load SKUs and parent identifiers as text. Review formulas with the source owner and export approved values, not unreviewed expressions. Cached formula results may be stale if a workbook was generated without recalculation. Our local file checker flags formulas for review; it is not a spreadsheet calculation engine.

Check dates, decimal conventions and units separately. A formatted cell may show a rounded price while storing more precision. Decide the intended output and compare the saved text. Avoid applying the same numeric conversion to prices and identifiers simply because both look numeric.

Reopen the CSV and prove a small import

Save the chosen export sheet as a UTF-8 CSV with an explicit separator. LibreOffice’s CSV guide below describes text export options. Reopen the result with controlled settings and compare parsed row count, key identifiers and a few difficult descriptions against your approved sheet.

Map the file against a core export from staging. Test a simple product, a complete variation family and any unusual values before processing the full supplier catalog. The service can review XLSX sources, but the built-in WooCommerce product importer consumes CSV; accepting a workbook for review does not mean the plugin imports workbooks into WooCommerce.

Check the result

• The intended worksheet and record count are recorded.
• Approved literal values replace unresolved formulas.
• The final CSV retains exact identifiers, prices and column boundaries.