Templates / Transfer data from Postgres to Excel

Transfer data from Postgres to Excel

Needs changes

by Jan Oberhauser ✓ · 8,578 views · created 2019-08-31 · Document Extraction

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: Write 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 “Run Query” (no trigger node, so run it manually or call it from another workflow). Along the way it connects Postgres.

How it runs

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

  1. Run Query (Postgres): run a query
  2. Spreadsheet File: reads or writes a spreadsheet file (legacy node)
  3. Write Binary File: uses Write Binary File

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:

  • Write 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
Write Binary File
Write Binary File
Read/Write Files from Disk

Nodes used (3)

From the author

1. Read data from Postgres 1. Converting it to XLS 1. Save it to disk

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.