# What is CSV Getter?

## What is CSV Getter?

CSV Getter is a data export middleware that turns your Airtable bases, Notion databases, Google Sheets, and uploaded CSV files into live, shareable URLs. Every time someone (or something) hits your URL, they get the latest data — in CSV, JSON, XML, HTML, or Excel-compatible format.

***

### The Problem CSV Getter Solves

Platforms like Airtable and Notion are great for managing data, but getting that data *out* — into spreadsheets, dashboards, scripts, or other tools — typically requires manual exports, Zapier workflows, or custom API integrations.

CSV Getter eliminates that friction. You connect your data source once, and get a permanent URL that always returns current data.

***

### How It Works

```
┌──────────────┐       ┌──────────────┐       ┌──────────────┐
│  Data Source  │──────▶│  CSV Getter  │──────▶│  Your App /  │
│  (Airtable,  │       │   Backend    │       │  Spreadsheet │
│   Notion,    │       │              │       │  / Script    │
│   CSV, etc.) │       │  Fetches &   │       │              │
└──────────────┘       │  Transforms  │       └──────────────┘
                       └──────────────┘
```

1. **Connect** — Link your Airtable, Notion, or Google Sheets account (or upload a CSV).
2. **Configure** — Select a table/database, choose fields, pick an output format, and name your endpoint.
3. **Use** — Access your endpoint URL from anywhere. CSV Getter fetches the latest data from your source, transforms it to your chosen format, and returns it.

Data is fetched **in real time** — there's no caching or syncing delay. Every request hits the source.

***

### Supported Data Sources

| Source            | Connection Method              |
| ----------------- | ------------------------------ |
| **Airtable**      | OAuth or Personal Access Token |
| **Notion**        | Notion integration (internal)  |
| **Google Sheets** | Google OAuth                   |
| **CSV Upload**    | Direct file upload             |

***

### Supported Output Formats

CSV Getter supports 10+ output formats. You can set a default when creating the endpoint, or override it per-request using the `?type=` URL parameter:

| Format          | `type` value      | Description                                       |
| --------------- | ----------------- | ------------------------------------------------- |
| CSV             | *(default)*       | Standard comma-separated values                   |
| JSON (Records)  | `json_records`    | Array of objects                                  |
| JSON (Split)    | `json_split`      | Columns and data arrays                           |
| JSON (Index)    | `json_index`      | Keyed by row index                                |
| JSON (Columns)  | `json_columns`    | Keyed by column name                              |
| JSON (Values)   | `json_values`     | Array of arrays (no headers)                      |
| JSON (Table)    | `json_table`      | Schema + data                                     |
| XML             | `xml`             | Standard XML document                             |
| HTML Table      | `html_table`      | Static HTML table                                 |
| Dynamic Table   | `dynamic_table`   | Interactive HTML table with search and pagination |
| Excel Web Query | `excel_web_query` | Optimized for Excel's "From Web" feature          |

See The Type Parameter for details and sample output for each format.

***

### Key Concepts

#### Endpoints

An endpoint is a configured connection between a data source and a URL. Each endpoint has:

* A unique URL (e.g., `https://api.csvgetter.com/abc123def456`)
* A data source (Airtable table, Notion database, etc.)
* Selected fields/columns
* A default output format
* Optional authentication (Bearer token)

#### Credits

Each time your endpoint URL is accessed (a "hit"), it uses one credit. Preview/sample requests from the dashboard are free. Credits reset monthly with your subscription. See Credits for details.

#### URL Parameters

Every endpoint URL supports query parameters that modify the output dynamically. You can change the format, filter data with SQL, add timestamps, trigger email notifications, and more — all without changing the endpoint configuration. See URL Parameters.

#### Scheduled Jobs

Paid users can set up scheduled jobs that automatically hit their endpoint URLs on a daily, weekly, or monthly cadence. Jobs can export to Google Drive, update Google Sheets, or trigger other integrations. Notifications are sent on success or failure.

#### Authentication

Endpoints can optionally require a Bearer token. When enabled, requests must include an `Authorization: Bearer <token>` header. This lets you share your endpoint URL without giving unrestricted access.

***

### Who Uses CSV Getter?

* **Business analysts** who need Airtable data in Excel or Google Sheets
* **Developers** who want a quick JSON API from Airtable or Notion data
* **Operations teams** automating data exports with Zapier, Google Apps Script, or cron jobs
* **Agencies** sharing live client data via URLs
* **Anyone** who needs to get data out of Airtable or Notion without building custom integrations