If you need to pull data from a live URL, Microsoft Support recommends using Power Query for a cleaner import. : In Excel, go to the Data tab.
✅ No software required ❌ Loses structure if HTML is messy; not repeatable convert html to excel