Add table using examples button / function is missing in Get Data / From Web / Navagator

Question

In Excel Get Data / From Web / Navagator - I don't have a "Add table using examples” button / function. How can I get it?

I have Office 365 for enterprise, Excel Version 2206 (updated today)

Answer 1

Dear bd-122,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

According to my investigation, this feature currently only appears in PowerBI. There is no such feature for Excel yet.

Power BI:

Excel:

It would definitely be ideal if we can add this feature to Excel, thank you for bringing thing to our attention.  I took the liberty of creating an entry in our Feedback community link and my team has voted for this:"Add Table Using examples" and html.table() function should be included Excel and not just PowerBI · Community (microsoft.com) I suggest that you encourage your team to do the same.  Our Product Team is in-charge of the site and they are constantly checking the comments and feedback from our customer

Sincerely,

Tin | Microsoft Community Moderator

***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save".***

Answer 2

Thank you for your reply and I appreciate you making this a suggested feature to add.