Excel’s Web Scraping Trick: Import Live Data from Websites
Stop manual copy-pasting! Learn how to use Excel’s Data → From Web feature to import live tables from websites like Wikipedia, Yahoo Finance, and more. We cover setting up automatic refresh and handling basic authentication. Perfect for live stock prices, weather updates, and sports scores.
Still pasting website tables into Excel?
Learn how to use Get Data → From Web to pull live data from websites — and refresh it automatically.
✅ Covered in this tutorial:
• How to use From Web
• Importing tables from sites like Wikipedia, ESPN, Investing
• Setting up automatic refresh
• Handling logins and authentication
• Real-world use cases: stocks, weather, sports.
🌐 BEST WEBSITES FOR SCRAPING:
Wikipedia - Data tables on any topic
Yahoo Finance - Live stock prices & market data
Weather.gov - Weather forecasts & climate data
ESPN.com - Sports scores, standings, statistics
CoinMarketCap - Cryptocurrency prices & rankings
💡 PRO TIPS FROM THE VIDEO:
Set different refresh intervals for different data sources
Use Power Query to clean data before importing
Handle authentication for sites requiring login
Create multiple queries in one workbook
Fix broken queries when websites change structure
⚠️ IMPORTANT NOTES:
Always respect website terms of service
Don't over-refresh (respect rate limits)
Cross-reference important financial data
Works with Excel 2016, 2019, 2021, and Office 365
💻 SOFTWARE USED: Microsoft Excel 2024 (works with 2016+)
🎬 SCREEN RECORDING: OBS Studio
⚖️ LEGAL NOTE: Educational content - always respect website terms of service
📋 General Scraping Tips:
✅ What Works Well:
• Tables with clear headers and consistent formatting
• Numerical data (prices, statistics, rankings)
• Regularly updated content
• Public information (no login required)
⚠️ What to Watch For:
• Rate limiting: Don't refresh too frequently
• Structure changes: Websites occasionally update their layouts
• Terms of service: Always respect website policies
• Data accuracy: Cross-reference important data
🔧 Excel Compatibility Notes:
• All these sites work well with Excel's "From Web" feature
• Most tables are auto-detected by Excel's table recognition
• Minimal data cleaning usually required
• Power Query handles most formatting automatically
📊 Recommended for Beginners:
1. Wikipedia - Most reliable and beginner-friendly
2. Weather.gov - Simple data, good for learning
3. Yahoo Finance - Great for real-world applications
🚀 Advanced Users:
1. ESPN - Complex tables with lots of data
2. CoinMarketCap - Fast-changing data, good for testing refresh rates
Remember: Always check a website's robots.txt file and terms of service before scraping. These recommendations are for educational purposes and personal use.
📱 CONNECT WITH US
👉 www.skilli.me
📺 / @skillilearning
📲 t.me/skilli_me
🔗 linkedin.com/company/skilliedtech