Hi Excel Community,
I'm writing to learn a bit more about the features used to pull external data from web sources. I've used excel to run external queries on other sharepoint site excel sheets which has been very helpful and I am aware of the tools to make web queries - however as far as I've been able to tell this feature is strict about the web source's formatting, specifically that it seems the source must be in a table.
The 'Power BI' application has unveiled this feature (https://docs.microsoft.com/en-us/power-bi/desktop-connect-to-web-by-example) last month where you can specify examples of the fields to collect from a web page and it can use this to format these fields and will detect other similar fields to format into a table for the query editor.
I'd love to learn how to apply this in excel - hopefully it's an available tool and I'm just missing the trick and need some direction... If not - could the excel dev team perhaps comment to confirm whether they're either looking into or working to import the feature? It seems it could be very valuable and could really improve how many of us work.
Many thanks,
Jeremy White
