How to Export Metadata from Airtable

Built-in CSV Download

Views + Extensions

Airtable REST API

import requests
import csv

API_TOKEN = "your_personal_access_token"
BASE_ID = "your_base_id"
TABLE_NAME = "your_table_name"
HEADERS = {"Authorization": f"Bearer {API_TOKEN}"}

def list_all_records():
    """List all records with pagination."""
    records = []
    offset = None
    while True:
        params = {"pageSize": 100}
        if offset:
            params["offset"] = offset
        resp = requests.get(
            f"https://api.airtable.com/v0/{BASE_ID}/{TABLE_NAME}",
            headers=HEADERS,
            params=params,
        )
        data = resp.json()
        records.extend(data.get("records", []))
        offset = data.get("offset")
        if not offset:
            break
    return records

records = list_all_records()

# Collect all field names across all records
all_fields = set()
for record in records:
    all_fields.update(record.get("fields", {}).keys())
all_fields = sorted(all_fields)

with open("airtable_metadata.csv", "w", newline="") as f:
    writer = csv.writer(f)
    writer.writerow(["Record ID", "Created Time"] + all_fields)
    for record in records:
        fields = record.get("fields", {})
        row = [record["id"], record.get("createdTime", "")]
        for field_name in all_fields:
            value = fields.get(field_name, "")
            # Handle attachment fields (list of objects)
            if isinstance(value, list) and value and isinstance(value[0], dict):
                value = "; ".join(
                    item.get("filename", item.get("url", str(item)))
                    for item in value
                )
            row.append(value)
        writer.writerow(row)

print(f"Exported {len(records)} records to airtable_metadata.csv")