How can we split the lakhs of data into multiple sheets with same workbook

Question

Hi,

I have issue with one existing workflow, i am getting 5 lakhs records or more in future as a output, I need to fit those into same workbook by splitting to multiple worksheets. I don't want to use csv/txt output types.

How can we achieve it?

Your help is much appreciated. Sorry for your time, Thanks for the reply.

binu_acs · Accepted Answer

@ravi061 Group your data based on how many records you want to be in one excel sheet, attaching a sample workflow for your reference. In this workflow I group the records into 10 and writing into different sheets

Update the below formula based on how many records you needed in one sheet