Mixtable Spreadsheet Editor

The only purpose-built spreadsheet bulk editor for Shopify.

Edit products, prices, inventory, and metafields with a live spreadsheet connected to your store. Use Excel formulas, skip the CSV files, and review every change before it syncs to Shopify.

From $15/month, with a 7-day free trial. Free for development, trial, and non-profit stores.

Trusted by thousands of Shopify stores

SpringartKeystone Safe CompanyKnockaroundCavalierSchumacherDecoralist

Why a spreadsheet

Built like a spreadsheet. Connected to Shopify.

Most bulk editors are forms in disguise. Mixtable is a real spreadsheet with a two-way connection to your store.

A real spreadsheet

Rows, columns, frozen panes, filters, sorting, copy and paste, right-click menus, and printing. Everything you expect, with thousands of products on one sheet.

Connected in both directions

Changes in Shopify flow into the sheet automatically. Your edits wait as pending changes until you review them and sync, so nothing lands by accident.

Excel-style formulas

=VLOOKUP, =IF, =CONCAT, =ROUND, =IMAGE. Your Excel muscle memory already works, with 150+ functions supported.

Prices

Re-price 5,000 products with one formula.

Drop a formula into a cell, fill it down the column, and every price recalculates. Percentage markups, currency conversions, and tiered pricing all work.

  • Mark down a whole collection by 15% with =ROUND(B2*0.85,2)
  • Set international prices per market with conversion rates and rounding
  • Prefer clicks to formulas? Bulk number changes adjust a whole column by a percentage or a fixed amount
  • Cell history shows each price and cost change, from Shopify or from a sync
Bulk edit Shopify prices

Metafields

Metafields without a separate metafield app.

Load any metafield as a column and edit its values the same way you would edit a title. Fill down, paste from Excel, or calculate with formulas.

  • Product, variant, customer, collection, and order metafields
  • Text, lists, references, and JSON are edited like any other cell
  • Apply one formula to every row of a metafield column
  • One app and one interface for all of it
Bulk edit Shopify metafields

Inventory

Inventory at every location, on one sheet.

One column per location, one row per variant. Set a quantity outright, or adjust it up and down with +25 or -5.

  • Multi-location inventory in a single grid
  • Adjust relatively or set absolutely, cell by cell
  • Paste counts straight from a stocktake spreadsheet
  • Preview every quantity change before it syncs to Shopify
Manage Shopify inventory

Formulas

Your Excel brain, already ready.

Mixtable supports 150+ Excel-compatible functions. If you have used a spreadsheet before, you already know how to use it.

=VLOOKUP()=IF()=ROUND()=CONCAT()=TEXTJOIN()=IMAGE()=LEN()=TRIM()=UPPER()=LOWER()=SUBSTITUTE()=SUMIF()=COUNTIF()=INDEX()=MATCH()=LEFT()=RIGHT()=DATE()=AND()=OR()and 130 more
  • Generate SEO titles=CONCAT(A2," - ",D2," | Acme")
  • Flag low stock=IF(E2<10,"LOW","")
  • Pull the vendor cost=VLOOKUP(B2,Costs!A:C,3,FALSE)
  • Swap images from a URL=IMAGE(H2)
  • Rewrite handles=LOWER(SUBSTITUTE(A2," ","-"))

Coverage

Everything in your Shopify store, on one spreadsheet.

Load any combination of these into a single spreadsheet and split them across worksheets.

Catalog

  • Products
  • Variants
  • Collections
  • Product images
  • Inventory

Custom and channel data

  • Metafields
  • Google Shopping fields
  • International pricing

Orders

  • Orders
  • Line items
  • Refunds
  • Refund line items
  • Order transactions

Customers

  • Customers

Content

  • Pages
  • Blogs
  • Blog posts

Compare

Why merchants switch to Mixtable.

If you edit Shopify data today, you are probably doing it one of these ways. Here is how they stack up.

