Import Multiple Pages from Web with One Query in Excel

8K views May 16, 2023

In this video, we import multiple pages of data from a website with one Excel query using Power Query. We create a table of URL's that can automatically update on a sheet, import data from the web and then turn it into a function with some M code. We then create a custom column to use this function and feed it the URLs from the table to import as many pages as we want. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/2JvnnRv Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2t3netw Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/

#Educational Resources
#Educational Software
#Web Stats & Analytics