Creating 1 Million Rows Excel file
This tutorial shows how to create a massive Excel file with one million rows. It uses a demo customer CSV file https://github.com/datablist/sample-csv-files
All our ETL Software software works correctly with Excel all the time. It updates Excel files without losing formatting or calculations.
Our WIKI has more detailed information if you are stuck post your question on our ETL Support forum and we will do our best to assist you