MixtableShopify bulk editorCSV import and exportOther import apps
A real spreadsheet YesAn editing grid onlyOnly in ExcelNo
Connected to your store Both directionsYesManual re-importsScheduled
Excel-style formulas 150+ functionsNoneIn Excel, then re-uploadNone
Edit metafields Yes, as columnsLimitedError-proneExtra cost
Multi-location inventory One sheetQuantities by locationSeparate CSVYes
Review changes before they go live YesLive when you click SaveNo previewSome
Cell and row history YesNoNoSome
No CSV files to juggle YesYesThat is the whole workflowSometimes

Walkthrough

See the spreadsheet in action.

A guided tour of creating products, editing metafields, updating inventory, and changing prices in bulk.

  1. Create a Shopify products worksheet
  2. Create a product
  3. Add variants to a product
  4. Edit a product metafield
  5. Edit inventory at multiple locations
  6. Bulk update prices and inventory
  7. Bulk add a tag to multiple products
  8. Set international market prices

Reviews

Shopify merchants ship faster with Mixtable.

Mixtable streamlines our bulk pricing updates. It allows our brand and buying teams to focus on a single spreadsheet rather than multiple spreadsheets and manually updating Shopify.
Aid Station · Australia
This seemed to be the only app that could bulk edit items in our Shopify product catalogue to such a specific degree.
Schumacher · United Kingdom
The app itself is powerful and incredibly useful for managing large Shopify catalogs, but what truly sets Mixtable apart is their support team. They are on another level.
L'ARCO Shop · Belgium

Pricing

One price, set by your Shopify plan.

Your first plan starts with a 7-day free trial, and development, trial, and non-profit stores use it free. Everything is included on every plan, and you can cancel at any time.

Your Shopify planDevelopment, trial, and non-profit storesBasicGrowAdvancedPlus
Spreadsheet Editor$0 /month$15 /month$35 /month$35 /month$49 /month
Billed through Shopify, with your other app charges.Install on Shopify

Questions

Bulk editing Shopify: common questions.

The things merchants ask before they install.

How do I bulk edit products in Shopify?

Install the Mixtable Spreadsheet Editor from the Shopify App Store and open a products spreadsheet. Your catalog loads into a grid where you edit titles, prices, status, and any other field the way you would in Excel. Review the pending changes, then run Sync to Shopify to push them.

Can I bulk edit Shopify tags?

Yes. Tags get their own column across products, customers, and orders, so you can add, remove, or replace tags on thousands of records at once using find and replace, formulas, or paste. Nothing reaches your store until you sync.

Can I change prices by a percentage across my whole catalog?

Yes. Write a formula like =ROUND(B2*0.9,2) and fill it down the column, and every price recalculates at once. Base prices, compare-at prices, and international prices each get their own column.

Can I bulk edit Shopify metafields without a separate app?

Yes. Product, variant, customer, collection, and order metafields load as ordinary spreadsheet columns and are edited the same way as any other field.

What happens if I make a mistake?

Edits stay in the spreadsheet as pending changes until you choose to sync, and every sync shows them in a preview first. Change your mind about some of them? Select the cells and choose Revert to Shopify value to put them back the way they are in Shopify. After a sync, cell history and row history show what changed, when, and who synced it.

Can I format product descriptions without writing HTML?

Yes. Description and content cells on products, collections, pages, and blog posts have an Edit button that opens a visual editor with headings, lists, links, bold, and italics. You can also paste from Google Docs or Word and keep the formatting. The change waits in the spreadsheet until you sync it, like any other edit.

Do I need to import and export CSV files?

No. The spreadsheet is connected to your store in both directions, so there is no CSV to download, edit, and re-upload. You can still import a CSV when the data is coming from somewhere else.

How much does the Shopify bulk editor cost?

Plans start at $15 per month and are matched to your Shopify plan, up to $49 per month for Shopify Plus. Your store's first plan starts with a 7-day free trial, and development, trial, and non-profit stores are enrolled in the free plan automatically.

Stop fighting CSV files. Just open a spreadsheet.

Install Mixtable Spreadsheet Editor on your Shopify store. Most merchants have their first spreadsheet open in under 2 minutes.