Share via

Import table from azurewebsites.net to excel

Ricardo Sousa 1 Reputation point
2022-08-25T18:59:21.607+00:00

Hi everyone,
(I used a translator to write this text)

Sorry if I'm putting this question in the wrong place.
Is it possible to import a table from a site "***.azurewebsites.net" into excel?
I know there is the option: data - get data - from azure. From here, I can't do anything else.
The website (azurewebsites.net) is from a company we work with. I can consult the table on the website but I would like to import it to excel and stay connected to edit and shape it to my needs.
I don't know how to use Azure. It's new to me
I don't know which tags to choose, sorry

Thanks
Ricardo Sousa

Microsoft 365 and Office Excel For business Windows
Community Center Not monitored

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dillon Silzer 57,826 Reputation points Volunteer Moderator
    2022-08-25T19:27:32.627+00:00

    Hi @Ricardo Sousa

    1) You would go to Data > From Web > Type the web address in

    235031-image.png

    2) Choose Anonymous unless you require credentials.

    3) Then in Navigator choose the table you wish to connect to (I chose https://www.w3schools.com/html/html_tables.asp as an example):

    234954-image.png

    4) Press Load

    The result I get from w3schools is:

    234929-image.png

    If this is helpful please accept answer.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.