Ecom Store Pro

Can you import an Excel file into Shopify?

Published ·
At a glance
Short answer
No — Shopify's built-in import accepts only UTF-8 CSV files, so save your Excel sheet as a CSV or use a third-party app.
What it imports
Products, customers, inventory, admin and POS users; orders and discounts are export only
File size
Up to 15 MB per CSV for products, inventory and customer data
Excel pitfalls
Leading zeros dropped, digits past the 15th rounded, sorting can detach product images
Supplier products
New products need only Title, plus URL handle if you add variants; draft marks them not ready to be sold
Excel-reading apps
Third-party, not built in — Matrixify's listing describes Excel, CSV and Google Sheets imports

Which file formats does the Shopify import accept?

Shopify's CSV help page names a UTF-8 CSV as the only file format for import and export. It covers products, customers, inventory, and admin and POS users; orders and discounts are export only. A product CSV can't exceed 15 MB, and customer and inventory files share the same 15 MB cap.

How to save an Excel sheet so the import works

Google Sheets saves UTF-8 by default: use File > Download > Comma-separated values (.csv, current sheet).

The Shopify CSV and import pages we read on November 14, 2026 don't name Excel's UTF-8 save option. Saving from Excel, check:

  • UTF-8 encoding. Shopify requires it to keep unexpected characters out of your content; if you can't confirm it in Excel, save through Google Sheets.
  • Commas between values. Check Excel's export settings.
  • Leading zeros and long numbers. Excel drops leading zeros and rounds digits past the 15th, which can break SKUs and barcodes — see what Excel does to numbers.
  • No sorting. Sorting in Excel or Numbers can detach products from their image links, losing the images.

Turning a supplier spreadsheet into Shopify products

Start from Shopify's sample product CSV minus its example products. New products need only Title, plus URL handle if you add variants; set Status to draft for items not ready to be sold, since products without a Status column upload as active.

Export a backup first
A product import can't be canceled once it starts, and you can't view a history of past imports.

Then open Products > Import and add the file. Deselect Publish new products to all sales channels to publish only to your online store. Without Overwrite products with matching handles, rows matching an existing handle are ignored (what Overwrite replaces).

In Shopify adminOpen in your store
  1. Products
  2. Import
The publish and overwrite options sit under the file you add, above Upload file.

Shopify Academy's video shows the whole route in the June 2023 admin.

How to Add Products using a CSV file || Shopify Help CenterShopify Academy walkthrough of adding products in bulk with a CSV file: preparing the file, formatting product data, uploading product images and importing products to the store.

For frequent supplier files, an app can take Excel directly: Matrixify's App Store listing describes Excel, CSV and Google Sheets imports. It's third-party, not built in — see what Matrixify does.

About This Article

This page was written by AI. Separate AI agents that did not write it check its figures and claims against official sources and test its links and interactive tools. A human editor sets the site's editorial direction, topics and rules and checks that pages are complete and display correctly, but does not check their facts or edit their text. Details may change — always confirm critical data at shopify.com.

Editorial Policy

Related questions

Products & inventory
Does importing a product CSV overwrite existing Shopify products?

Only with Overwrite products with matching handles selected; then each column you include, even a blank one, replaces existing values

Updated October 21, 2026

Products & inventory
Where do you see how many products you have on Shopify?

The Products page shows no full count: /count.json gives products only; of Shopify's three methods, only a CSV export also covers variants.

October 14, 2026

Products & inventory
How many products can you have on Shopify?

Unlimited on every Shopify plan; the caps are per product (2,048 variants, three options) and on very large imports.

October 15, 2026

Stay updated

Get notified about new articles

Subscribe to receive updates when we publish new Shopify guides and insights.