Output multiple files based on range

[apekshitdhoke]

My workflow generates 1m records (only one column having unique numeric id). However the application where I need to upload this data can only accept 50k records at a time. As such I wanted to know whether there is a way the output tool can generate 20 excel files (50k each file = 1m records)?

Note: Output is single column with unique numeric IDs without any pattern/distinction.

Possible Option: Export the data into 20 csv files then use a macro to import these 20 csv files and export them as excel.

[jrgo]

This output tool option, when a number value is specified will automatically start adding records to a different file/table when the MAX is hit. For Excel based files, the overflow will be added to a new sheet, not a new file.

[apekshitdhoke]

Yeah I'm aware of that option but as you rightly said it generates new sheet and not a new file in excel. So was wondering if there is any other option other than export csv then import and then export excel.