Built for Shopify
It reads and writes
Most tools export a file and leave you to re-import it. The sheet is connected in both directions, so there is no CSV to download, fix, and upload again.
Built for Shopify
Your store, open in a spreadsheet.
Mixtable is an online spreadsheet that is connected to your Shopify store. Your products, orders, and customers load into the grid as ordinary rows and columns. You edit them the way you would edit anything in Excel, and nothing reaches Shopify until you review it and sync.
Six steps, then a loop.
The same three rows, shown at each stage. Watch the cells change and you have the whole product.
- 01
Connect your store
Install a Mixtable app from the Shopify App Store and approve the connection. That is the whole setup. There is nothing to configure and nothing to schedule.
An empty sheet, connected to your store - 02
Load the data you want
Pick what each row should be, such as products, orders, or customers, then pick the columns. Your records fill the grid, and the sheet keeps itself current as your store changes.
Your records, in the columns you chose - 03
Edit it like a spreadsheet
Type in a cell, write a formula, fill down a column, find and replace, or paste from Excel. Everything you change is held as a pending edit, marked in the grid.
Edited cells, still only in the sheet - 04
Review, then sync
See every pending change in one list before anything leaves the sheet. When it looks right, run Sync to Shopify and the updates are written to your store.
Written to Shopify, on your command - 05
Drop analytics into any row
Add an analytics column and pick a metric and a timeframe. Net sales, orders, quantity sold, refunds, and margin are calculated from your store's orders and land next to the product they belong to.
Net sales per product, last 30 days - 06
Export it to Excel or CSV
Download the spreadsheet as a real .xlsx file, or the worksheet you are on as a CSV. Column widths, colors, and number formats come across, so it opens looking the way you built it.
Downloaded as .xlsx, formatting intact
Then you leave it. The sheet stays connected, so next month you open the same one and it already has this month's numbers in it.
Why this beats a CSV round-trip.
It is a real spreadsheet
Formulas, fill down, sorting, filtering, find and replace, copy and paste, and cell formatting all behave the way they do in Excel. There is no new syntax to learn.
You decide when it lands
Edits sit in the sheet as pending changes until you sync them. Cell history and row history show what changed, when, and who changed it.
Pick the app that matches your job
All three are the same spreadsheet. They differ in what they let you do with it, and each is billed on its own, so you only pay for what you use.
Spreadsheet Editor
The planet's most powerful bulk editor. Products, prices, inventory, metafields, all in one sheet, synced live with Shopify.
Learn more →Analytics Spreadsheet
Live Shopify analytics inside a spreadsheet. Dynamic date ranges, formulas, segmentation. No BI tool, no waiting.
Learn more → Free foreverExplore & Export
One-click export of any Shopify data to Excel or CSV. Formatting preserved. No paywall. Accessing your data should be free.
Learn more →What you get in the grid.
Everything below works on your live Shopify data.
Excel-like online spreadsheet A spreadsheet interface that behaves just like Excel does, but everything runs in your browser.
Real-time updates from Shopify When data changes in your store, your spreadsheet will update almost immediately. You don't need to do manual syncs.
One-click updates to Shopify When you are ready click the "Done Editing" button and Mixtable will automatically sync your spreadsheet changes to Shopify.
Use the Excel formulas you already know Mixtable supports most Excel formulas. No need to learn something new.
Bulk number editor Use the Bulk Number Editor to modify cells with numbers in bulk. Saves you from manually modifying individual cells.
Bulk find and replace Find and replace content in cells in seconds.
Bulk tags editor Instead of editing cells, you can use the built-in Bulk tags editor to add or remove tags fast.
Bulk add images Add multiple images to your products from files or from a set of image URLs.
Sidebar Use the spreadsheet sidebar to show data that may not be mapped into a worksheet
Cell history See how a cell's value has changed over time
Row history See how all the cells in a given how have changed over time
Sorting Sort your worksheet as you would in Excel
Data filtering Want to only see products by a certain vendor? Use our Excel-like row filter
Lock rows and columns Lock the top row and left-hand-most column so they stay put while you scroll
Open your store in a spreadsheet.
Most merchants have their first sheet loaded within a couple of minutes of installing.
Get started free