# Import from Airtable and CSV to an online database | BaseTable

> Migrate your Airtable bases with tables, fields, views, linked records and attachments by pasting a token, or convert a CSV into a table with types detected. Free with BaseTable.

- **Source (source):** https://aistohire.com/basetable-flexible-online-database-154/f/import-from-airtable-and-csv-to-your-database
- **Platform (platform):** AIstoHire
- **Language (language):** en

## In summary

- Bring your data from Airtable or CSV without retyping
- Paste your Airtable token and BaseTable migrates your entire bases—tables, fields, views, linked records, and attachments. Only have a CSV? Drop it and it becomes a table with types already detected.
- Report before touching anything
- Your schema, not a dump
- Links between tables are reconnected

## Bring your data from Airtable or CSV without retyping

BaseTable is AIsToHire's no-code database app, and import comes built-in: no need to hire anything or request assisted migration. For Airtable you generate a personal token (a PAT with data and schema read permissions), paste it in the app, and BaseTable connects to your account, lists your bases, and tells you which ones you already have and which are new. The token isn't saved anywhere: it travels with each request and disappears when you close the window.

Before writing anything, the app performs a dry run analysis. It shows you a report with how many bases, tables, fields, views, records, attachments, and collaborators it will bring, how many formulas it was able to translate and which will be saved as fixed values, and what things have no equivalent. You read it, and only then confirm. During import you see the progress bar and the current phase: importing records, resolving links, uploading attachments.

What arrives in your account is your structure, not a flat dump. Each Airtable field type maps to its BaseTable counterpart—long text, currency, percentage, duration, date with time, single and multiple select, rating, checkbox, collaborator, attachments, autonumber, formula, lookup, rollup—and linked records reconnect between tables in a second pass, even across different bases. Views are recreated with their type (grid, kanban, gallery, calendar, form, and timeline) and the hidden columns of each grid are preserved. Attachments don't link to Airtable: they're downloaded and saved in your own storage.

For CSV the path is shorter. You drag the file, the app automatically detects the delimiter (comma, semicolon, or tab), shows you a preview with the first rows, and upon confirmation creates a new table with the name you give it and each column already typed: number with its decimals, date, checkbox, email, link, or select list when values repeat infrequently. And in reverse, any view exports to CSV with its filters, sort order, and visible columns, ready to open in Excel.

## What's included

- **Report before touching anything** — a dry run analysis tells you about bases, tables, fields, views, records, and attachments it will bring, with warnings about what has no equivalent. If you're not convinced, don't import.
- **Your schema, not a dump** — each Airtable field type translates to its counterpart in BaseTable, including currency, percent, duration, rating, collaborator, autonumber, lookup, and rollup.
- **Links between tables are reconnected** — linked records are resolved in a second pass and continue pointing to their target record, even if it's in another imported base.
- **Attachments stay with you** — they're downloaded from Airtable and uploaded to your own storage, so they don't depend on your source account remaining active.
- **Views come ready** — grid, kanban, gallery, calendar, form, and timeline are recreated with their type, and in grids, hidden columns and their order are preserved.
- **Token is not saved** — it's a read-only personal token that you paste, used during import and not persisted in the database or logs. You can revoke it in Airtable when finished.
- **CSV with detected types** — the app deduces the delimiter and the type of each column—number, date, checkbox, email, link, select list, or long text—and shows you a preview before creating the table.
- **Round trip** — any view exports to CSV respecting filters, order, grouping and visible columns, with formatting that Excel opens without fighting with accents.

## Frequently Asked Questions

### How do I move my Airtable bases to BaseTable?

You create a personal token in Airtable with data and schema read permissions, paste it into BaseTable from the home screen menu and click Analyze. The app lists your bases, shows you a report of what will be imported and, upon confirmation, brings over tables, fields, views, records, links and attachments. Bases whose name already exists in your account are skipped to avoid duplicates.

### Are attachments and linked records also imported?

Yes. Attachments are downloaded from Airtable and re-uploaded to your own storage, so they no longer depend on the source account. Linked records are resolved in a second pass, once records from both tables exist, and end up pointing to their actual destination; this also works across different bases in the same import.

### Is it safe to paste my Airtable token?

The token is never stored: it's not written to any database or logs, it only exists during the import process and is sent with each request to Airtable. A read-only token is sufficient, and once you're done you can revoke it from your Airtable account without affecting the data already imported.

