How to split excel rows into multiple sheets

Hi Everyone,
I have 30k records of data in excel sheet, I want to split that excel into 6 excel worksheets, so that each work sheet will contain 5k records. How to split rows into multiple sheets.
Thanks in advance

Hi @Suggala_Tejaswi ,

Could you maybe check the below post :

1 Like


You can use copy paste range activity in a loop by changing the source range inside the loop



1 Like


  • Count the number of records in the excel (Datatable.count)
  • Divide that to 4 parts
  • Read the same file by using Read Range with different ranges (4 times = 4 DataTables)
  • Write that into 4 different tabs.


1 Like