Required for Splitting Large CSV File into Multiple Excel Sheets

I am currently working with a CSV file that contains a large amount of data. To manage this data more effectively, I need to split it into multiple Excel sheets or separate files, each containing 1,000,000 lines, without any data loss.However, when I try to process the ETL job, only the first sheet is created with 1,000,000 lines. Could you please suggest the best way to achieve this?

1,000,000 rows is excel limit so you have to split the data into a separate files or sheets

We will create a tutorial for you, It should not take long.

admin wrote:

1,000,000 rows is excel limit so you have to split the data into a separate files or sheets

We will create a tutorial for you, It should not take long.

another reason to love CSV files 

Here is the video tutorial we created in response:



I hope you find it helpful.

We’ve identified a minor issue with the Round transformation function, which will be fixed later today. Additionally, the two new examples demonstrated in the video will be included in the setup shortly.

Please let us know if you have any further questions or suggestions.