### Can I import a CSV or Excel file?

You can import CSV files: drag the file, the app detects the delimiter (comma, semicolon, or tab) and the type of each column, shows you a preview, and creates a new table when you confirm. The file must be in UTF-8 and weigh less than 5 MB. Excel files are not read directly: save them as CSV from the spreadsheet first.

### What things are not brought over from Airtable?

Record comments, automations, interfaces, and extensions are not migrated. In views, the type and hidden columns are preserved, but not filters, sorting, grouping, or colors. Formulas are translated when the function has an equivalent, and if it doesn't, the value is saved as a fixed data point. The app warns you about all this in the preview report before importing.

- [BaseTable — Flexible spreadsheet-style database](https://aistohire.com/basetable-flexible-online-database-154)

## About the platform

**BaseTable — Flexible spreadsheet-style database** — an app by AIstoHire. Available at: https://aistohire.com/basetable-flexible-online-database-154/f/import-from-airtable-and-csv-to-your-database

### Other languages

- `es`: https://aistohire.com/es/basetable-base-datos-flexible-online-154/f/importar-de-airtable-y-csv-a-tu-base-de-datos
- `fr`: https://aistohire.com/fr/basetable-base-de-donnees-flexible-en-ligne-154/f/importer-depuis-airtable-et-csv-vers-votre-base-de-donnees
- `it`: https://aistohire.com/it/basetable-database-flessibile-online-154/f/importare-da-airtable-e-csv-nel-tuo-database
- `pt`: https://aistohire.com/pt/basetable-banco-de-dados-flexivel-online-154/f/importar-do-airtable-e-csv-para-sua-base-de-dados
- `de`: https://aistohire.com/de/basetable-flexible-online-datenbank-154/f/aus-airtable-und-csv-in-datenbank-importieren
- `bg`: https://aistohire.com/bg/basetable-onlayn-baza-danni-kato-elektronna-tablitsa-bez-programirane-154/f/import-ot-airtable-i-csv-v-bazata-danni
- `ja`: https://aistohire.com/ja/nokodo-database-spreadsheet-154/f/airtable-csv-import-database
- `nl`: https://aistohire.com/nl/basetable-online-database-als-spreadsheet-zonder-code-154/f/importeren-uit-airtable-en-csv-in-je-database
- `ko`: https://aistohire.com/ko/basetable-nocode-database-spreadsheet-154/f/airtable-csv-online-database-gajyeoogi
- `sv`: https://aistohire.com/sv/basetable-databas-online-i-kalkylbladsstil-utan-kod-154/f/importera-fran-airtable-och-csv-till-din-databas
- `da`: https://aistohire.com/da/basetable-online-database-som-et-regneark-uden-kode-154/f/importer-fra-airtable-og-csv-til-din-database
- `ar`: https://aistohire.com/ar/basetable-qaada-bianat-aunlain-shbiha-bjdul-albianat-dun-brmja-154/f/import-from-airtable-and-csv-to-database
- `no`: https://aistohire.com/no/basetable-database-pa-nett-i-regnearkstil-uten-koding-154/f/importer-fra-airtable-og-csv-til-databasen-din
- `fi`: https://aistohire.com/fi/basetable-taulukkolaskennan-kaltainen-tietokanta-netissa-ilman-koodausta-154/f/tuo-airtablesta-ja-csv-tiedostosta-tietokantaan
- `zh`: https://aistohire.com/zh/basetable-no-code-spreadsheet-database-154/f/import-airtable-csv-to-online-database
- `pl`: https://aistohire.com/pl/basetable-baza-danych-online-jak-arkusz-bez-programowania-154/f/import-z-airtable-i-csv-do-bazy-danych
- `he`: https://aistohire.com/he/basetable-msd-ntonim-aonliin-bsgnon-gilion-bli-tknot-154/f/leyabe-me-airtable-ve-csv-lemasad-netunim
- `cs`: https://aistohire.com/cs/basetable-online-databaze-ve-stylu-tabulky-bez-programovani-154/f/import-z-airtable-a-csv-do-vasi-databaze
- `id`: https://aistohire.com/id/basetable-basis-data-online-seperti-lembar-kerja-tanpa-coding-154/f/impor-dari-airtable-dan-csv-ke-database-anda
