Forum Discussion
Emergency Help
Hey, I want to make an excel sheet that can load a table from a web page [https://market.todaypricerates.com/egg-rate-in-Patna] the table number is 1, to my excel sheet and I want that it should refr...
To create an Excel sheet that can load table data from a webpage, you can use the "Web Query" feature in Microsoft Excel. Here are the steps to achieve this:
Open Microsoft Excel:
Start by opening Microsoft Excel on your computer.
Create a New Workbook:
Open a new workbook or an existing one where you want to load the data from the webpage.
Access the Data Tab:
In Excel, go to the "Data" tab in the ribbon at the top of the window.
Get Data from Web:
Under the "Data" tab, you will find various data import options. Click on "Get Data" or "Get Data from Web" (the exact option may vary slightly depending on your Excel version).
Enter the Webpage URL:
A new window will appear where you can enter the URL of the webpage you want to extract data from. In my case, i use the following URL: https://rateofegg.in
Load the Data:
After entering the URL, click the "OK" or "Import" button. Excel will connect to the webpage and retrieve the data. It will show you a preview of the data available on the page.
Select the Data Table:
In the preview window, you can select the specific table or tables you want to import. Click on the table that contains the data you're interested in. If the webpage has multiple tables, you can choose the one you want to import.
Load Data to Excel:
Once you've selected the table, click the "Load" button. Excel will import the data into your worksheet. You can choose to load it to a new worksheet or an existing one.
Data Refresh:
Excel will create a connection to the webpage, and you can choose to refresh the data at any time. To do this, right-click on the imported data in Excel and select "Refresh" to update it with the latest data from the webpage.
Now, your Excel sheet is set up to load table data from the webpage. You can set up automatic data refresh if you want the data to update periodically. This method is convenient for extracting and working with data from webpages without manual data entry.
Open Microsoft Excel:
Start by opening Microsoft Excel on your computer.
Create a New Workbook:
Open a new workbook or an existing one where you want to load the data from the webpage.
Access the Data Tab:
In Excel, go to the "Data" tab in the ribbon at the top of the window.
Get Data from Web:
Under the "Data" tab, you will find various data import options. Click on "Get Data" or "Get Data from Web" (the exact option may vary slightly depending on your Excel version).
Enter the Webpage URL:
A new window will appear where you can enter the URL of the webpage you want to extract data from. In my case, i use the following URL: https://rateofegg.in
Load the Data:
After entering the URL, click the "OK" or "Import" button. Excel will connect to the webpage and retrieve the data. It will show you a preview of the data available on the page.
Select the Data Table:
In the preview window, you can select the specific table or tables you want to import. Click on the table that contains the data you're interested in. If the webpage has multiple tables, you can choose the one you want to import.
Load Data to Excel:
Once you've selected the table, click the "Load" button. Excel will import the data into your worksheet. You can choose to load it to a new worksheet or an existing one.
Data Refresh:
Excel will create a connection to the webpage, and you can choose to refresh the data at any time. To do this, right-click on the imported data in Excel and select "Refresh" to update it with the latest data from the webpage.
Now, your Excel sheet is set up to load table data from the webpage. You can set up automatic data refresh if you want the data to update periodically. This method is convenient for extracting and working with data from webpages without manual data entry.