Hi team,

Client can only sent us xls file with additional 20 tabs data.

I need to extract each tab separately and save them as CSV format. Like CSV_Tab1.csv, CSV_Tab2.csv, .... and CSV_Tab20.csv

How do I go about this via workflow, any idea?

Thanks

There's no native functionality that allows you to do that in Workflow.

One thing you could try, though, is using the Database plugin to read the file using the ODBC Excel Files driver. With that driver, the XLS is considered a database and each tab is a table. You can then extract each table separately and save them as independent CSVs.

thank you, I'll try DataBase plugin!