Woopify

How to export WooCommerce products to Excel, with product links

By the Woopify team5 min read

Short answer

WooCommerce exports products as CSV, which Excel opens directly. To keep accents, SKUs and prices intact, don't double-click the file. In Excel, use Data > From Text/CSV, pick 65001: Unicode (UTF-8) as the file origin, and set SKU columns to Text. The native export has no product URL column, but you can rebuild it from the Slug column with a formula such as ="https://store.com/product/"&E2.

Key takeaways

  • Import the CSV through Data > From Text/CSV in UTF-8, never by double-clicking it.
  • Format SKU and barcode columns as Text so leading zeros survive.
  • Rebuild product links from the slug, then use HYPERLINK to make them clickable.

Step 1: get the CSV

Export the catalog from Products > All Products > Export (full walkthrough). If you can't log in to the store, a WooCommerce scraper gives you the same native CSV from the public catalog.

Step 2: open it in Excel without breaking anything

When you double-click a CSV, Excel guesses the encoding and the type of every column. That is how « é » becomes « é », a SKU such as 00125 becomes 125, and long barcodes switch to scientific notation.

  1. Open a blank workbook, then go to Data > From Text/CSV and select the file.
  2. Set File origin to 65001: Unicode (UTF-8) and the delimiter to Comma.
  3. Click Transform Data, select the SKU, barcode (GTIN/EAN) and ID columns, and set their type to Text.
  4. Click Close & Load. Save the result as .xlsx to keep your formatting.

Re-importing into WooCommerce? Re-export from Excel as CSV UTF-8 (Comma delimited), not plain CSV.

Step 3: add a product link column

The native WooCommerce exporter has no product URL column. Every product has a Slug, though, and by default WooCommerce builds product URLs as /product/<slug>/. Add a column and use:

=HYPERLINK("https://yourstore.com/product/"&E2&"/", "View product")

Replace E2 with the first cell of the Slug column and fill the formula down. If the store uses a custom product base (Settings > Permalinks), replace product with that base. Variation rows have no public page of their own, so filter them out with the Type column first.

Shopify works the same way: the URL is /products/<handle>, built from the Handle column.

Useful Excel checks before an import

  • Duplicate SKUs: use Conditional Formatting > Highlight Cells Rules > Duplicate Values on the SKU column.
  • Missing prices: filter the Regular price column for blanks, excluding variable parent rows.
  • Broken images: filter the Images column for blanks to find products without photos.
  • Price changes: add a column such as =H2*1.1 for a 10% increase, then paste it back as values.

Frequently asked questions

Can WooCommerce export directly to .xlsx?

Not natively: the built-in exporter produces CSV. Excel opens CSV files, and some paid export plugins write .xlsx directly.

Why are accents broken when I open the export in Excel?

The file is UTF-8 and Excel reads it with another encoding when you double-click it. Import it through Data > From Text/CSV with File origin set to 65001: Unicode (UTF-8).

How do I export WooCommerce product links to Excel?

Export the catalog, then build the URL from the Slug column: =HYPERLINK("https://yourstore.com/product/"&E2&"/"). Use your store's product base if it isn't 'product'.

Export any Shopify or WooCommerce catalog to CSV

Free 25-product preview, no card. Premium at $38.99/month for unlimited full exports, cancel anytime.

Try it freeSee pricing