Load your customer list into a spreadsheet that stays connected to your Shopify store. Update contact details, tags, tax settings, language, and supported metafields across thousands of customers at once, then review every change and sync to Shopify when ready.
Mixtable loads your customers into a spreadsheet that stays connected to your store. Edit like in Excel or Google Sheets, then sync reviewed changes back to Shopify.
Edit names, emails, phone numbers, tags, notes, tax exemptions, language, and supported customer metafields, all as columns in one sheet.
Add or remove tags across thousands of customers with the bulk tag tools, powering segments, VIP tiers, wholesale groups, and store automations.
Start from a ready-made customers worksheet, or build your own with standard fields, all fields, or a custom ordered field set.
Bring in a customer list from another platform or a signup sheet. Map the columns, match existing rows by email or ID, and preview before applying.
Add Net Sales, Average Order Value, Customer Lifetime Value, order count, returns, and segment analytics beside each profile, so customer work starts with how people actually buy.
Export customers to Excel or CSV for email tools or audits, and bulk delete supported customers when you must, with a full preview first.
Customer records drift: inconsistent capitalization, outdated tax settings, the wrong language for half your French customers. In a spreadsheet those fixes take one pass, with formulas or without them.
Customer tags drive Shopify segments, discounts, wholesale gates, and app automations. With order count and total spent beside each profile, you can build tag rules from real behavior instead of guesswork.
Moving from another platform, syncing a signup list, or feeding an email tool? Customer data flows both ways: drag in a CSV with column mapping and duplicate warnings, or export your list to Excel or CSV in one click.
Mixtable is not a full CRM platform, and does not try to be. What it gives you is the useful core: every customer in a row, purchase behavior beside contact details, and filters by segment or country, in a sheet your whole team already knows how to read.
Customer edits stay as highlighted drafts in your worksheet. Open the preview, check each pending value, then run Sync to Shopify. That matters most for deletes, which are previewed the same way and are permanent once synced.
Editable profile fields load as regular columns. Addresses, order counts, and spend can be included as read-only context.
Most stores juggle the admin, CSV files, and maybe a CRM. Here is how they compare when the whole customer list needs work.
| Customer task | Mixtable | Shopify admin | CSV import and export | CRM platforms |
|---|---|---|---|---|
| Edit many customers in one view | Yes, with a sheet | One at a time | In Excel, then re-upload | In their UI |
| Add and remove tags in bulk | Yes, with preview | Basic bulk actions | Overwrites the tag list | Own labels, not Shopify tags |
| Import customers from any CSV | Yes, mapped and matched | Strict template | Strict template | Into the CRM, not Shopify |
| See orders and spend beside profiles | Yes | Per customer page | Snapshot only | Yes |
| Edit customer metafields in bulk | Yes | One at a time | No | Rarely |
| Sales pipelines and outreach sequences | No, by design | No | No | Yes, their core job |
| Review changes before they go live | Yes, then Sync to Shopify | Saves instantly | Applies on upload | Own data, separate sync |
Comparison reflects typical customer data workflows. Shopify features can change over time.
No CSV wrangling, no page-by-page edits. Connect your store and work the list like a spreadsheet.
Install the Mixtable Spreadsheet Editor from the Shopify App Store and open a customers spreadsheet.
Use the Customers template, or pick your own field set including metafields.
Fix fields with formulas or typing, and use the bulk tag tools on filtered rows.
Every edit stays a highlighted draft, so you can confirm exactly what will update.
Push reviewed changes back to your store in one move when you are ready.
Install the Mixtable Spreadsheet Editor from the Shopify App Store, open a customers spreadsheet, and your customer list loads into a spreadsheet. Edit names, contact details, tags, tax settings, language, and supported metafields like normal cells, then review your changes and run Sync to Shopify.
Yes. The bulk tag tools add one or more tags to every selected row, or remove specific tags without touching the rest. Filter the worksheet first, preview the affected rows, and the changes stay drafts until you sync.
Yes. Drag a CSV onto your customers worksheet, map its columns to Shopify fields, and match existing customers by email or ID. You can update existing customers, add new ones, or both in one import, with a preview and duplicate warnings first.
Yes. Export the worksheet columns you choose to CSV, or the whole spreadsheet to Excel, ready for an email platform, an accountant, or an audit.
Yes. Order count and total spent load as read-only columns beside each profile, so you can sort by spend, tag VIPs, and build segments from real purchase behavior. They reflect Shopify's data and are not editable.
Yes. Language and tax exemption are editable columns, so you can set the right locale for notification emails or flag wholesale accounts as tax exempt across many customers in one pass.
Yes, for supported customers, and carefully. Deletions appear in the preview like any other pending change, and they are permanent once synced, so review the list before you run Sync to Shopify. Shopify itself restricts deleting some customers, such as those with order history.
It is a spreadsheet CRM view, not a full CRM platform. You get every customer in a row, purchase data beside contact details, tags and segments, and imports and exports. Pipelines, outreach, and ticketing belong to dedicated CRM tools.
Open Mixtable for your store and give your customer list the same care as your catalog.
