CONTENT!
Posted on Leave a comment

Excel tip: Use Get & Transform to connect to a website

How To Use Get and Transform To Connect To A Website - Screenshot of Microsoft Excel Charts - Excel Tips

Taking data from a web page and linking it to a spreadsheet has never been easier. Here is a website with the latest currency exchange rates. This data at xe.com refreshes regularly. We want to bring this data into cells in the spreadsheet, even if it currently isn’t laid out the way we want to display it in Excel.