CSV Editing Workflow
The CSV workflow is ideal when you want to edit SEO data in a spreadsheet, collaborate with writers or translators, or make bulk changes offline.
Requires: Pro, Pro + BYOK, or Agency plan.
The workflow
Section titled “The workflow”1. Export your current data
Section titled “1. Export your current data”- Open the Bulk Editor and select the resource type (Products, Collections, Pages, or Blogs).
- Click Export CSV.
- A file downloads (e.g.,
seo-products-export.csv).
2. Edit in a spreadsheet
Section titled “2. Edit in a spreadsheet”Open the CSV in Google Sheets, Excel, or any spreadsheet app. You’ll see columns for:
| Column | Editable? |
|---|---|
id | No — don’t change this |
title | No — for reference only |
resource_type | No — for reference only |
seo_title | Yes |
seo_description | Yes |
image_alt_text | Yes |
Edit the seo_title, seo_description, and image_alt_text columns. Leave cells empty if you don’t want to change them.
3. Import the edited CSV
Section titled “3. Import the edited CSV”- Back in the Bulk Editor, click Import CSV.
- Select your edited
.csvfile. - The app matches rows by ID and loads changes as pending edits.
- A banner confirms how many changes were imported.
4. Review and save
Section titled “4. Review and save”Imported changes appear in the Bulk Editor just like manual edits. Use the character counters and SERP preview to verify everything looks right, then click Save.
Use cases
Section titled “Use cases”Team copywriting
Section titled “Team copywriting”Export the CSV, share it with your content team on Google Sheets, then import the finished copy. Multiple people can work on the spreadsheet simultaneously.
Translations
Section titled “Translations”Export English meta tags, send the CSV to a translator, and import the translated version into a store that targets a different locale.
Template-based editing
Section titled “Template-based editing”Use spreadsheet formulas to batch-generate meta tags. For example: ="Shop " & B2 & " | Free Shipping | YourBrand" in the seo_title column to create consistent titles across products.
Troubleshooting
Section titled “Troubleshooting”“0 changes imported”
- Make sure the
idcolumn matches the IDs of resources on the current page. The import only matches against the currently loaded page.
CSV looks garbled
- Ensure the file is saved as UTF-8 CSV. Some spreadsheet apps default to other encodings.
Changes not saving
- Imported changes are pending edits. You must click Save to push them to Shopify.