How do I import a Mailchimp CSV into PostgreSQL?

Export the audience or report from Mailchimp as CSV, paste it into this converter, set the table name, and copy the generated CREATE TABLE and INSERT statements into psql. For large files, use the COPY command shown instead of INSERT statements.

Is my Mailchimp data uploaded anywhere?

No. The conversion runs entirely in the browser with JavaScript. The CSV text never leaves the page, and no request is sent anywhere.

What column types does the converter infer?

INTEGER for whole numbers, DOUBLE PRECISION for decimals, BOOLEAN for true/false and yes/no, TIMESTAMP for ISO dates, and TEXT for everything else, including email addresses and names. Review the CREATE TABLE statement before running it — inference is a starting point, not a schema decision.

Mailchimp CSV to PostgreSQL Converter

Convert your export

Table name Paste Mailchimp CSV

Paste a CSV export to generate SQL. Nothing is uploaded.

PostgreSQL

How it works

Export the audience, segment, or report from Mailchimp as CSV — the on-site Mailchimp CSV guides cover each export type.
Paste the CSV above and set the table name. Column names are sanitized to lowercase PostgreSQL identifiers: spaces and special characters become underscores, leading digits get a prefix, and empty headers become column_1, column_2, and so on.
Copy the CREATE TABLE statement and the INSERT statements into psql, or use the COPY command for large files: save the CSV, then run \copy table_name FROM 'file.csv' WITH (FORMAT csv, HEADER true).
Check the row count after loading: the converter reports how many rows it generated, and the count should match the CSV's data rows.

Quoted fields, embedded commas, and doubled quotes are parsed as CSV requires — a name like "Doe, Jane" stays one field. Type inference reads the first 100 data rows: a column that is all whole numbers becomes INTEGER, decimals become DOUBLE PRECISION, true/false and yes/no become BOOLEAN, ISO dates become TIMESTAMP, and anything mixed or textual becomes TEXT. Email addresses, names, and tags stay TEXT, as they should.

For other Mailchimp destinations, see the Mailchimp Export Guides by Format directory. For moving Mailchimp data into BigQuery instead, see Export Mailchimp Data to BigQuery.

Facts verified against Mailchimp export behavior and PostgreSQL syntax 2026-11-01. This tool gives general process information, not legal advice.

Mailchimp CSV to PostgreSQL Converter

Convert your export

How it works

Keep Exploring