This video tutorial shows, how to convert Excel (.xlsx) table data to .csv files in Microsoft Power Automate.
You could also watch:
🔵 Microsoft Power Automate Tutorial for Beginners –
🔵 Microsoft Power Automate Use Cases –
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.
📚 Best Power Automate Book –
Connect with me:
🔔 Subscribe –
💼 LinkedIn –
👥 Facebook –
💌 Email Newsletter –
#microsoft #powerautomate #excel…(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
Can we put in dataverse tables in these csv tables or no?
Are Microsoft on drugs? What's this obsession with tables in excel? An excel spreadsheet is already in tabular format! The amount of screwing around you have to do to perform simple data operations in Power Automate is ridiculous.
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?
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?
Dear sanders
Would it be possible to apply the same approach to xls -> xlsx conversion case ?
Thanks in advance
Hi Anders, we really need a Power Automate CSV to XLSX from you! You're make the best tutorials.
How can you accomplish this if your xls data is not in a table?
Can you do a video on how to covert excel to pdf?
I've seen so many tutorials of exporting Excel to CSV, and yours is the BEST! Thank you!
Thank you, Anders. It helped me a lot.
hello anders can u tell me how u generated the exl file lite table is name data !
Really helpful thank you! But, is there any way to save the CSV file outside of the On Drive For Business like a Network Drive? Thanks 🙂
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?
What's the point of using Get Tables if you're not listing the rows for each one of them? Even if you did have multiple tables, all the csv files generated would have the same content of the table Data, which comes from the Create CSV Table (outside of the loop)
Need automated flow which would convert csv file in sharepoint to xlsx file in share point .used when file created in folder .don't have premium license.could you provide possible solution.thank you in advance.
Anders, this is helpful, thanks. However, I would also like to know how to convert a csv that is in blob storage to an xls using a logic app – is this possible without utilizing the Excel connector?
Is it possible to import xls. files from web directly to google sheets? All =import( functions failed. I found a solution on stackowerflow in VBA, which I do not know to apply. Is there any google script out there?
Where does the date comes in and it seems like mine wont show the data for 2:48
Thanks, This was really helpful! Solved a Problem at work.
hello Anders ….do you have any idea on how to convert an excel without a table to csv
Do you want to learn Power Automate from the start? Check my new Power Automate Tutorial for Beginners: https://youtu.be/omQ-fAF4QpI
hi, nice work!!! thanks! So, how can i use another delimiter?? Regards!!
Please could you explain how to get ID in its own column and name in its own column in the completed csv file?
hi, does this solution work from sharepoint to sharepoint? that is, I have an excel in sharepoint and I want to convert it to csv and leave it in the same sharepoint. thanks and very good video, subscribed.
Hello guys, I don't know if you had the same problem but my excel with 680 lines it only converts 255, does the power automate have any limits?