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 (floatrates.com) 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!