In this advanced excel tutorial I will show you how to get live data from web page into excel. Live data means you’ll get updated data whenever the site changes its data. Not only this, you’ll not even have to open the website. This is a built-in feature of Microsoft excel and I am using excel 2019 for the demonstration. You’ll be able to use this from excel 10 version and above.
Now follow the instruction to import data from website to excel.
Step 1: Click on “Data” Tab
Step 2: Click on “From Web” to import data from web to excel.
Step 3: Paste the “Web Url” to pull data from a website into excel inside the address bar.
Step 4: Click on “Go”.
Step 5: If that site requires login then login here and excel will pull data from website with login
Step 6: Click on “Option”
Step 7: Select “Use the same import setting for the entire selection”
Step 8: Click on the arrow beside your data table to “Select”
Step 9: Click on Import
Step 10: Select the cell where you want the data and click ok.
Done. You’ve successfully imported data from a web page. If you need to extract data from website to excel automatically you can setup a timer to auto refresh. This will automate data scraping from websites into excel. This is how you pull data from a website into excel.
#ImportData #WebToExcel
Thanks for watching.
————————————————————————————————————-
Support the channel with as low as $5
https://www.patreon.com/excel10tutorial
————————————————————————————————————-
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ
Here goes the most recent video of the channel:
https://bit.ly/2UngIwS
Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse
Social media:
Facebook: https://facebook.com/excel10tutorial
Twitter: https://twitter.com/excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: https://excel10tutorial.tumblr.com
Instagram: https://www.instagram.com/excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial