How to send a scheduled Airtable export to Excel users

Airtable has no "export to .xlsx on a schedule" button. The practical route is a CSV file that Excel opens directly. Done right, your colleagues double-click the attachment and get clean columns, correct accents and sortable dates.

Why CSV, not .xlsx?

Excel, Google Sheets, Numbers, Power BI and almost every import tool read CSV. It's plain text, so it's small, diff-able and easy to archive. What goes wrong with CSV is nearly always one of the problems below, and they can all be fixed.

Problem 1: broken accents (é shows as Ã©)

Excel on Windows guesses the encoding of a CSV file. Without a hint it assumes an old Windows code page, so names like "Müller" or "São Paulo" come out garbled. The fix is a UTF-8 byte-order mark (BOM) at the start of the file. A file written with a BOM opens cleanly in Excel without an import wizard.

Problem 2: everything lands in one column

In countries that use a comma as the decimal separator (most of Europe), Excel may expect semicolons between fields. If a comma-separated file opens as a single column, use Data → From Text/CSV and choose "Comma" as the delimiter; Excel remembers the choice for that query, and Refresh re-reads a newer file saved in the same place.

Problem 3: linked records, lookups and attachments

Linked records export as the primary field values of the linked records, joined with commas.
Multi-selects and lookups become comma-separated text in one cell.
Attachments export as file names and URLs. Airtable's attachment URLs expire after a few hours, so don't rely on them in a monthly report.
Collaborators export as names (or emails), which is usually what a reader wants.

If a column is only useful inside Airtable, hide it in the export view.

Problem 4: formulas that start with = or +

A text cell beginning with =, +, - or @ can be interpreted as a formula when the CSV is opened in a spreadsheet, which is a known security risk ("CSV injection"). A careful exporter prefixes such cells with an apostrophe so they display as text, while leaving real numbers untouched.

Setting up the schedule

Create a dedicated view, for example "Excel export – do not edit", with the filters, sort and visible fields you want in the file.
Decide on the cadence: daily for operational lists, weekly for status reports, monthly for finance.
Choose how the file travels. Email is the simplest: everyone already has an inbox, and each email is a dated archive copy.
Use a dated filename such as Orders-2026-03-02.csv so files don't overwrite each other in Downloads.

You can build this with Make or Zapier (schedule → search records → CSV → email), or with a script on a server. Or let a tool built for it handle the encoding, escaping and paging for you.

Let ViewCourier do it

Connect a read-only Airtable token, pick a view, and choose daily, weekly or monthly at your time and timezone. Every run emails a clean CSV attachment to up to five people. The free trial lasts 14 days and needs no credit card.

Start free trial