Easily Import Data from Multiple Websites to Excel

Описание к видео Easily Import Data from Multiple Websites to Excel

Excel’s Power Query is a great tool for building queries to get data from the web within seconds and you can build a query that will pull data from a webpage and transform it into the desired format. Isn’t it great for getting data from a webpage that is updated frequently as you will be able easily refresh your query to pull the new data in?
Timestamps:

00:17 Introduction
00:51 Prepare a list of URLs
01:46 Create a query function
04:35 Use the query function on URL list

#powerquery

Комментарии

Информация по комментариям в разработке

Похожие видео