# Manual export of MySQL table to XLSX with filename based on table name
This workflow enables quick, no-code export of data from any MySQL table into an XLSX file. Triggered manually, it’s ideal for generating reports, archiving data, or sharing structured datasets without relying on SQL clients.
## Who it´s for
- Analysts who regularly extract data from MySQL
- Database administrators automating table exports
- Managers preparing Excel reports from SQL data
- Marketers working with event, campaign, or customer tables
## What the automation does
- Triggered manually via Execute button
- Accepts MySQL table name as input parameter
- Fetches all rows from the specified table
- Converts data into XLSX format with dynamically named sheet
- Saves output as a binary file ready for download or further use
- Filename and sheet name are derived from the table name
## What´s included
- Ready-to-use n8n workflow
- Logic for manual trigger and parameter handling
- Integrations with MySQL and XLSX file generation
- Basic text instructions for setup and adaptation
## Requirements for setup
- Access to a MySQL server with read permissions on target tables
- n8n account with workflow import capability
- File system or cloud storage access to save exported XLSX files
## Benefits and outcomes
- Saves time on repetitive manual exports
- Reduces human error from copy-paste operations
- Ensures consistent file naming and report structure
- Enables downstream actions like email delivery or cloud upload
- No need for advanced SQL knowledge by end users
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet