How to Export Airtable Data to CSV, Excel, and PDF

There's a moment in nearly every Airtable project when someone asks "can you just send me a CSV?" — usually a finance team, an auditor, or a client who hasn't been onboarded to your base. Knowing exactly how to export Airtable data to CSV, Excel, and PDF — manually for one-offs and on a schedule for recurring needs — saves hours of back-and-forth.

This guide covers every export path Airtable supports, including the bits that aren't obvious: bulk attachment downloads, scheduled exports, and the right tool for converting Airtable records into PDFs.

The Five Export Methods

The first two are what 90% of users actually need. The last three matter when exports become a recurring obligation rather than an occasional ask.

Method 1: Export a Single View to CSV

The fastest export Airtable offers. The CSV contains exactly what the view shows — same columns, same filter, same sort.

1. Open the table.
2. Pick or create the view you want to export. This is the critical step — if the view has the wrong filter, your CSV has the wrong rows.
3. Click the view name at the top of the table to open the view menu.
4. Click Download CSV.
5. The file downloads with the view's name as the filename.

A few details that trip people up:

• Hidden columns are excluded. If you hid a column for screen real estate, it won't appear in the CSV. To include it, unhide it first or use a dedicated "Export" view with every needed column visible.
• Linked records export as the primary field text. If your Project record links to Client "Acme Corp," the CSV gets "Acme Corp" — not the record ID. If you need IDs, add a formula field RECORD_ID() and include it.
• Attachment fields export as a comma-separated list of URLs. Those URLs expire in a few hours, so the CSV is not a real attachment backup. See the bulk attachment section below.
• Multi-select fields export comma-separated. If your delimiter is also a comma, downstream tools may misparse. Re-export with a single-select or a formula that wraps in quotes.

Method 2: Export to Excel

Airtable does not have a native one-click "Export to Excel" button. The path is two steps: export CSV (above), then open in Excel and save as .xlsx.

If you need true Excel format with multiple sheets, formulas, or formatting, use one of these instead:

Sync to Google Sheets, then save as Excel. Airtable has a native Google Sheets integration via Make or Zapier; Google Sheets exports to .xlsx directly.

Microsoft Graph API via Make/Zapier. Build a scenario that pulls Airtable records and writes them into an Excel Online file. Slower to set up but produces a real .xlsx with multiple tabs if you need them.

The CSV → Excel manual route. For one-offs this is fine. Save as .xlsx after opening to preserve types (Excel sometimes mangles long IDs as scientific notation; format the column as Text before pasting if so).

Method 3: Export to PDF

Airtable supports three PDF paths depending on what you're producing.

Print View (Grid PDF)

For a quick PDF of what's on screen:

1. Open the view.
2. Click the view menu (the view name dropdown).
3. Click Print view.
4. In the browser print dialog, choose Save as PDF as the destination.

Output is a plain grid — the same columns and rows you see on screen, paginated. Good for an internal record; not pretty enough for clients.

Page Designer Extension

For a record-per-page PDF — invoices, packing slips, certificates, proposals — use the Page Designer extension.

1. Add the Page Designer extension to the base.
2. Pick the source table.
3. Drag fields onto a page layout. Add static text, logos, and lines.
4. Click Print → Save as PDF.

The extension produces one PDF page per record. Combined with a button field that opens Page Designer at a specific record, this becomes a one-click invoice generator. We covered the broader document-generation pattern in our Airtable mail merge guide.

Automated PDF via Make or DocuPilot

For high-volume, branded, multi-page PDFs — proposals, contracts, monthly reports — Page Designer hits its ceiling. Use a document-generation service: DocuPilot, PandaDoc, or a Google Docs template merged via Make. The pattern is identical to what we use in automated proposals.

Method 4: Export Attachments in Bulk

Attachment fields hold files (PDFs, images, videos) stored in Airtable's CDN. Two facts surprise people:

