Dear Programmer, this spreadsheet details the requirements of this project.
1. The Windows version I am using is LTSC Professional Plus 2021
2. Please test it before agreeing to this job. This is how my web query look, see the most right picture, the table doesn’t show up
3. In the Worksheet "Link 1", this contains a list of basketball league tables from several countries. I have only listed 1/10 of the full list for the purpose of testing the outcome of this job.
4. The link for each of the table is listed in the RED weblink.
5. Requirement- The requirement to copy from the "R" until the last row last string, such as W1 in the example. The data will be pasted in the cell right below the link, in this example is Cell B7.
6. Requirement- When the spreadsheet is opened, there should be an option if i want to refresh all the links, or remain as it is.
7. Requirement- Computation or refresh of the data should be within the Excel file itself, if an external programme is required, i can consider if it is not too complex.
8. Requirement- must be able to add to this list as it is not complete and there are always changes
For 2nd link
3. In the Worksheet "Link 2", this is for the pasting of data from the weblink
4. The link for testing is [login to view URL] , cell A2.
5. Requirement- There are a total of 5 tables needed for each weblink. All the web version of the tables are shown the right for reference.
6. Requirement- i am able to use web query to extract the 1st 4 tables, except for "Live Odds Comparison". it doesn’t show up in my web query.
7. Requirement- if you are creating a macro, please test it with this version of Office as i have tried many times with many settings changes.
8. Requirement- You can create a macro, so that it starts to download when triggered.
If there is something wrong with my settings, you can point out to me , if i can get the data in, i don’t mind to pay you a fee to learn it and overcome it.
Hello there!
I am thrilled to offer my expertise in Excel and Excel VBA macros for your project. With my extensive experience and passion for creating efficient solutions, I am confident in my ability to deliver results that align perfectly with your requirements.
I have found out that the data on the webpage is displayed using AJAX.
I have found a way of getting the data. I can provide a demo before you decide to award.
I am eager to collaborate with you and deliver exceptional results that exceed your expectations. Don't hesitate to contact me with any questions or to discuss your project in more detail. Thank you for considering me for this opportunity.
$15 SGD in 1 day
4.8 (44 reviews)
4.6
4.6
29 freelancers are bidding on average $21 SGD for this job
Hello!
Seeking a skilled Excel Web Scraping Expert for efficient data extraction and organization. With extensive experience in web scraping techniques and Excel proficiency, we guarantee accurate and timely delivery of desired data. Let us streamline your data acquisition process for enhanced productivity.
Thank you-
As an experienced data analyst with 3+ years in the field, I believe I am well-suited to tackle your Excel web scraping project. I understand you've encountered some obstacles configuring your web query and seeking a solution that can be accomplished within Excel itself. My skills in web scraping and data conversion align impeccably with your needs. Rest assured, I can deliver a finished product that not only adeptly scrapes and refreshes data, but also grows organically as you need to add or modify information.
Having tackled similar projects in the past, I am familiar with both extracting data from tables and handling more intricate elements like "Live Odds Comparison" which posed difficulties in your previous queries. Not only can my service address these concerns, but if there are any lingering inefficiencies in your current approach, I will present them while providing you with viable alternate solutions.
Data mining is a far-reaching skillset and appreciating the value of transparency for you, I'll provide you with conclusive results before embarking on our collaboration. Let's discuss how we can get your necessary data into your worksheets efficiently. You can trust me to provide top quality work within the agreed timeline while consistently maintaining strong communication throughout the process, ensuring you're always updated on progress. Choose me for an efficient Excel expert ready to take on any challenge for you!
(((((((( Available to start working immediately ))))))))
I specialize in web scraping bot programming and possess exceptional expertise in designing, developing, and deploying web bots. My skills align perfectly with your project requirements, whether it involves data extraction, research automation, or website change detection.
While the specific function of the bot is yet to be determined, I excel at intuitively understanding client needs based on incomplete information. This intuition, combined with my technical proficiency, allows me to create customized solutions tailored to your requirements.
Quick execution and project completion are high priorities for me, although the timeline for this project remains flexible. I am committed to delivering top-notch results within a reasonable timeframe.
Let's discuss your project in more detail and explore how my expertise can help you achieve your goals. I'm eager to collaborate with you to bring your vision to fruition.
I'm a dynamic candidate seeking for a Data entry, Data extraction, copy paste works where my knowledge on MS word, MS Excel, Typing and communication abilities can be utilised for this role. I will do my best as fast and accurate and without affecting your deadlines.
I have knowledges about data entry excel spreadsheet how to maintain data in excel, deliver data, email and how to enhance company growth with good work.
Hi __, I will write all the speeches and provide you with standard short notes. I am good at freelancer data entry. I will provide quality work as per your instructions. Please provide me the projects so that we can discuss it further. Thank you
As a seasoned tech professional, I have gained proficiency in all types of systems and troubleshooting. I'm adept at working on complex projects and craving solutions for even the most convoluted issues. My expertise in data extraction, especially web scraping is precisely what you're looking for in your incumbent. I've worked on many such projects before, comfortably extracting data like table elements as required in your project.
Additionally, my experience with Office's Web Query tool will be beneficial when it comes to refreshing the data within your Excel file efficiently. However, if complexity arising from sources external to Excel demands, I can flawlessly integrate those solutions too. Furthermore, through my skills in PHP I can also provide Customized Automation Solutions for your Excel Sheets.
Rest assured, since this project entails updating and expanding the lists regularly; my versatility in handling dynamic worksheets will prove helpful. I understand the value of time and meticulousness when it comes to data entry tasks and pledge to deliver beyond your expectations while adhering to deadlines. Of course, any issue that arises with your existing settings we can work together to get fixed. Consider giving me the opportunity to demonstrate my prowess in turning complex challenges into delightful solutions!
I am Professionally trained Data Entry Operator, editor expert with over 5 to 7 years experience working with public sector like hospitals and education as a data entry operator, and also attached with social media posts and much more for your business
I very gald to work with you with high accuracy and resposibility in very price in less time.i have five years experience in lots of companies and famoust siten tollingo.
I can assist you with:
Data Entry
Web Scraping
Excel
Web Search
Data Mining
Data Processing
Web Search
Product Upload (eBay, Amazon, WordPress, Shopify, eCommerce)
yous regards
ranjeet singh
I have seen that you are in need of a Excel Web Scrapping Expert position.
With this, I would like to apply for the said position.
I believed that my previous work experience would aid me in the job post I am applying for. I am a detail-oriented person in terms of doing my task and finishing the work on time with satisfaction, and I am easy to learn or adapt to new things.
Skill set:
Proficiency in using Microsoft Excel
Online researcher
Data mining
Web scraping
Accuracy of Data Entry
Typing
I will gladly accept your decision.
Kindly Redards,
Rosabelle
Hello sir/ma'am
As a dedicated freelancer with a broad skill set that includes Data Entry, Excel, and PHP, I bring to the table years of experience in Python web scraping and automation. Your project is right up my alley, and I have no doubt that I'm the right person for the job.
✔ Excel Expertise: My expertise in Excel encompasses power queries, dynamic charts, macro development, and VBA implementation, all of which are applicable to your project's requirements. I can easily work within the Excel file to compute and refresh data in a seamless manner.
✔ Web Scraping & Automation: A significant part of my professional journey has revolved around web scraping; it's one of my key strengths. When combined with my automation skills, it translates into efficient data extraction from multiple web pages on demand or through scheduled triggers,such as yours for downloading. This would make copying and pasting data from basketball league tables a walk in the park.
My availability online 24/7 would ensure prompt communication and rapid troubleshooting if any issues arise along the way. Let's discuss further how we can maximize Lemon's potential to suit your needs!
Thanks
Dear Client
I'm eager to handle your project with 2 years of experience in data entry and MIS. I assure timely delivery, quality work, and clear communication throughout the project.
Why Choose Me:
Experience: 2 years in Data entry and copywriting.
Skills: Proficient in MIS.
Quality: Attention to detail, accuracy, and best practices.
Communication: Clear and prompt communication.
Timely Delivery: Adherence to deadlines.
Proposal Details:
Timeline: 2 Hours.
Budget:21 USD.
Looking forward to discussing further and delivering excellent results.
Best regards,
Suraj kumar
@surajk111
Hi sir I am Mahi . I am a professional excel editor expert with more then 1 year of experience in this field. I usually work with excel, data entry, graphic designer.
Hi! I'm a full stack developer with 3 years of experience and I have strong background of Web Scraping.
With my extensive experience in web development, especially in Web scraping, I am confident in my ability to provide you with a smooth and effective solution for this project. And I can start right now. Please contact me.
Thanks.
If you work with me, the result will be good.
As an experienced fullstack developer, your project title immediately captured my attention. I have a strong background in data mining, PHP, and web scraping which makes me fully equipped to handle your Excel web scraping requirements. Over the span of 5 years in the industry, I've worked extensively with backend languages like Python and PHP and utilized technologies like web query and macros proficiently. This aligns perfectly with your need for a developer who can harness the power of Excel to effectively scrape web data. In addition, my hands-on experience with different versions of Windows will ensure a smooth and hassle-free integration of the solution to avoid any compatibility issues.
Finally on personal note, as a Licensed Professional Engineer, through my civil/structural engineering roles, I have further fortified my analytical and problem solving skills alongside enhancing my talent for detail orientation. So you can _ASSUME_ from these profiles that I'm not just a tech-guy but an all-in-one solution provider. Rest assured, by choosing me, not only are you getting someone who knows their way around code but also someone who does their due diligence while delivering his services in a timely manner. Let's talk about how we can get your project up and running!..
I have knowledge of python basic to advanced and web scraping selenium and beautiful soup and SQL and I have completed many projects like Flipkart Amazon etc
i am a detail-oriented data entry specialist with 2years of experience i am proficient in most data entry software and hav a proven track record of delivering high quality result . i am confident that i can meet your data entry needs and exceed your expection i will work closely with you tounderstand your specific requirements and develop a customized data entry plan.
