Skip to content

Import and export

Import files into tables, export tables and results, and open CSV, JSON or Excel without a database.

The TablePro Export dialog on a Mac, with three tables selected for a CSV export.

Export tables and results

Export tables and views to CSV, JSON, SQL, XLSX, Markdown, HTML and XML, streaming past the grid’s row cap. SQL engines take a filter, a limit and a column list per table, and a SQL export can include the structure. Export Results reruns a capped query to write the whole result, and a free plugin adds Parquet.

A SQL export puts DROP TABLE IF EXISTS before each table unless you turn it off.

Import files into a table

Import CSV, TSV, JSON, JSONL, XLSX and SQL files into a new or existing table, with a column mapping you can save for next time. SQL files run as statements, .sql.gz dumps and SQL Server GO scripts included. An import is one transaction unless you turn that off; when a row fails, roll back, keep what was imported, or skip the failed rows and export them.

Linux imports CSV into an existing table, and SQL files. iPhone and iPad add rows through Shortcuts.

No import: Redis, Cassandra, ScyllaDB, Amazon DynamoDB, Google BigQuery, Cloudflare D1, Turso, libSQL, Elasticsearch, etcd, Apache Kafka, SurrealDB, Trino, Beancount, Google Cloud Spanner, Typesense, Weaviate, Cloudflare R2 SQL, SAP HANA

The import sheet in TablePro on a Mac, mapping the columns of a CSV file to a table.

Data Files

Open delimited text, JSON and JSON Lines as tables, with no connection. Filter, replace text, remove duplicate rows and read each column’s statistics, then save in the original format or import into a table. Excel and compressed files open read-only.

The Data Files window with orders.csv open and searched for Hanoi, the status bar reading 2,498 of 20,000 rows.

Backup and restore

Backup Dump and Restore Dump run pg_dump, mysqldump, mongodump, sqlite3, sqlpackage and DuckDB with the connection’s SSH and TLS settings; you install the tool, except for DuckDB. Server-Side Export on Oracle, Google BigQuery and Snowflake writes through Oracle Data Pump, a Snowflake stage or Cloud Storage, so the data never passes through your Mac.

Linux writes SQL dumps without external tools.

Backup Dump: PostgreSQL (pg_dump), MySQL (mysqldump), SQL Server (sqlpackage), SQLite (sqlite3), MongoDB (mongodump), MariaDB (mysqldump), Amazon Redshift (pg_dump), DuckDB (DuckDB), libSQL (sqlite3)

The Backup Dump sheet in TablePro on a Mac, set to dump a PostgreSQL database with pg_dump.

Also

  • Files that are databases

    SQLite and DuckDB files open from Finder as connections. A SQLite file on an SSH server opens live or as a read-only copy, and DuckDB reads Parquet, CSV and JSON as views.

  • From one database to another

    Copy or transfer tables between connections without a file in between.

  • On iPhone and iPad

    Copy or share rows as JSON, CSV or INSERT statements, and add rows with the Shortcuts actions.

Get TablePro

Everything on this page is free.