1. The attachment URLs in a CSV export expire after a few hours.
2. There is no native "download all attachments" button.

To actually back up attachments, you need an automation. The pattern:

1. Trigger on a schedule (weekly) or per-record.
2. For each record with attachments, iterate through the attachment array.
3. For each attachment, make an HTTP GET to the current URL.
4. Write the bytes to Google Drive, Dropbox, or S3, with a folder/file name keyed to the record ID.

Make and Zapier both support this with their HTTP and iterator modules. For one-off "give me every PDF in this table" jobs, a 30-line Airtable script running from your terminal works too. For the ongoing case, see our Airtable backup guide — it covers attachment retention as part of a full base backup strategy.

Method 5: Automate Recurring Exports

If your finance team needs a CSV in their Dropbox every Monday morning, manual export will fail eventually. The fix is a scheduled automation.

Option A: Native Airtable Automation + Script

1. Create an automation with a scheduled time trigger (e.g. every Monday 8am).
2. Add a Run script action.
3. In the script, query the records you want, build a CSV string, and POST it to a cloud-storage webhook (Dropbox API, Google Drive API, S3 presigned URL).

Pro: no external tool. Con: requires JavaScript. See the Airtable scripting guide for the API calls.

Option B: Make or Zapier Scenario

The lower-code path.

1. Create a scenario with a Schedule trigger.
2. Add an Airtable → Search records step that returns the rows you want.
3. Add a CSV → Create CSV step (Make has this natively; Zapier needs a Formatter step).
4. Add a Google Drive → Upload file or Email → Send step.

This takes about 30 minutes to build and is what we use for most clients who want a permanent off-platform export. The Make Airtable guide covers the underlying patterns.

Option C: Serverless Function on Cron

Cloudflare Workers or AWS Lambda with a cron trigger, calling the Airtable API directly and writing to S3. Most flexible, most code. Use this when the export logic is too complex for Make scenarios — joining data across bases, calculating derived fields, encrypting the output.

A Quotable Comparison

Limits to Know

• CSV export has no row cap. A view of 100,000 records exports as one large CSV.
• The Airtable API rate limits at 5 requests per second per base. A large export-by-script needs to throttle or it will 429.
• Snapshots are not exports. They're internal point-in-time copies. To get the data out, duplicate the snapshot and export each table.
• Attachment URLs expire. Treat any attachment URL in a CSV as a temporary link, not a permanent reference.
• Free plan exports are unlimited. There's no metering on the CSV download itself, regardless of plan.

Common Mistakes

Exporting the default view instead of a clean view. The grid view shows your working state — hidden fields, mid-edit rows, archived records. Build a dedicated "Export" view with the exact columns and filter you want, then export from there.

Forgetting to convert linked records. If you need stable references (record IDs, not display names), add formula fields with RECORD_ID() and the linked record's ID before exporting. Names change; IDs don't.

Treating attachment URLs as permanent. They aren't. If you need attachment backups, download the bytes — see Method 4.

Manually exporting weekly forever. If you've exported the same view two weeks in a row, automate it. Method 5 takes an hour to set up and saves the hour-per-week forever.

Exporting sensitive data without redaction. A CSV with email addresses, SSNs, or payment details landing in someone's email inbox is a data leak. Build a redacted view with only the columns the recipient actually needs.

Troubleshooting

Where to Go Next

If your export need is recurring, the Airtable backup guide covers the full strategy for keeping a durable off-platform copy of your data — including schema, attachments, and historical snapshots.

For PDF-heavy exports — invoices, proposals, contracts — see Airtable mail merge and automated proposals. Both walk through document generation patterns that turn export into a productized workflow.

When the team needs to do real analysis on the exported data rather than store it, the natural next step is to skip CSVs entirely and connect Airtable directly to a BI tool — covered in our how to connect Airtable to Power BI guide. Airtable's own import and export documentation is worth keeping bookmarked for the latest edge cases.