Move data in and out — CSV, JSON, and Excel imports for every database we support.
Four methods to import CSV files into MariaDB: LOAD DATA INFILE, LOAD DATA LOCAL INFILE, mariadb-import CLI, and Mako. Covers permissions, encoding, and type conversion.
Four methods to import CSV files into Microsoft SQL Server: BULK INSERT, bcp utility, SSMS Import Wizard, and Mako. Includes format files, permissions, and error handling.
Four ways to import Excel data into BigQuery: upload CSV via the Cloud Console, use Google Sheets as an intermediary, Python with pandas-gbq, and Mako. Covers GCS staging, schema auto-detection, and large files.
Three ways to import Excel data into ClickHouse: convert to CSV and use clickhouse-client, Python with pandas and clickhouse-connect, and Mako. Covers format conversion, type mapping, and batch loading.
Four ways to import Excel data into MariaDB: convert to CSV and use LOAD DATA INFILE, Python with pandas, HeidiSQL's import tool, and Mako. Covers character sets, date handling, and the CONNECT engine.
Three ways to import Excel data into MongoDB: convert to CSV and use mongoimport, Python with pymongo and openpyxl, and Mako. Covers document structure, type handling, and multi-sheet workbooks.
Four ways to import Excel data into SQL Server: the SSMS Import Wizard, OPENROWSET with the ACE provider, Python with pyodbc, and Mako. Covers the ACE driver, linked servers, and common permission issues.
Four ways to import Excel data into MySQL: convert to CSV and use LOAD DATA INFILE, Python with pandas, MySQL Workbench's import wizard, and Mako. Covers character sets, date handling, and large files.
Four ways to import Excel data into PostgreSQL: convert to CSV and use COPY, Python with pandas, pgAdmin's import tool, and Mako. Covers type mapping, multi-sheet files, and common pitfalls.
Three ways to import Excel data into Snowflake: convert to CSV and use COPY INTO with a stage, Python with snowflake-connector-python, and Mako. Covers staging, file formats, and Snowpark for direct Excel reading.
Four ways to import Excel data into SQLite: convert to CSV and use the .import command, Python with pandas, the sqlite3 CLI with a script, and Mako. Covers type affinity, large files, and multi-sheet workbooks.
Three ways to import JSON data into BigQuery: bq load CLI, the BigQuery Console, and Mako. Covers NDJSON requirements, schema auto-detection, nested structs, and Cloud Storage staging.
Three ways to import JSON data into ClickHouse: JSONEachRow format with clickhouse-client, the HTTP interface, and Mako. Covers JSON format variants, nested data, and performance.
Three ways to import JSON data into MariaDB: LOAD DATA INFILE with LONGTEXT columns, a Python script, and Mako. Covers MariaDB's JSON alias, functions, and differences from MySQL.
Three ways to import JSON data into MongoDB: mongoimport CLI, insertMany in the shell, and Mako. Covers JSON vs BSON, large file handling, and schema validation.
Four ways to import JSON data into Microsoft SQL Server: OPENROWSET with OPENJSON, a Python script with pyodbc, SSIS, and Mako. Covers NVARCHAR(MAX) storage, indexing, and large file handling.
Four ways to import JSON data into MySQL: MySQL Shell's importJSON utility, LOAD DATA INFILE, a Python script, and Mako. Covers the JSON column type, indexing, and large file handling.
Four ways to import JSON data into PostgreSQL: COPY with psql, pg_read_file, a Python script, and Mako. Covers jsonb vs json, flattening nested structures, and performance tips.
Three ways to import JSON data into Snowflake: COPY INTO with stages, direct VARIANT insert, and Mako. Covers file formats, FLATTEN, and extracting nested data.
Four ways to import JSON data into SQLite: sqlite-utils CLI, the .import command, Python scripting, and Mako. Covers JSON1 functions, type handling, and nested data.
Four ways to import CSV files into BigQuery: the bq CLI, Google Cloud Console, Python client library, and Cloud Storage loads. Includes schema detection and quota tips.
Four ways to import CSV files into ClickHouse: clickhouse-client piping, INSERT FROM INFILE, the HTTP interface, and the file() table function. Includes performance tips for large datasets.
Four ways to import CSV files into MongoDB: mongoimport CLI, MongoDB Compass, Python with pymongo, and Atlas UI. Includes type handling and field mapping tips.
Four ways to import CSV files into MySQL: LOAD DATA INFILE, mysqlimport, MySQL Workbench, and Mako. Includes permission gotchas and encoding fixes.