☰

What you can do with a Shopify spreadsheet

Mixtable loads your Shopify data into a spreadsheet that works like Excel, so most jobs that would mean a CSV export, a round of edits, and a risky re-import become a few minutes in a grid. Here are 27 of the jobs merchants use it for, grouped by what you are trying to get done.

Catalog

Edit the products, variants, prices, tags, and metafields that make up your catalog.

Bulk edit Shopify prices

Change base, compare-at, market, and B2B prices in bulk with a spreadsheet.

Bulk edit Shopify products

Update titles, descriptions, status, tags, categories, and more across your whole catalog.

Bulk edit Shopify variants

Add variants in bulk and update SKUs, prices, options, and other variant fields at scale.

Bulk edit Shopify tags

Add, remove, and clean up tags across products, customers, and orders.

Add products to Shopify collections in bulk

Update collection memberships across your catalog: filter, assign, review, then sync.

Bulk edit Shopify metafields

Turn every metafield definition into a column and update values at scale.

Manage Shopify inventory with a spreadsheet

Update quantities across locations, enable tracking, and fix inventory item fields in bulk.

Data

Move data in and out of Shopify, and manage orders, customers, and B2B records.

Import CSV data into Shopify

Map CSV columns to Shopify fields, match rows by SKU or handle, preview, then sync.

Manage Shopify orders with a spreadsheet

Organize orders into worksheets, edit order details in bulk, and sync when ready.

Export Shopify data to Excel

Load your store into a live spreadsheet, shape the columns, and download a real Excel file.

Bulk edit Shopify customers

Update profiles, tags, tax settings, language, and metafields across your customer list.

Manage Shopify B2B companies and catalogs

Work on companies, locations, metafields, and B2B pricing from one spreadsheet.

Growth

Update the SEO, content, translations, and feed fields that bring in traffic.

Bulk edit Shopify SEO fields

Fix missing, duplicate, or weak SEO titles and meta descriptions across your store.

Bulk edit Shopify pages and blog posts

Update pages and blog posts across your store with a spreadsheet.

Bulk edit Shopify Google Shopping fields

Fix categories, identifiers, attributes, and custom labels feeding your product feed.

Bulk edit Shopify translations

Edit supported translations by language, side by side with the source content.

Reporting

Build live reports on sales, customers, returns, channels, and markets.

Analyze Shopify product sales with a spreadsheet

Sales, quantity sold, and refunds by product or collection, plus profitability by variant.

Analyze Shopify customers

Orders, spend, average order value, and segments for every customer.

Shopify sales reports

Store-level sales, orders, refunds, and AOV, month by month.

Returns and refunds analytics

Return rates, reasons, refund amounts, and open returns.

Marketing attribution analytics

Sales by UTM campaign, source, landing page, and referrer.

Sales by channel analytics

Online store, POS, apps, and retail locations, side by side.

Fulfillment and delivery analytics

Fulfillment speed, delivery times, and volume by location or carrier.

Collection analytics

Sales, quantity, discounts, and returns for every collection.

B2B sales analytics

Revenue, orders, and AOV per company and location.

Markets sales analytics

Sales, AOV, and refunds per Shopify Market and country.

Team

Work on the same store data with the rest of your team.

Collaborate on Shopify data with a shared spreadsheet

Share spreadsheets, set per-worksheet access, and control who can sync to Shopify.

Pick the app that matches the job

Every use case above runs on the same spreadsheet. Which Mixtable app you install depends on what you need it to do.