Below are the possible ways we can achieve this.
1. Web Scraping: You can use a web scraping tool or write a script in a programming language like Python, to extract the data from the website and store it in an Excel sheet. This approach is recommended if you have some coding skills and the website allows scraping.
2. Manual Copy-Paste: You can manually log in to the website, navigate to the page where the data is displayed, and copy the data to the Excel sheet. This approach is simple but can be time-consuming if you have a large amount of data.
3. Web API: If the website provides an API, you can use the API to extract the data from the website and store it in an Excel sheet. This approach requires some coding skills and an understanding of APIs
4. Web Data Connector: If the website supports a web data connector, you can use the connector to extract the data from the website and store it in an Excel sheet. This approach requires minimal coding skills and is a good option if the website supports a data connector.
5. Excel formula to manipulate the data from row s to column refer this post
Example Python script to extract the data from the website to excel sheet
0 Comments