How to open Store Exporter Deluxe exports in Google Sheets or Excel

Your export is downloaded, but the spreadsheet shows missing zeros, odd characters, or everything in one column. Most of these problems come from how Excel or Google Sheets reads the file, not from the data itself. This guide shows you which file format to pick in Store Exporter Deluxe, how to open it in Excel or Google Sheets, and how to fix the most common display problems.

Prerequisites

• Store Exporter Deluxe is active and licensed.
• You know how to run an export. See How to use Quick Export in Store Exporter Deluxe.
• Microsoft Excel on your computer, or a Google account with access to Google Sheets.

Step 1: Choose the right file format

The format you pick before you export decides how much clean-up you need afterwards. Use this table to choose:

To set the format:

1. Go to WooCommerce > Store Export.
2. Click Quick Export in the sidebar.
3. Complete Select Export Type and Export Fields as usual.
4. Open Export Options.
5. Under File Format, select the XLSX or CSV tile.
6. Click Run Export.
7. Click Download File when the export finishes.

For more on Excel-specific export settings, see How to export WooCommerce data to Excel (XLS/XLSX).

Step 2: Open an XLSX export in Excel

Double-click the downloaded XLSX file. It opens in Excel as a normal workbook with one row per record and, if Include column headers is selected in WooCommerce > Store Export > Settings > General, a header row at the top.

You don’t need any import steps for XLSX. Store Exporter Deluxe saves values that start with a zero, and long all-digit values such as barcodes, as text, so Excel shows them exactly as they are stored in WooCommerce.

Step 3: Open a CSV export in Excel

If you double-click a CSV file, Excel guesses how to read it. That guess can shorten long numbers, drop leading zeros in some versions, or show accented letters wrongly. Importing the file gives you control over how each column is read.

Import the CSV with From Text/CSV

These steps use the Windows menus. In Excel for Mac, choose Data > Get Data (Power Query) > Text/CSV, click Browse to select your CSV export, and click Next. The preview screen that follows matches steps 4 and 5.

1. Open a blank workbook in Excel.
2. On the Data tab, in the Get & Transform Data group, click From Text/CSV.
3. Select your CSV export and click Import.
4. In the preview, check that the columns are split correctly. If they aren’t, pick Comma from the Delimiter list.
5. Click Load.

Keep leading zeros with the Text Import Wizard

Use this method when a column such as SKU, postcode, or phone number must keep its leading zeros, or when accented letters look wrong after a normal import.

These steps use the Windows menus. In Excel for Mac, skip the one-time setup below and choose Data > Get Data (Power Query) > From Text (Legacy) in step 1 of Run the wizard.

Turn on the legacy wizard (one time)

1. In Excel, go to File > Options > Data.
2. Under Show legacy data import wizards, select From Text (Legacy).
3. Click OK.

Run the wizard

1. On the Data tab, click Get Data > Legacy Wizards > From Text (Legacy).
2. Double-click your CSV export.
3. In File origin, select Unicode (UTF-8). On Windows the entry can appear as 65001 : Unicode (UTF-8).
4. Choose Delimited and continue to the delimiter step.
5. Select Comma as the delimiter and continue.
6. Click a column that must keep leading zeros.
7. Under Column data format, select Text. Repeat the last two steps for each column that must keep leading zeros.
8. Click Finish.
9. In the Import Data dialog, choose where to put the data.
10. Click OK.

Step 4: Import a CSV export into Google Sheets

Import the CSV into a sheet. The import screen lets you control how Google Sheets reads each value.

1. Open Google Sheets and create a blank spreadsheet.
2. Click File > Import.
3. Upload your CSV export.
4. Under Import location, choose where the data goes, for example Insert new sheet(s) or Replace spreadsheet.
5. Leave Separator type on Detect automatically.
6. To keep leading zeros, clear the Convert text to numbers, dates, and formulas checkbox.
7. Click Import data.

Your export data now sits in a Google Sheet that you can sort, filter, and share like any other sheet.

Settings that change how your file opens

These two settings in WooCommerce > Store Export > Settings change how a spreadsheet opens your CSV. The Troubleshooting answers below use them.

Under Settings > Export Formats, Field Delimiter in CSV Format sets the character that separates cells. A comma is the default.

Under Settings > General, Date Format sets how dates are written. The 2026/05/16 (Y/m/d) option puts the year first.

Troubleshooting

Frequently asked questions

Need help?

If you have a question or run into any issues, we’re here to help.

• Premium users: Open a support ticket
• Free users: Visit our community forum