Need to add alt text for many images fast? In Google Sheets, you can use =VISION()
to generate alt text, short captions, and image tags in bulk from image URLs.
Quick Start: Bulk Alt Text in Google Sheets
Put image URLs in column A, then in B2 use:
=VISION("Write concise alt text for accessibility (max 125 characters).", A2)Drag down to apply to all rows. You can also create caption and tag columns with different prompts.
Formula Examples: Alt Text, Captions, and Tags
=VISION("Write concise alt text for accessibility (max 125 characters).", A2)
=VISION("Write a one-line product caption with key visual details.", A2)
=VISION("Return 5 image tags separated by commas.", A2)
If you only pass one argument, =VISION(A2) can still describe the image.
Use explicit prompts when you want consistent output format.
URL Requirements and Troubleshooting
- Image not accessible: If your URL is from Google Drive, make sure sharing is set correctly. See Make Drive images accessible.
- Still blocked: Use
Upload/Download Files
to generate an accessible URL for
=VISION(). - Need formula syntax help: Check Formula reference.
=VISION vs =IMAGEN: Which One to Use?
Use =VISION() when you want to analyze an existing image
(alt text, OCR-style extraction, captions, tags).
Use =IMAGEN() when you want to generate a new image from text.
For broader setup tips, see
Google Gemini for Google Sheets.
FAQ
Q: Can I run this for hundreds of rows?
A: Yes. Keep your prompts short and consistent, then fill down your formula.
Q: Does this work with Google Drive links?
A: Yes, as long as the file is accessible. If not, fix sharing or use Upload/Download Files URLs.
Q: Is this only for alt text?
A: No. You can generate alt text, marketing captions, category tags, and simple visual summaries.