Import Multiple Pages from Web with One Query in Excel

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 ► LinkedIn: 18737946
Instagram ► Instagram: computergaga1
Twitter ► Twitter: computergaga1

• #howto_style
• #microsoft_excel
• #power_query
• #import_from_web
• #computergaga
• #web_scaping
• #excel_tips
• #excel_power_query_tutorial
• #import_from_web_to_excel
• #import_from_website_to_excel
• #alan_murray
• #import_multiple_pages_from_web
• #import_multiple_pages_from_web_with_one_query_in_excel
• #import_multiple_web_pages_into_excel