1. Integrations
  2. PostgreSQL

Push data into Postgres from CSV or XLSX files

PostgreSQL Integration

Import CSV data directly into PostgresQL

Use EasyCSV to process and import CSV or XLSX file data directly into PostgreSQL. You can automate imports by sending CSV/XLSX files to a custom email you get in EasyCSV. Or also use our scheduled fetcher to routinely grab files from FTP / SFTP, Google Drive, Dropbox, OneDrive, a URL, and more.

Then simply map your spreadsheet columns to fields in your database and you're done!

Sign up & try it free PostgreSQL website

3 Simple Steps to Import a CSV into Postgres

A CSV (comma-separated values) file is a table of data, typically exported from another program such as Microsoft Excel.

You can import the CSV into Postgres and load it as a table so you can access and query its data. This page will show you how to import a CSV into Postgres and set up the data so you can start working with it.

Section 1: Understanding the CSV file.

The first step is to understand what’s in the CSV file.

If you have a CSV file, you can use a CSV editor to view the contents of the file. In Excel, for example, you can just click the Data tab and then choose from the menu to Open as Text, then select Comma as the delimiter.

In this example, the CSV file contains a list of people with their first and last names. The first row is the header row and provides the names of each column:

First Last

John Doe

Jane Smith

Jim Johnson

Jim Smith

Now you know what’s in your CSV file and what each column means. The next step is to import it into Postgres and set up the data so you can start working with it.

Importing CSV files into Postgres

Importing CSV files into Postgres is simple with EasyCSV.

  1. First, use an example CSV file you need to import into PostgreSQL to set up an EasyCSV import page.

  2. Enter your Postgres info for connecting to the database. If you need a static IP address please reach out to EasyCSV support via webchat or email and we can provide IP addresses for you to whitelist.

  3. Map your CSV columns to Postgres Database Fields. You can also use Virtual Fields to transform or combine spreadsheet data into new values to map into your database fields.

  4. Do a real import with your import page!

  5. You can use an automated fetcher or email to automatically send and import data into your database as well. Take a look at the EasyCSV docs for how to do that.