Use case for Mixtable Spreadsheet Editor
Share a live Shopify spreadsheet with your team, agency, or suppliers. Give each person the right access per worksheet, control who can sync changes to Shopify, and see what changed and who synced it. Everyone works on drafts until an authorized person pushes them live.
Share spreadsheet - Acme Apparel Trusted by thousands of Shopify stores
What you can do
Mixtable spreadsheets are built for more than one pair of hands. Share them, scope what each person can see and change, and put every change to Shopify behind a deliberate sync, with a history of who synced what.
Invite people to a spreadsheet by email. They open it with a free Mixtable login, or with a private link and a password you give them, so access always belongs to a named person.
Tick, sheet by sheet, what each person can see, edit, or add Shopify data to. Keep costs hidden, open product copy for editing, and share reports view only.
Editing and publishing are different jobs. People with Can edit leave their changes for you to review and sync, and only people you give Can edit and sync send changes to Shopify themselves.
For cells linked to Shopify, see each change with its old and new value, when it happened, and whether it came from Shopify or from a Mixtable sync, including who ran the sync.
Everyone's edits stay highlighted drafts in the spreadsheet, and a notice tells you who made how many. Nothing reaches your store until an authorized person reviews and syncs.
Change someone's access or remove it whenever you need, per spreadsheet, without touching your Shopify staff accounts.
Sharing works on any Mixtable spreadsheet, whatever Shopify data it holds, from products and prices to orders and B2B companies.
In the spreadsheet
Collaborators - Spring Spreadsheet The usual workaround is exporting a file and emailing it around, then guessing which copy is current. A shared Mixtable spreadsheet is one live version, connected to your store, that everyone with access works in together.
Guide: Invite your team Customize access - agency@studio.co Not everyone should see everything, and fewer still should edit it. Permissions apply per worksheet, so an agency can rewrite SEO fields without ever opening your costs, and finance can read margins without risking a stray edit.
Guide: Scope the access Review Tracker - This week The team fills in drafts all week: new copy from the agency, price updates from ops, tags from the intern. None of it touches Shopify until you review the pending changes and sync them, or until someone you gave Can edit and sync does.
Guide: Set up your review flow Row history - Classic Oxford Shirt Shared editing only works with accountability. Cell history lists the changes to a Shopify field, newest first, and Row history does the same for the Shopify fields in a row. Each change shows the old and new value, when it happened, and whether it came from Shopify or from a Mixtable sync, with the name of whoever clicked Sync. A surprise price becomes a lookup, not an investigation.
Guide: Keep the paper trailReview and sync
When the work is ready, you open a worksheet's preview, read through the pending changes the team prepared there, and sync them to Shopify, one worksheet at a time. People you gave Can edit and sync can do the same. Editing is shared, publishing is deliberate.
| Row | Product | Field | Pending value |
|---|---|---|---|
| 2 | Classic Oxford Shirt | Status | Active |
| 3 | Linen Trouser | Title | Linen Drawstring Trouser |
| 4 | Merino Crew Sweater | Tags | fall, bestseller |
| 5 | Corduroy Cap | Vendor | Acme Basics |
| 6 | Cotton Tee | Product type | T-Shirts |
Compare
Teams usually improvise with shared logins or emailed files. Here is how the options compare when several people touch the same store data.
| Collaboration task | Mixtable | Shared admin access | Emailed spreadsheets | Google Sheets copies |
|---|---|---|---|---|
| Work on live Shopify data together | Yes, one connected spreadsheet | Yes, in the admin | Stale copies | Stale copies |
| Limit access per worksheet | Yes | Coarse staff permissions | No | Per file or tab, manual |
| Separate editing from publishing | Yes, you choose who syncs | No, edits are live | Whoever re-imports | Not connected to Shopify |
| See what changed and who synced it | Cell and row history | Admin events, coarse | No | Version history, no sync |
| Safe for agencies and suppliers | Scoped, revocable access | Risky, broad access | Data leaves your control | Data leaves your control |
| Changes reach Shopify | A reviewed sync | Instantly, unreviewed | Manual re-import | Copy-paste back |
Comparison reflects typical team workflows. Each person opens the spreadsheet with a Mixtable login or a private link and password, and access is per spreadsheet.
Getting started
Share the spreadsheet once, set the access, and let the drafts flow in.
Install the Mixtable Spreadsheet Editor from the Shopify App Store and open the spreadsheet you want to share.
Share the spreadsheet by email. They open it with a free Mixtable login, or a private link and password.
Pick Can view, Can edit, or Can edit and sync, then fine-tune each worksheet in Customize.
The team edits together, and every change stays a highlighted draft until it is synced.
You check the preview and sync to Shopify, or let people with Can edit and sync do it.
Questions
Open your Mixtable spreadsheet, click Share, and invite each teammate by email. They open it with a free Mixtable login, or a private link and a password you give them, and see the same live, Shopify-connected spreadsheet you do, with the access you gave them.
Not necessarily. They can create a free Mixtable login with the email address you invited, or open the spreadsheet with a private link and a password you give them, with no sign-up. Either way, access belongs to one named person. There is no anonymous or public link sharing.
Yes. For each person and worksheet, you tick what they can do: see and download it, edit its cells, or add Shopify data to it. A supplier can see only their product line while your costs worksheet stays completely hidden.
Yes. People with Can edit leave their changes for you to review and sync, and only people you give Can edit and sync send changes to Shopify themselves. The whole team can prepare drafts, and nothing reaches the store until someone you trust syncs it.
Yes, for cells linked to Shopify. Cell history and Row history list each change with the old and new value, when it happened, and whether it came from Shopify or from a Mixtable sync, including who ran the sync. Edits that are still drafts are not in the history yet.
Yes, that is one of the best fits. Give an agency edit access to just the worksheets they manage, like SEO fields, or a supplier view-only access to their products with a private link, and remove the access the day the engagement ends.
No. Every edit stays a highlighted draft in the spreadsheet. Your store only changes when you review the pending changes and sync them, or when someone you gave Can edit and sync does.
Yes. You can change what someone can do in each worksheet, or remove them from the spreadsheet, at any time, without touching your Shopify staff accounts.
Keep going
Adjacent workflows and the help articles behind this page.
Open Mixtable, share the spreadsheet, and keep publishing exactly as controlled as you want it.
