Guide

Export large SQL results to CSV or Excel

Q: What is the best format for exporting millions of rows?

Use CSV for fast raw snapshots and XLSX when stakeholders need workbook output.

Q: How do I keep large exports reliable?

Control scope with limits and paging, then deliver files through notifications linked to run history.

Q: Where do DataPilot exports appear after a run?

Completed runs appear in the notification panel with download actions and run metadata.

When results get big, exports fail for predictable reasons: row limits, memory pressure, or slow downloads. This guide shows how to ship CSV or XLSX reliably while preserving run history and traceability.

Start free No credit card required. See exports

Related: scheduled exports and on-prem execution.

CSV vs Excel for large exports

Choose CSV when you need the fastest snapshot for sharing or downstream tooling. Choose XLSX when stakeholders need workbook delivery.

CSV: fastest generation, easiest ingestion in pipelines.
XLSX: business-friendly format for reporting workflows.

Limits, paging, and performance

Keep exports reliable by controlling scope. Raise limits only when necessary and prefer paging when datasets can be shipped in chunks.

When to raise limits

Raise limits for full extracts when execution time and network bandwidth are predictable.

When to page results

Page by date window, ID range, or partition key for safer repeatable delivery.

Large Excel exports

DataPilot supports large XLSX exports so teams can deliver workbook outputs even for high-volume results.

Exports product page Scheduled exports

Where the file appears

Completed runs appear in notifications with download actions and remain linked to run history metadata.