Spreadsheets & Data

Spreadsheets are the core workspace in Batcher.ai. Every data import, formula, and AI processing task happens within a spreadsheet. Think of them as dynamic workspaces tailored for bulk AI processing.

What is a spreadsheet?

A spreadsheet in Batcher.ai stores your data in a grid of rows and columns — just like Excel or Google Sheets. You import your data, write AI formulas, process rows in batch, and export results. Each spreadsheet is independent and can be named, edited, and processed individually.

Managing spreadsheets

Dashboard

The spreadsheet hub shows all your spreadsheets with:

Name and creation date
Last opened date
Quick actions (rename, delete, open)

You can favorite important spreadsheets for quick access, and search or filter through your collection.

Creating a new spreadsheet

Click “New Spreadsheet” from the dashboard
Enter data manually, upload a file, or use the AI Assistant to generate sample data
Your spreadsheet is saved automatically

Importing data

Batcher.ai supports the following file formats:

.CSV — Comma-separated values
.XLSX — Microsoft Excel files

Drag and drop your file into the upload area, or click to browse. The data appears immediately in the spreadsheet editor.

Tip: Make sure your first row contains column headers (e.g., “Product Name”, “URL”, “Category”). This helps both you and the AI Assistant understand the data structure.

Exporting data

After processing, click “Export Data” to download your spreadsheet with all original data and AI-generated results included.

Working with the spreadsheet editor

Cell editing

Click any cell to select it and type to enter data. Cells can contain:

Plain text — Static content like product names, URLs, descriptions
Formulas — Functions starting with = that compute values or call AI models

Row and column operations

Add rows — Extend your dataset with new entries
Add columns — Create new output columns for AI results
Delete columns — Remove unwanted columns (data shifts automatically)
Insert columns — Add a column at a specific position

Formula display

Toggle the formula bar to see the raw formula in a cell versus its computed result. This is useful for understanding and debugging multi-step workflows.

Processing your data

Once your formulas are in place, process the spreadsheet to execute all AI calls.

Queue management

Each processing run creates a job queue. You can:

Monitor progress in real time
See how many rows have been processed
Cancel processing at any time
View estimated completion time

Concurrency

Your subscription plan determines how many requests can be processed in parallel. Higher plans allow more concurrent processing for faster results.

Undo and restore points

Batcher.ai automatically creates restore points before every write operation:

Before formula injection
Before cell edits via the AI Assistant
Before bulk data changes

To undo a change:

Ask the AI Assistant: “undo the last change”
Multiple undo levels are supported (up to 10 steps back)

Data storage and limits

Encryption — All spreadsheet data is encrypted at rest
Cell limits — Depend on your subscription plan (see Profile & Subscription)
Table limits — The number of spreadsheets you can create depends on your plan
Persistence — Spreadsheets are saved automatically and persist until you delete them

Tips

Name your spreadsheets descriptively — Use names like “Product Catalog Q1” or “SEO Audit March” to stay organized
Use the AI Assistant for complex workflows — Instead of writing formulas manually, describe your goal in the AI Assistant and let it build the workflow
Test before processing — Run a small batch (3-5 rows) to verify your formulas produce the expected results
Favorite important spreadsheets — Star your most-used spreadsheets for quick access from the dashboard