How do I bulk generate from a spreadsheet?

The Spreadsheets integration allows you to generate hundreds of images or PDFs at once by mapping spreadsheet data to your studio templates. Upload a CSV/Excel file or manually enter data, then generate all variations with one click

How to Use#

1. Select a Template#

1. Navigate to Workspace > Integrations > Spreadsheets
2. Choose a template from your Studio templates
3. The spreadsheet columns will automatically match your template's modifications

2. Setup Your Data#

You can add data in two ways:

Upload a File:

• Click the "Import" button
• Select a CSV or Excel file with columns matching your template modifications
• The data will populate automatically

Manual Entry:

• Use the built-in spreadsheet editor to add rows
• Click "Add Row" to create new entries
• Edit cells directly by clicking on them
• Copy/paste from Excel or Google Sheets

3. Generate Images#

1. Configure your generation settings:

   • Format: PNG, JPEG, WebP, AVIF, or PDF
   • Type: URL or Base64
   • Row Range: Choose which rows to generate (e.g., rows 1-50)
   • File Name: Optional prefix for downloaded files
   • Scale: Image resolution scale

2. For PDF templates, set additional options:

   • Margin: Add spacing around content

3. Click "Start Generation" to begin bulk processing

4. Results appear in real-time with status indicators and preview thumbnails

Features#

• Bulk Upload: Import hundreds of rows from CSV or Excel files
• Live Preview: See generated images directly in the spreadsheet
• Pause/Resume: Control generation progress at any time
• Row Selection: Generate specific row ranges instead of all rows
• Multi-page Support: For PDF templates, generates multiple pages per row
• Batch Download: Download all generated images as a ZIP file
• Rate Limiting: Automatically handles API rate limits
• Error Handling: Failed generations are marked with error messages

Tips#

• Column names in your spreadsheet should match modification keys in your template
• Test with a small row range first before generating hundreds of images
• Use the pause button if you need to stop and resume later
• Download results as ZIP for easy organization and sharing
• Status column shows real-time generation progress (Pending, Success, Failed)

Need Help?#

Contact support at hi@orshot.com or use the chat button in your Orshot dashboard for assistance