Import Exchange Rates from the Web to Excel

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to import exchange rates from web to Excel. Let’s get started.


Data to Import

We have long list of Exchange rates to import in the following url: U.S. Dollar (USD) latest exchange rates ( as we can see below

Open Excel Workbook

Next, we open an Excel workbook we want to use to import the data

In the Get & Transform Data group of the Data tab, click on From Web

In the From web dialogue box, paste the url as seen below

Click on OK

In the Navigator dialogue box, select Table 0 

Click on Transform Data

In the Power Query editor, right-click the Chart column and select Remove

Select Close & Load To

In the Import Data as seen below, click OK

Finally, the exchange rate data is successfully loaded to Excel!

Posted in Blog.

Leave a Reply

Your email address will not be published. Required fields are marked *