How to Split Excel Rows to Separate File?

OpenRPA
1

Hello

I need help splitting Excel rows into separate files, naming each new file using the original filename plus an index.

I’ve tried searching online and through Google,Youtube and ChatGPT , but I haven’t been able to find a solution.I would really appreciate it if anyone could point me in the right direction.

Greeting and Thank you
v

ex. data.xlsx

InvoiceNumber | Customer_ID | Amount
H68/07/001 | OP-003 | 1,000,000.00
H68/07/002 | OP-003 | 2,000,000.00
H68/07/003 | OP-003 | 3,000,000.00

output

  • E:\Output\data1.xlsx: Contains one row: H68/07/001, OP-003, 1,000,000.00
  • E:\Output\data2.xlsx: Contains one row: H68/07/002, OP-003, 2,000,000.00
  • E:\Output\data3.xlsx: Contains one row: H68/07/003, OP-003, 3,000,000.00
2

If you always want ONLY one row in each new file based on index, then you can try something like this. You can replace Read Excel with Read Range and Write Excel with Write Range if you prefer using your local Excel.

split-excel.json (8.7 KB)