Скачать или смотреть How to Get Data from Web in Excel & Refresh

Turn a web table into a refreshable Excel table in seconds using Power Query. Use Data → From Web, paste the Wikipedia Champions League standings URL, select the correct table in Navigator, and Load. After the next matchday, go to Data → Refresh All (or right-click the table → Refresh) to pull the latest numbers and update web data automatically.

Heads-up: many modern sites block web connectors with logins, dynamic scripts, pagination, so From Web won't work everywhere—Wikipedia and other static HTML tables are the most reliable for web scraping Excel.

Pro tip: in Query Properties, enable auto-refresh on open or refresh every N minutes, and keep a backup if the page layout changes.

✅ Import tables from a URL
✅ One-click refresh for new results
✅ Clean, repeatable workflow (no copy/paste)
✅ Query Properties: auto-refresh options

excel power query,
import web table to excel,
wikipedia to excel,
excel refresh data,
auto refresh excel,
power query from web,
excel web data import,
refresh web data excel,
power query tutorial,
excel live data,
web scraping excel,
excel navigator,
query properties excel,
excel refresh all,
power query web import

#shorts #excel #excelshorts #exceltips #powerquery