Export MSSQL Query to CSV with n8n Workflow Automation

Instantly Export an MSSQL Query to CSV with an n8n Workflow

Need to turn MSSQL query results into a clean CSV file automatically? This n8n workflow shows how to export the results of an SQL query from a Microsoft SQL Server (MSSQL) into a CSV using straightforward automation steps—ideal for repeatable reporting and data extracts.

What this workflow does

• Provides a clear, step-by-step example for exporting data from MSSQL to CSV.
• Uses a Manual Trigger so you can run the export whenever you need it.
• Connects to an MSSQL server you control (local or remote) and prepares the query using the included setup guidance.
• Relies on the sample AdventureWorks database to demonstrate the workflow end-to-end.
• Writes the query output to a Spreadsheet File in CSV format as the automation result.

Before running, make sure you have access to a local or remote MSSQL server and the AdventureWorks sample database. The full process is explained in the tutorial: https://blog.n8n.io/sql-export-to-csv/.

Use cases

• Generate CSV extracts from MSSQL for ad-hoc analysis or BI ingestion.
• Automate recurring exports for SaaS operations and internal reporting.
• Test SQL queries quickly and reuse the same export workflow in n8n.
• Support data migration or downstream processing where CSV is required.

Technical details

• n8n nodes used: Set, Sticky Note, Microsoft SQL, Manual Trigger, Spreadsheet File
• Workflow purpose: SQL query execution in MSSQL and export results to CSV
• Prerequisite database: AdventureWorks (sample)