Export Shopify products to Excel or CSV — with the metafields the native export leaves out.
Let your agent work across all your spreadsheets for you.
Shopify does export products to CSV — but it drops your variant-level, legacy, and app-created metafields, and the file it hands you garbles accents and mangles leading-zero SKUs the moment Excel opens it. This page explains exactly where the native export falls short, and points you at a one-click complete export you can open in Excel as-is.
Get the complete product export
Importable runs the export from inside your Shopify admin — a live GraphQL pull, so there's no file to upload and nothing to map. It pulls every product and variant field plus the metafields the native CSV omits, and writes a file that opens cleanly in Excel.
Export your products in Importable →
Open the Products export section, choose Excel or CSV, and download. Free · no signup.
What Shopify's native product export actually includes
Give Shopify credit for what it does do: from Products in your admin you can export a products
CSV, and once you've defined product metafields under Settings → Custom data, those
product-level metafields do come out as namespace.key columns. So the
widespread belief that a Shopify product CSV comes out with none of your metafields is simply wrong — and a
page that repeats it is misleading you. The real gap is narrower and more specific.
The metafields the native CSV leaves behind
Three kinds of metafield are missing from the native product CSV, and Shopify doesn't warn you they're gone:
- Variant-level metafields. Product-level metafields export; per-variant metafields do not. If you store a variant spec, a lead time, or a per-variant code as a variant metafield, it isn't in the file.
- Legacy metafields. Metafields created before you added a matching definition (or left without one) aren't attached to an exported column, so they never appear.
- App-created and undefined metafields. Values an app wrote, or any metafield with no definition under Custom data, fall outside the exported column set entirely.
Why the file breaks the moment you open it in Excel
This part isn't Shopify garbling anything — it's how Excel reads a CSV. Shopify writes its export as UTF-8
without a byte-order mark, and Excel, absent that mark, decodes it as a legacy code page: an
accented name like Café comes through as Café. Excel also numeric-coerces any
cell that looks like a number, so a leading-zero SKU such as 007123 silently becomes
7123. Re-save from Excel and those corruptions are now baked into your file. A proper Excel
export writes a real .xlsx (or a BOM-marked CSV) so text stays text and SKUs stay intact.
A reviewed export, run in your own admin
The complete export runs inside the Importable app in your Shopify admin — it reads your store over the live API and hands you a file to download. It never writes back to your store, and there's nothing to upload here: the button above opens the export screen where you pick Excel or CSV and go.
Building a data pipeline instead of clicking? Install xlsx-for-ai and let your agent reshape a Shopify product export — dedupe, translate, or turn it back into an import CSV — over MCP.