AcademyWorkflowsData and reporting

Convert a SQL Table into an Excel Spreadsheet

Analysts and operations staff who regularly export database query results to Excel.

  • Recommendedour rating
  • 4,648views on n8n
Open on n8n.io ↗

Paste it straight onto an n8n canvas with Ctrl+V or Cmd+V.

convert-sql-table-into-excel-spreadsheet.json

Loading the file...

What it does

An n8n workflow that runs a SQL query against a remote database, such as MySQL, MS SQL or PostgreSQL, and saves the result as an Excel spreadsheet. The template includes a sample table so you can see how the rows and columns come out before you use your own data.

Use cases

  1. 01Export a query result to a spreadsheet automatically
  2. 02Share database tables with colleagues who work in Excel
  3. 03Test the export with the sample table first

Connects

MySQL

Questions about
Convert a SQL Table into an Excel Spreadsheet.

What is Convert a SQL Table into an Excel Spreadsheet used for?

Analysts and operations staff who regularly export database query results to Excel. An n8n workflow that runs a SQL query against a remote database, such as MySQL, MS SQL or PostgreSQL, and saves the result as an Excel spreadsheet. The template includes a sample table so you can see how the rows and columns come out before you use your own data.

How do I import Convert a SQL Table into an Excel Spreadsheet into n8n?

Copy the workflow JSON from this page and paste it onto the n8n canvas with Ctrl+V or Cmd+V. Then connect your credentials in each node.

Is Convert a SQL Table into an Excel Spreadsheet safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.