Microsoft Power Automate: How to convert Excel (.xlsx) to .csv files - Full Tutorial

This video tutorial shows, how to convert Excel (.xlsx) table data to .csv files in Microsoft Power Automate.

You could also watch:

0:15 Our Excel Sheet is stored in OneDrive
We store our data in an Excel sheet in OneDrive. The solution also works, if the sheet is store in e.g. SharePoint.

0:46 Create a new Power Automate Flow
We create an instant flow and manually trigger it.

1:45 Get tables
We get the Excel table with our data.

2:22 List rows present in a table
List all the rows with data, so we can work with them in the next Power Automate steps.

2:53 Create CSV table
We create a CSV table with our data columns. We could chose to take all columns from or .xlsx file or specify which one, we want to use.

3:51 Apply to each
To get all the data we chose an Apply to each, where we iterate through each of our tables.

4:18 Create file
Create our .csv file in OneDrive. Again we can create it in e.g. SharePoint, if we wanted.

Connect with me:

#microsoft #powerautomate #excel

[ekirkliu]

I've seen so many tutorials of exporting Excel to CSV, and yours is the BEST! Thank you!

[JibbsCompilations]

Hi Anders, we really need a Power Automate CSV to XLSX from you! You're make the best tutorials.

[lololnope]

Thank you!! Didn't realise you had to end the name with .csv

[mtzmty]

this video helped me complete my process to extract order details from PDF files we receive by email and drop them into a spreadsheet (with the help of a different video from Anders) and convert that spreadsheet into a CSV file. BIG THANK YOU

[Camsbentley]

Thanks, This was really helpful! Solved a Problem at work.

[mtamoush]

How can you accomplish this if your xls data is not in a table?

[TIMERR]

Thank you, Anders. It helped me a lot.

[thomasbeatham]

Hi Anders, thanks for all the great videos! My excel file has 3 tables and the apply to each creates 3 csv files with identical data, but each has the name of the 3 different tables. Is there any way to work it with a file with multiple tables? Any advice much appreciated!!

[pspy]

Great sharing. May I know can u help on how to get xlsx file from microSD form upload to csv automatically? But I having problem to create table from Jason id which I get the upload drop from Microsoft form.

[muneitshamano]

Hey Anders. I have a table with 1250 entries but when I follow these steps it only copies over 257. Any idea what I'm doing wrong?

[rupinderkaur]

Hi Anders, It was very helpful.Solved my problem.However, I had date type columns in my excel file which got converted to general format.Is there any way I can keep my dates in correct format while converting?

[streetviewofindonesia]

Thanks how to multiple excel file in local folder into csv file

[somily]

I have to do something similar but every time an email arrives with an excel file and I need to convert this excel file to a csv but I observe that I would have to copy the file to an onedrive folder and that the excel file has a defined table it is possible to do this dynamically or how I could do it

[thomashalberstadt]

Under List rows present in a table i don't become show a pull down with Tabels unter "Table", i think the problem is that my .xlsx has no dynamic tabells, such only normal datatabels. is there a way to convert to .csv? Thank you

[cdhkasukabe]

Where does the date comes in and it seems like mine wont show the data for 2:48

[k]

Dear sanders

Would it be possible to apply the same approach to xls -> xlsx conversion case ?

Thanks in advance

[martinsong]

Hi Andres, thanks for your sharing. Do you have the tutorial for converting .csv file to xlsx, we need it. thanks very much~!!!

[valeriastrafe]

So what happens if the excel file doesnt have tables? I just want a flow that grabs and email attachment, changes it to csv and saves it in a share point... I can deal with the data transformation afterwards in power query...HELP!

[camillasommer]

Hallo Anders, I need to make my CSV with
Semicolon separated and <CR><LF>
instead of comma separated CSV file.
Can you help explain what i can do?

[miguelestrada]

Hello @Anders Jensen, I am having trouble creating a csv file from values after going through multiple conditions. Is there a way that you can help me by looking at my flow?