How to convert Excel file with multiple sheets to CSV at once using logic app?

S, Abeeya - Mindtree LTD 21 Reputation points
2021-08-16T06:51:39.567+00:00

Hi!

Im new to logic app and want to convert Excel file with multiple sheets to csv at once using logic app , Im able to convert perticular sheet(only 1 at a time) from excel file to csv but not all of them at once. Any help/suggestion would be appreciated

Thanks in advance

Azure Logic Apps
Azure Logic Apps

An Azure service that automates the access and use of data across clouds without writing code.

0 comments
Answer accepted by question author
MayankBargali-MSFT 71,021 Reputation points Moderator
2021-08-16T10:28:44.34+00:00

@S, Abeeya - Mindtree LTD If you are using Get Tables action then it returns all the tables in any of the worksheets. You can now loop in through the output of Get Tables action and use"list rows present in a table" action.

123582-image.png

On the Table option Select Enter custom value and Select the dynamic content Name of your previous "Get Tables" action.

123622-image.png

As you have already mentioned that you were able to convert one table to csv. The next actions should be inside the same for loop to save the table rows to csv.

Was this answer helpful?

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.