Skip to content
Guides

How to bulk edit Shopify products with a CSV or spreadsheet

Changing prices, tags, descriptions or inventory on hundreds of products one by one is slow. A spreadsheet is faster, but a careless import can overwrite good data across the whole catalogue. This guide covers the options and a routine that keeps you safe.

Updated 2026-11-18

Three ways to edit many products at once

  • The bulk editor in the Shopify admin. Select products and edit them in a grid. It is quick for a few fields, and you work inside Shopify's own screens.
  • Shopify's product CSV. Export the products, edit the file in Excel or Google Sheets and import it again. This reaches every field in the file, including variants and inventory.
  • A bulk editing app. The spreadsheet workflow with extra safeguards such as a preview of the changes and a backup you can restore.

What goes wrong with CSV imports

Most damage comes from a few repeated mistakes. Knowing them tells you what to check before you press import.

  • Blank cells. A column left empty can be read as an instruction to clear the value, so a half-filled sheet can erase descriptions, tags or prices.
  • Changed handles. The handle identifies the product. Edit it by accident and the import may create a duplicate instead of updating the original.
  • Wrong columns. Shopify's product CSV has a fixed set of column names. A renamed or misspelled header is skipped or misread.
  • Spreadsheet formatting. Excel can turn long barcodes into scientific notation and strip leading zeros from SKUs.
  • No way back. A finished import is not reversed by Shopify itself. If you have no copy of the earlier data, you rebuild it by hand.

A safe routine for bulk edits

  1. 01Export the products you are going to change and keep that file untouched as your backup.
  2. 02Copy it, then edit only the columns you need. Leave the handle alone.
  3. 03Check the numbers: sort the price column, look for zeros and blanks, and make sure SKUs and barcodes kept their leading zeros.
  4. 04Try a small batch of five or ten products first and look at them in the admin.
  5. 05Run the full import only when the small batch looks right, and look at the error report for rows that were skipped.

Where Sheetsmith fits

Sheetsmith is a Shopify app built around this routine. You export to CSV or Excel, edit in Excel or Google Sheets, or import from a Google Sheets, Google Drive or Dropbox link. Before anything is written, a preview lists which products will be created, updated or deleted, with errors by row.

Only the columns you include are applied and empty cells are left alone. Every product an import changes is backed up first and kept for 7 days, and Restore puts it back as it was, with the same IDs. It works with Shopify's product CSV format and handles 100,000+ products per job. There is a free plan for up to 50 products per job.

Frequently asked questions

Can I undo a Shopify CSV import?

Shopify does not offer a one-click undo for an import, so keep an export from before the change. Sheetsmith backs up every product an import changes and can restore it within 7 days.

Will empty cells erase my product data?

They can, depending on the tool. In Sheetsmith only the columns you include are applied and empty cells are left alone. To clear a value on purpose you type [clear].

Which format should I edit in, Excel or Google Sheets?

Either works. Watch for Excel turning long barcodes into scientific notation and dropping leading zeros from SKUs, and set those columns to text.

How many products can I edit at once?

Sheetsmith handles 100,000+ products per job. The free plan covers up to 50 products per job so you can try it on your own store first.

The app

Sheetsmith

Sheetsmith is a Shopify app for bulk editing products with Excel, CSV or Google Sheets. Every import is previewed before anything changes, products are backed up automatically, and any import can be undone in one click. Empty cells never wipe your data.

See Sheetsmith