Logic Apps: Merge Multiple Excel Worksheets Into One Csv File

This article shows how to use logic apps to merge multiple worksheets in an excel into one csv file at runtime.

Image credit — https://driving-tests.org/road-signs/merge-sign/

If you want to know how logic apps can be used to merge multiple excel worksheets into one csv file and store it in ADLSG2, you have arrived at the right article. I published a similar article where I showed how to convert an excel file with just one worksheet into a csv and save the csv to a blob storage.

👉Test Setup

I made a file called medium excel.xlsx with two worksheets — Sheet 1 and Sheet 2.

Sheet 1 contains data as shown below-

Sheet 2 contains data as shown below-

👉Note that the data in the excel file needs to be in a table. Otherwise, Logic Apps will not be able to read the rows.

📌 Requirement