Hello! This is my first project so bear with me if there are some inconsistencies in my request, be ready to communicate a lot. :)
What I am trying to achieve -with your help- is the creation of a small application which will crawl all the URLs of a website and print them on an Excel sheet in a specific way. Please see the example file for, well, the example - it's basically a sitemap replica, with a specific placement so that you can see the site tree more easily.
I don't mind how you do it: it can be a smalla Java application, a script, something in PHP and whatnot. As long it run it Windows it's fine, even if it's "complicated" to (meaning that I would have to do something more than double click an .exe and type an URL, like run it with an orchestrator like Jenkins among other things).
Feel free to leverage anything for this such as the [login to view URL] of the site, or an external program (for example a SEO Spider to grab all site's pages, like Screaming Frog one) - I would prefer oper source solutions but I am willing to buy a license if necessary.
The output should be an Excel file but it's not a strict requirement, even something I can import as data in Excel (like a csv) would be absolutely fine as long the formatting in the example is achieved.
I am open to all possibilities and I am well aware that I don't have many technical specifications: this is due to the fact I only have an idea but not sure what would be the best way to execute it. I have asked a colleague of mine a simple evalutation and he told me this should be simple enough though, something around 2 hours of your time but again, I am very open to proposals.
I want an application to automate the process a bit, doing it manually is very easy but time consuming for large sites - I am well aware that the output result may need some rearranging work but that's fine (surely better than do everything manyally anyway...).
So, to recap what I would like is something like this:
- Open application
- Type website URL
- Application crawls all website pages, put the URLs on the Excel and create a structure
- Application output the file for review
Feel free to ask me anything not clear. Cheers!
20 freelancers are bidding on average €126 for this job
Hey, I would love to help you with your first project to automate Excel sheet to extract data. I would like to chat with you to successfully complete this project
Hi, I understand your requirement, so I can do this task very effectively. If you hire me then I trying to complete this task within your timeline. Thank you. Tanmoy.
Hi, I am a Python developer and i have designed numerous scraping applications before.I would be excited working with you on this [login to view URL] you have any questions feel free to [login to view URL]
Did similar sorts of work for last couple of years. Looking forward to help you complete the task one more time. Please visit my portfolio to have a look of similar projects as your one.
We work in IT service sector. If you have any requirement for Web development, Mobile Application development, Digital Marketing & Advertisement, Animation Movies or any outsource process. Please let us know.