Excel Get Data From a Web Page or PDF: Feasibility and Steps
Decide whether and how to import data from a page or file, respecting terms of use.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
I want to bring data from an outside source into Excel. Source type and what it contains: [SOURCE_DESCRIPTION]. How often it changes: [CHANGE_FREQUENCY]. Whether I am allowed to use it (terms or licence, as far as I know): [PERMISSION_NOTES]. First tell me what to check before importing: the terms of use, whether the data is personal (remove personal data I do not need), and whether an official download or API is better than scraping a page. A decision tree in words: is there an official file, is there an API, is scraping allowed, does the source change often. Do not suggest ways of bypassing access controls or sign-in pages. Then explain the import route that suits the source (From Web, From PDF, From Text or CSV, or copying a table) and the Power Query steps to clean the result. Plan for layout changes, keep a copy of the raw data, and document the source in a sheet with name, address, date retrieved and licence. Check that imported figures match the source on first load. Mark menu names and uncertain options [VERIFY].
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.