Conversion of csv file to xlsx via Flow or SharePoint

Question

I have a Flow to store email attachments (in .csv format) to SharePoint. Now, I want to use the file in Power-BI from SharePoint. However, I want the file in .xlsx format. Could you please suggest how I can automate the conversion of the .csv file to .xlsx file format?

Thanks in advance. My google search results suggested methods of doing it offline whereas I want to automate it either in Flow or SharePoint if possible.

Answer 1

You can follow below steps for conversion of csv file to excel through MS Flow:

1. After uploading the csv file in SharePoint, read its content. (Reference link).
2. Create a CSV table using the output of csv file.
3. Create an excel file using that CSV table.