Getting full control over your files at any moment is essential to ease your daily tasks and boost your productivity. Achieve any objective with DocHub features for document management and convenient PDF editing. Gain access, change and save and integrate your workflows with other safe cloud storage services.
DocHub gives you lossless editing, the chance to use any format, and securely eSign documents without the need of searching for a third-party eSignature software. Maximum benefit of the document management solutions in one place. Try out all DocHub features today with the free profile.
Today, were going to import data from the web to Excel. Were going to be using get and transform from the data tab. This used to be the Power Query add-in, but since Excel 2016, its a part of Excel. Its a super useful feature that connects to different data sources, transform and loads data for you so that you can do further analysis on it. If this sounds complicated to you, dont worry. All of this is going to be done with a few clicks, and the best part is that once we have it set up, the data can be refreshed with just a click of a button. Lets get to it. (upbeat music) Lets do two examples. In the first case, were going to import spot prices for petroleum from a web page into Excel. In the second case, were going to import the weather forecast for the next 10 days. Now, were going to do it in a dynamic way, so the data that we import is going to be connected to the original web page. So whenever we want to get the newest information, all we have to do is refresh our table