How to Bulk Add Alt Text to Shopify Product Images with a CSV

A step-by-step guide to filling in missing alt text across your whole Shopify catalog using the product CSV export and import. It includes a writing formula, worked examples and a pre-import safety checklist.

If your store has dozens or hundreds of product photos with empty alt text, adding it one image at a time in the Shopify admin is slow. The faster route is Shopify's own product CSV: export your products, fill in one column and import the file back.

This page walks through the whole process. It also covers how to write alt text that actually helps shoppers who use screen readers, and the mistakes that can damage your product data.

First, check how big the gap is

Before you start, find out how many images need work.

Counting the blanks tells you whether this is an afternoon job or a weekend job.

Step 1: Export a backup (do not skip this)

  1. In Shopify admin, go to Products.
  2. Click Export.
  3. Choose All products and CSV for Excel, Numbers, or other spreadsheet programs.
  4. Save this file somewhere safe and name it something like backup-before-alt-text.csv.

Never edit this backup. If anything goes wrong during the import, it is your way back.

Then export a second copy. That second copy is the one you will edit.

Step 2: Understand the columns that matter

Shopify's product CSV has many columns. For alt text, only four matter:

A product with several images takes up several rows. The first row holds the product details. The extra rows often contain only the Handle and the image columns. That layout is normal, so don't "fix" it.

Step 3: Write the alt text

Fill in the Image Alt Text cell on every row that has an Image Src. Leave every other column exactly as exported.

A simple formula

[What it is] + [key visible details: color, material, shape] + [what this particular photo shows]

The last part is what keeps several photos of the same product from all getting identical alt text. Image 1 might show the front, image 2 the back and image 3 the item being worn or used. The alt text should reflect that.

Writing guidelines

Worked examples

Here is the same product described poorly and then well.

Product: Speckled Stoneware Mug, Oatmeal glaze, 12 oz

Product: Sterling Silver Hammered Hoop Earrings, Small

Product: Linen Wrap Dress, Rust, variant image

Notice that each description would still make sense if someone heard it without seeing the page.

Step 4: Fill-in templates

Copy these patterns and swap in your details.

Front or main shot [Color] [material] [product type] with [one or two distinctive features], [angle or background]

Detail shot Close-up of [part of product] on the [product name], showing [texture, stitching, mark, clasp]

In-use or lifestyle shot [Product] [being worn / in use / styled] [where or how], [one detail that shows scale or context]

Variant shot [Product name] in [variant color or finish], [angle]

Packaging or group shot [Number] [products] [arranged how], [in packaging / with matching items]

Step 5: Test with one or two products first

Don't import the whole catalog on your first try.

  1. Make a small copy of your edited CSV that contains only the rows for one or two products. Keep the header row.
  2. Import it (steps below).
  3. Open those products in the admin. Check that the alt text appears on the right images and that titles, prices, descriptions, variants and inventory look unchanged.

If the result looks right, import the full file.

Step 6: Import the file

  1. Go to Products and click Import.
  2. Upload your edited CSV.
  3. Select the option to overwrite products with matching handles. Without it, Shopify won't update your existing products.
  4. Review the preview and confirm.

Read the wording next to the overwrite option carefully. With overwrite turned on, the values in your file replace what is in your store. If a column in your file is blank where your store has data, that data can be overwritten or cleared. This is the main reason to edit a full export rather than build a new file from scratch, and to change only the alt text column.

Large imports can take a while. Shopify will notify you when the import finishes.

Pre-import checklist

Run through this before you click import:

Common problems and fixes

When to do it by hand instead

If you only have a handful of images, editing in the admin is simpler and carries no import risk. Open the product, click each image and type the alt text. The CSV method pays off once you are dealing with dozens of images or more.

After it's done

Make alt text part of your listing routine. Write it at the same moment you upload a new product photo, and the backlog never builds up again.

More templates and kits
Browse the Quillwork shop