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

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
25,290 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,362 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dillon Silzer 35,956 Reputation points
    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.