Output multiple files based on range

Question

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.

apekshitdhoke · Answer

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.

jrgo · Answer

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.