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


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


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.


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)


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.