Batch
Batch runs one calculation across every row of a CSV. Use it when you have a spreadsheet of dates rather than a single question.
CSV requirements
- A header row, then one row per calculation.
- UTF-8, comma separated. Quote any value containing a comma.
- Dates in ISO format, YYYY-MM-DD. Times as HH:MM in 24-hour form.
- One operation per job. Split mixed work into separate files.
start_date,end_date
2026-01-05,2026-02-17
2026-03-01,2026-03-31Supported operations
Batch covers the same calculations as the API: date difference, adding and subtracting days, business days between dates, adding business days, and duration between two times. Business-day operations can use one of your saved Business Calendars.
Column mapping
After upload, Calcadian shows the first rows of your file and asks which column feeds which input. Your headers do not have to match any particular naming. The mapping is shown back to you before the job starts, so you can catch a swapped start and end column before processing rather than after.
Row errors
A bad row does not stop the job. Each output row carries a status and, where relevant, an error code and a short message, in the calcadian_status, calcadian_error_code and calcadian_error_message columns. Fix those rows and re-upload just them.
Limits
| Pro | Business | |
|---|---|---|
| Rows a job | 5,000 | 50,000 |
| File size | 10 MB | 50 MB |
| Jobs at once | 1 | 3 |
| Jobs an hour | 10 | 30 |
| Results kept for | 7 days | 30 days |
A file over the row limit is rejected before processing, with the row count and your limit in the message. Split it and upload the parts.
Storage, expiry and privacy
- Your uploaded CSV is stored privately while the job runs and is deleted once processing finishes.
- The generated result file is kept temporarily so you can download it. The expiry date is shown next to the job in your dashboard.
- You can delete a result earlier than its expiry, at any time.
- Result files are private to your account and are served through short-lived signed links.
Batch is a server-side feature, so unlike the browser calculators the data in your file is processed on Calcadian servers. That is what makes the job possible. Only the rows you upload and the results they produce are stored, and only for the retention period above.