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 collaborators to a spreadsheet by email. Each person needs their own Mixtable web app account, so access is always tied to a real login.
Give each collaborator read and write, read-only, or no access, sheet by sheet. Keep costs private, open tags for editing, and share an analytics sheet read-only.
Editing and publishing are different jobs. A dedicated permission controls who can run Sync to Shopify, independent of who can edit.
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. Nothing reaches your store until an authorized person reviews and syncs.
Change a collaborator's permissions or remove them 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 Permissions - [email protected] 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 someone with sync permission reviews the pending changes and runs Sync to Shopify.
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, a collaborator with sync permission opens a worksheet's preview, reads through the pending changes the team prepared there, and runs Sync to Shopify, one worksheet at a time. 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, sync permission | 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. Collaborators need their own Mixtable web app account, and access is per spreadsheet.
Getting started
Share the spreadsheet once, set the permissions, 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. Each collaborator needs a Mixtable web app account.
Choose read and write, read-only, or no access per worksheet, and who can sync.
The team edits together, and every change stays a highlighted draft until it is synced.
An authorized collaborator checks the preview and runs Sync to Shopify.
Questions
Open your Mixtable spreadsheet and share it by email with each teammate. They sign in with their own Mixtable web app account and see the same live, Shopify-connected spreadsheet you do, with the permissions you gave them.
Yes. Sharing is by email to people with a Mixtable web app account, so access is always tied to a real login. There is no anonymous or public link sharing.
Yes. Permissions are set per worksheet for each collaborator: read and write, read-only, or no access. A supplier can see only their product line while your costs tab stays completely hidden.
Yes. A separate permission controls who can run Sync to Shopify. The whole team can prepare drafts, and only the people you authorize can publish them to the store.
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 write access to just the worksheets they manage, like SEO fields, or a supplier read-only access to their products, and remove the access the day the engagement ends.
No. Every edit from every collaborator stays a highlighted draft in the spreadsheet. Your store only changes when someone with sync permission reviews the pending changes and runs Sync to Shopify.
Yes. You can change a collaborator's per-worksheet permissions 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.
