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

[ravi061]

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. 

[FrederikE]

Hey @ravi061,

Not sure if understand what your question is, maybe you need to explane it further. 

If you are struggling with creating an Excel file with multiple sheets then such a configured Output tool is the solution:

Example: 

[binuacs · Accepted solution]

@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