Load a CSV or Google Sheet Into a Postgres Table by URL

Created by

Adam Pearce

Actor

Dataset to Postgres, Supabase & MySQL (Database Push)

Append every row of a public CSV, Excel, JSON file or Google Sheet (here the open ISO country-codes CSV on GitHub, 250 rows, 56 columns) into a Postgres table, creating it with one typed column per field. Ships as a dry run so Try needs no database: it shows the CREATE TABLE for all 56 columns. Add your connection string and turn Dry run off to load it; swap in your own file or sheet link.

Try for free

Dataset to Postgres, Supabase & MySQL (Database Push)nerolabs/dataset-to-database

Table

Database

Mode

Dry run

+9 fields

Input

File URL (CSV, Excel, JSON or Google Sheet):https://raw.githubusercontent.com/datasets/country-codes/main/data/country-codes.csv

Database type:postgres

Table name:country_codes

Write mode:append

Column naming:snake_case

Dry run (plan only, write nothing):true

Output fields

Table

Database

Mode

Dry run

Rows in

Rows written

Not written

Table created

Columns added

Unique index created

Batches

Duration (ms)

Warnings

How it works

Sign up on Apify or log in

The Dataset to Postgres, Supabase & MySQL (Database Push) Actor is ready to run with the inputs already set for "Load a CSV or Google Sheet Into a Postgres Table by URL". Sign up or log in and you'll land in Apify Console with a copy of this exact task.

Start the "Load a CSV or Google Sheet Into a Postgres Table by URL" task

The Dataset to Postgres, Supabase & MySQL (Database Push) Actor will start running based on the input automatically. You can also change all the input fields, like file url (csv, excel, json or google sheet), database type, and more, to match your specific use case.

Receive the "Load a CSV or Google Sheet Into a Postgres Table by URL" output

Monitor the progress in real time. You will be notified as soon as your dataset is complete and ready for review. Each result includes data such as table, database, mode, and more.