Docs

Import CSV

Simple defaults for CSV imports.

Default CSV behavior

CSV imports use simple defaults:

Delimiter: comma by default.
Header row: on.
All columns are imported as text.

You can enable type detection during import. For large files, QuackNinja may keep text types for stability.

Note

Need number or date columns? Use “Detect column types” in the table menu after import.

Best practices

Keep headers clean (avoid merged or blank header cells).
Use consistent delimiters across the file.
Prefer UTF-8 encoding when possible.

Check imported tables

DuckDB SQLsql

SELECT COUNT(*) FROM customers;
SELECT * FROM customers LIMIT 10;

Import settings (if enabled)

Some builds expose CSV import settings for delimiter and header handling. If you adjust them, the import will follow your selected delimiter and header row.

Common issues

0 rows imported

This can happen if the file encoding is unexpected or the browser lost file permissions. Reattach the file or export a clean UTF-8 CSV.

Table not found

Tables only exist for attached files. If you refreshed and didn’t reconnect, reattach the file.