Use case for Mixtable Spreadsheet Editor
Load your SEO titles and meta descriptions into a spreadsheet connected to your Shopify store. Spot missing, duplicate, too-short, or too-long fields, rewrite them at scale with formulas or plain typing, then review every change and sync to Shopify when ready.
SEO Cleanup - Acme Apparel Sync 3 changesPreview Trusted by thousands of Shopify stores
What you can do
Mixtable loads your SEO titles and meta descriptions into a spreadsheet that stays connected to your store. Audit and rewrite them like you would in Excel or Google Sheets, then sync reviewed changes back to Shopify.
Edit SEO titles and meta descriptions for products, pages, and blog posts in their own worksheets, and load collection SEO fields with the Collections template.
Add Net Sales and order count with Mixtable Analytics Spreadsheet to prioritize important products, then use formulas like =LEN() and =COUNTIF() to flag missing, duplicate, too-short, or too-long SEO fields.
Build SEO titles from product titles, vendors, types, or categories with a formula, fill it down the column, and every row gets a consistent pattern.
Prefer point and click? Use find and replace with preview to strip obsolete copy, or simply type and paste better titles straight into the cells.
Update URL handles carefully where you need to, and edit product image alt text in bulk from a media images worksheet.
Work with product-category metafields and SEO-oriented metafields alongside the standard fields, in the same connected spreadsheet.
Load any of these into a connected worksheet, keep helper columns like length checks beside them, and sync only the fields Shopify stores.
In the spreadsheet
SEO Audit - Products Sync 2 changesPreview You cannot fix what you cannot see. Load every SEO title and meta description into columns, add a couple of helper formulas, and the problems sort themselves to the top of the sheet.
Guide: Audit your store SEO Titles - Pattern fill Sync 4 changesPreview Once you can see the gaps, filling them is the easy part. Build a title pattern from the fields you already have, fill it down, and adjust the rows that deserve a human touch. No formula skills? Plain typing, copy and paste, and find and replace work on the same columns.
Guide: Rewrite your titles Collection SEO - Acme Apparel Sync 4 changesPreview Product pages are only part of your store. The Collections template loads collection SEO titles and meta descriptions, while pages and blog posts use their own worksheets in the same spreadsheet.
Guide: Cover your whole storeReview and sync
SEO edits stay as highlighted drafts in your worksheet, including values a formula produced. Open the preview, check each pending title and description, then run Sync to Shopify. Nothing changes on your store until you do.
| Row | Product | Field | Pending value |
|---|---|---|---|
| 2 | Merino Crew Sweater | SEO title | Merino Crew Sweater | Acme=B4&" | Acme" |
| 3 | Cotton Tee | SEO description | Soft everyday tee in five colors |
| 4 | Classic Oxford Shirt | SEO title | Classic Oxford Shirt | Acme Apparel |
| 5 | Corduroy Cap | SEO description | Soft cotton corduroy cap with a curved brim |
| 6 | Linen Trouser | Handle | linen-trouser |
Compare
Most stores fix SEO fields one page at a time or hand the job to an app. Here is how the approaches compare when hundreds of pages need work.
| SEO task | Mixtable | Shopify admin | CSV import and export | SEO apps |
|---|---|---|---|---|
| See every SEO title and description in one view | Yes, with a sheet | One page at a time | Products only, then re-upload | Varies |
| Find missing, duplicate, or overlong fields | Formulas and filters | No | In Excel, manually | Often flagged |
| Build titles from product data | Excel-style formulas | No | In Excel, then re-upload | Fixed templates |
| Cover collections, pages, and blog posts | Yes | Yes, one at a time | No | Varies by app |
| You approve every change | Review, then Sync to Shopify | Live when you click Save | Applies on upload | Some auto-apply |
| Keep a history of what changed | Cell and row history | Admin events only | No | Rarely |
Comparison reflects typical SEO cleanup workflows. Shopify features can change over time.
Getting started
No CSV exports, no page-by-page clicking. Connect your store and work through your SEO fields like a list.
Install the Mixtable Spreadsheet Editor from the Shopify App Store and open a spreadsheet for your SEO work.
Add SEO columns to product, page, or blog post worksheets, or use the Collections template for collection SEO fields.
Use =LEN() and =COUNTIF() to flag missing, duplicate, and overlong fields, then sort.
Fill patterns down with formulas, or use typing, paste, and find and replace.
Check every pending change in the preview, then run Sync to Shopify when ready.
Questions
In the Shopify admin you edit them one page at a time in the search engine listing section. With Mixtable you load the same fields into a spreadsheet as columns, edit hundreds or thousands of rows at once, then review your changes and run Sync to Shopify.
Yes. SEO titles and meta descriptions become columns in a products worksheet, so you can rewrite them with formulas, fill down a pattern, paste from another sheet, or use find and replace across the entire catalog.
Load the meta description column, open the worksheet filters, and filter that column to show empty cells. The worksheet will show only the product rows with missing meta descriptions, ready for you to update.
Yes. Use a formula that combines fields you already have, like =B2&" - "&C2&" | Your Store", and fill it down the column. Every product gets a consistent, keyword-bearing title, and you can still hand-edit the pages that matter most.
Yes. The Collections template includes collection SEO title and description columns, while pages and blog posts use their own worksheets. Blog, article, and page data can require a manual download before editing.
Yes. Alt text lives on your product images, and Mixtable exposes it in a media images worksheet so you can write or fix alt tags across many images at once, then sync the changes.
No. Every edit stays a highlighted draft in the worksheet, including formula results. You review the pending changes in the sync preview and run Sync to Shopify when you are ready.
Keep going
Adjacent workflows and the help articles behind this page.
Open Mixtable for your store and clean up every title and description in one sitting.
