# Spreadsheets

> Generate images in bulk from your studio templates using spreadsheet data

- **URL**: https://orshot.com/docs/integrations/spreadsheets

---

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