Excel Macro for Web Data Extraction
Budget: $10 – $15 USD
I need an Excel Macro expert. The task is to scrape hotel data from a specified webpage and transfer it into an Excel spreadsheet.
Key Requirements:
- Data from the 3rd column (star rating) should be converted into a numerical value based on the number of stars.
- The 5th column (web address) should be transferred into the Excel table in written form.
- The macro should handle pagination and extract data from multiple pages.
Ideal Skills and Experience:
- Proficient in creating and running Excel Macros.
- Experience in web scraping and data extraction.
- Familiarity with handling data from multiple web pages.
The website is : https://ktb.gov.tr/genel/searchhotel.aspx?lang=tr&certificateType=4
Key Requirements:
- Data from the 3rd column (star rating) should be converted into a numerical value based on the number of stars.
- The 5th column (web address) should be transferred into the Excel table in written form.
- The macro should handle pagination and extract data from multiple pages.
Ideal Skills and Experience:
- Proficient in creating and running Excel Macros.
- Experience in web scraping and data extraction.
- Familiarity with handling data from multiple web pages.
The website is : https://ktb.gov.tr/genel/searchhotel.aspx?lang=tr&certificateType=4