Templates / Insert Excel data to Postgres

Insert Excel data to Postgres

Needs changes

by Jan Oberhauser ✓ · 13,661 views · created 2019-08-31 · Engineering

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: Read Binary File. 1 breaking item(s) found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 3 nodes and runs from “Read Binary File” (no trigger node, so run it manually or call it from another workflow). Along the way it connects Postgres.

How it runs

Trigger: From “Read Binary File” (no trigger node, so run it manually or call it from another workflow).

  1. Read Binary File: uses Read Binary File
  2. Spreadsheet File: reads or writes a spreadsheet file (legacy node)
  3. Insert Rows (Postgres): uses Postgres

Services it uses

Postgres

Before you upgrade to n8n 3.0

1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:

  • Read Binary File: replace with Read/Write Files from Disk.
  • Also check Spreadsheet File: Convert to File / Extract from File.

Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).

Removed in 3.0Replace with
Read Binary File
Read Binary File
Read/Write Files from Disk

Nodes used (3)

From the author

1. Read XLS from file 1. Convert it to JSON 1. Insert it in Postgres

Excerpt from Jan Oberhauser's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.