---
title: "Bulk Add Image Alt Text in WordPress from a Spreadsheet"
url: "https://wpimportexport.com/bulk-update-image-alt-text-wordpress-spreadsheet/"
description: "Export images without alt text from the WordPress Media Library, write the descriptions in a spreadsheet and import them back to update all of them."
type: post
published: 2026-11-19T13:00:00+00:00
modified: 2026-11-14T10:37:16+00:00
categories: ["Export Guides", "Import Guides", "Tutorials"]
tags: ["CSV Export", "CSV import", "Import Export by RockStarLab", "WordPress automation"]
docs_topics: ["Bulk updates and automation", "Media workflows"]
---

# Bulk Add Image Alt Text in WordPress from a Spreadsheet

Six new hoodie photos in a shop, and none of them has alt text. Screen readers announce them as file names, and an accessibility check flags every one. Typing descriptions into the Media Library one image at a time is slow. With [Import Export by RockStarLab](https://wordpress.org/plugins/import-export-by-rockstarlab/) you export the images that have no alt text, write the descriptions in a spreadsheet and import them back in one go. The example below does exactly that for those six photos.

**Free:** Media export and import, including alt text.

## Short Answer

- Export **Media** with the filter **Alt Text** **Is Empty** and the columns ID, File Name, Attached Post Title and Alt Text.
- Write the alt text in the spreadsheet, then keep only the `ID` and `alt_text` columns.
- Import the file into **Media** with **Check for Existing Items by Field** set to ID and **Update** for matches.

## 1. Export the images without alt text

Go to **Export**, choose **Media** and add the filter **Alt Text**, **Is Empty**. On our test shop that matched 78 images, so we added a second filter, **File Name** **Contains** `hoodie`, to work on one product group at a time. The counter showed 6:

![Export Media with filters Alt Text Is Empty and File Name Contains hoodie, 6 items](https://wpimportexport.com/wp-content/uploads/2026/11/01-export-filters.webp)

_Find the images without alt text, one group at a time._

On the field step, we chose ID, File Name, Attached Post Title (the product or post the image belongs to) and Alt Text, and exported a CSV. The headers are the field keys, such as `alt_text`, so the import can map them by itself. To see thumbnails while you write, add **File URL** and open the links, or keep the Media Library open next to the spreadsheet.

## 2. Write the alt text

Describe what the image shows, in a short sentence. We looked at each hoodie and filled the `alt_text` column:

![Spreadsheet of six hoodie images with ID, file name, attached product and the new alt text](https://wpimportexport.com/wp-content/uploads/2026/11/02-alt-filled.webp)

_Write a short description for each image._

Before the import, delete the helper columns and keep `ID` and `alt_text`. Then only the alt text is changed.

## 3. Import the alt text

Go to **Import**, choose **Media**, upload the CSV and click **Auto Map**. Both columns were mapped: `ID` to ID and `alt_text` to Alt Text:

![Media import mapping: ID to ID and alt_text to Alt Text](https://wpimportexport.com/wp-content/uploads/2026/11/03-mapping-1.webp)

_Auto Map matches the two columns._

On the options step, set **Check for Existing Items by Field** to **ID**, **If Match Found** to **Update** and **If No Match Found** to **Skip**. The import updated all 6 images in 3 seconds, with 0 created:

![Import Completed Successfully: 6 updated, 0 created, 0 failed](https://wpimportexport.com/wp-content/uploads/2026/11/04-result-1.webp)

_All six images got their alt text._

Each image had its new alt text, and the file, title and the product it belongs to stayed the same. WordPress uses the alt text when it shows the image, so the product images now have it in their `alt` attribute.

## Before you import

The import changes the Media Library. Check the ID column, and [back up the site](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/) before you update hundreds of images. Alt text set inside a post’s Image block is stored in the post, not in the Media Library, so this import doesn’t change images that already appear in old posts with their own alt text.

## With an AI agent

An AI agent connected through the WordPress MCP Adapter (see [connecting Claude Code to WordPress](https://wpimportexport.com/connect-claude-code-to-wordpress-mcp/)) can check the result:

```
Show the alt text of the hoodie images.
```

In our run, the agent called `rsl-ie/export-preview` for `media` with the fields ID, file name and alt text and the search term `hoodie`. It returned the six images with their new alt text, from “Mint green zip-up hoodie, front view” to “Coral red pullover hoodie, front view”.

## FAQ

### How do I find images without alt text?

Export Media with the filter Alt Text Is Empty. The counter shows how many there are before you export.

### Will the import change the image files?

No. With only ID and alt_text in the file, the file, title and attachment stayed as they were in our test.

### Does this change alt text inside existing posts?

No. Images placed in posts keep the alt text saved in the post. The import changes the alt text in the Media Library, which is used when the image is added or shown from there, such as product images.

## Related Guides

- [How to Export WordPress Media Library Files to CSV or Excel](https://wpimportexport.com/export-wordpress-media-library-to-csv-excel/)
- [Export the Media Library with File Sizes to Find Large Images](https://wpimportexport.com/find-large-images-wordpress-media-library-file-sizes/)
- [Find Unattached Media in WordPress and Check If It Is Really Unused](https://wpimportexport.com/find-unattached-media-wordpress-unused-images/)
- [Bulk Change Post Status in WordPress with a Spreadsheet](https://wpimportexport.com/bulk-change-post-status-wordpress-spreadsheet/)

Get the free plugin on [WordPress.org](https://wordpress.org/plugins/import-export-by-rockstarlab/).
