Convert Excel to CSV on Azure blob storage through Logic App

Question

Hello ,

Can we convert Excel file to CSV format on blob storage through Logic App. So that I could load data in SQL database through ADF pipeline.

Please suggest how to convert in CSV If It is possible

Regards,

Mahesh Dadhich

---

Mahesh Dadhich

Answer 1

Hi Mahesh

Converting should be pretty easy. On high level, you can do following:
1. Use Excel connector to read into the content of the excel file
2. Use Data Operations - Create CSV Table to create a CSV format populated with dynamic data from step #1
3. Use Azure Blob Connector to create and save the new csv file on the blob storage

Hope this helps, please let us know if you have any questions :)

Answer 2

Hey Mahesh - got any updates for us?

Answer 3

But why do you want to change from excel, can't you load data from excel to SQL database.

---

Cheers,

Answer 4

Hi all,

I would like to read an excel file stored in blob storage and convert it into csv. I am not finding a component, which can read the excel from blob storage and feed into "Create CSV Table".

I tried "Get Blob Content" and tried to use the ouput, but it is not working with "Create CSV table".

My actual use case is to process file attachments in Excel format and convert into CSV. I dont need to even store the excel in any kind of storage to proceed. So if there is something else to process the attachment in Excel format into CSV, that would work better for me.

Sunil

Answer 5

Most of the people say that working with CSV files is easier than excel, what they don't see is that in excel you do not have any of  the CSV issues that you have like

1. record in multiple line are handled automatically in excel
2. can move the column in excel 
3. you can have a comma in the middle of a text and not worry about it in excel
4. You can have a ENTER in the middle of a text and not worry about it in excel
5. You can have a | in the middle of a text and not worry about it in excel
6. and lots more

So why not move the files directly to SQL using ALA directly?

good luck

---

Sincerely Nik -- Please kindly mark the post(s) that answered your question and/or vote for the post(s). http://sqldataside.blogspot.ca/ (SQL Tabular + PowerShell)

Answer 6

Not debating excel/csv format here - I need to feed csv data into an existing application - so I have to convert into csv format from excel. How can I do that in Azure Logic App or any other tool out there? The existing application does not read from SQL server or any database - it needs to read from files in CSV format.

Answer 7

Even i need to do the same.. if you found the solution can you please help on it.. i am using MS Flow to push the email excel attachments to Blob storage..

but blob storage accepts only csv.. my concern is now how to convert Excel to CSV.. Please help..

Thanks in advance..