Templates / Export SQL table into CSV file

Export SQL table into CSV file

Ready for 3.0

by Eduard ✓ · 9,299 views · created 2023-05-06 · File Management

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 4 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Microsoft SQL.

How it runs

Trigger: Manually, when you click “Execute workflow”.

  1. TableName (Edit Fields (Set)): sets or maps fields
  2. LoadMSSQLData (Microsoft SQL): run a query
  3. SaveCSV (Spreadsheet File): reads or writes a spreadsheet file (legacy node)

Services it uses

Microsoft SQL

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

  • Still check Spreadsheet File (SaveCSV): Convert to File / Extract from File.

Nodes used (4)

From the author

This workflow demonstrates how easy it is to export SQL query to CSV automatically! Before running the workflow please make sure you have access to a local or remote MSSQL server with a sample AdventureWorks database. The detailed process is explained in the…

Excerpt from Eduard'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.