One csv output with mutliple tabs

[Anon1234]

Hi guys, is there a tool that can help, wherein the output will be in a csv format but with multiple tabs?

I've tried to do it in excel file format under configuration, it worked, however, when it is in csv , I do have multiple csv files as outputs.

The limitation of my output is that it exceeds the capacity lines of Microsoft excel around 1.2m lines that's why it is in csv format.

Example:

Data- A,B,C

Identifier-1,2,3

Expected output: 1 csv file with sheets 1,2 and 3 (sheets name is based on identifier column)

[binuacs · Accepted solution]

@Anon1234 CSV format doesn’t support multiple tabs, if your excel sheets exceed the limit then split the records and write the remaining records into the next sheet