How to convert CSV file to .xslsx file using SharePoint actions in power autometa

Question

How can we convert CSV file into .xlsx using SharePoint actions

Answer 1

Hi James James

Thank your for reaching out on Microsoft Q&A!

I've looked around on the internet, and found the blog below. It's based on retrieving a CSV from Blob Storage, however it appears to follow the same use case.

https://social.msdn.microsoft.com/Forums/en-US/a08b6d3a-f492-4f26-9309-e172553e9fdf/convert-csv-to-excel-in-azure-blob-storage?forum=azurelogicapps

Depending on your requirements this could help achieving your goals.

If you need more assistance, please share a sample CSV so I can create it in my test lab.

Please let me know if my response is helpful by clicking "Accept answer". Feel free to drop additional queries in the comments below.

Answer 2

Once you figure out a way to acquire the CSV file, install the IMPORTEXCEL module (https://www.powershellgallery.com/packages/ImportExcel/7.8.4) to manage the conversion to XLSX format. It's as easy as this:

Import-CSV c:\junk\agg.csv -delimiter '|' |    # or whatever your delimiter character might be
    Export-Excel c:\junk\agg.xlsx