How to do Real Time Currency Conversion in Excel

This video tutorial shows, how to do real time currency conversions in Microsoft Excel with live exchange rates from the European Central Bank. You'll learn how to do a REST API call in Excel and parse the recieved JSON with Power Query.
Join my community, 7-day free trial: iloveautomation.ai/community

You could also watch:
🔵 How to do progress circle charts in Excel (must watch): youtu.be/seWAbHuumX8

0:20 Present the Excel Currency Exchange Case
We have a column in Excel, which we want to apply live currency rates to.

0:38 Use an API
We use the an API with live currency rates from the European Central Bank. When we call the API we get the result in JSON format.

1:40 Data from an API in Excel
We use From Web and apply Power Query to it and get the data in a table. Let's update the currency rates each minute (change it in the properties).

#microsoft #excel #powerquery