Convert JSON to Excel in Microsoft Power Automate for Desktop
Do you receive JSON files that you'd like to convert to Excel tables? In this video, we show you how to convert JSON to Excel tables in Microsoft Power Automate for Desktop. Doing this transforms JSON file data into Excel format so that it becomes very easy to see, read, and do subsequent data manipulation such as filtering, applying formulas, etc. 00:00 Introduction 00:11 Sample JSON file used for this tutorial 00:38 Extract the keys from the JSON file 03:00 Write keys to Excel 07:30 For each key, access the value and write to Excel 10:34 Save the Excel file If you're not yet familiar with the basics of Microsoft Power Automate for Desktop, you may want to check out these topics used in this tutorial: - Loop actions in Microsoft Power Automate for Desktop: https://youtu.be/KPpHBVdMaFs - Excel automation basics: https://youtu.be/0QLMK53Oohk - Conditionals in Microsoft Power Automate for Desktop: https://youtu.be/U12eo9DRYdE - Text manipulation (including replace text): https://youtu.be/VA0xZKrRpok Keep in touch! Website https://mspowerautomate.com/ Twitter https://twitter.com/MsAutomate Facebook https://www.facebook.com/MS-Power-Automate-105388391663527 LinkedIn https://www.linkedin.com/in/power-automate/ #RPA #PowerAutomateDesktop #RoboticProcessAutomation #PowerAutomate
Do you receive JSON files that you'd like to convert to Excel tables? In this video, we show you how to convert JSON to Excel tables in Microsoft Power Automate for Desktop. Doing this transforms JSON file data into Excel format so that it becomes very easy to see, read, and do subsequent data manipulation such as filtering, applying formulas, etc. 00:00 Introduction 00:11 Sample JSON file used for this tutorial 00:38 Extract the keys from the JSON file 03:00 Write keys to Excel 07:30 For each key, access the value and write to Excel 10:34 Save the Excel file If you're not yet familiar with the basics of Microsoft Power Automate for Desktop, you may want to check out these topics used in this tutorial: - Loop actions in Microsoft Power Automate for Desktop: https://youtu.be/KPpHBVdMaFs - Excel automation basics: https://youtu.be/0QLMK53Oohk - Conditionals in Microsoft Power Automate for Desktop: https://youtu.be/U12eo9DRYdE - Text manipulation (including replace text): https://youtu.be/VA0xZKrRpok Keep in touch! Website https://mspowerautomate.com/ Twitter https://twitter.com/MsAutomate Facebook https://www.facebook.com/MS-Power-Automate-105388391663527 LinkedIn https://www.linkedin.com/in/power-automate/ #RPA #PowerAutomateDesktop #RoboticProcessAutomation #PowerAutomate