Expected duration: 1 day or less I need to have a spreadsheet database created which contains all of Amazon's delivery locations.
The information is here. https://www.mwpvl.com/html/amazon_com.html
Unfortunately it is stored as an image, not text, so it cannot be simply copied and pasted into a spreadsheet.
The best way to do it (I think!) is to do a screenshot of a section of the site (save as a jpg or gif), then put it through an OCR service, like this one (https://www.onlineocr.net/) which will give a basic spreadsheet of a section of the list. But it will then need some manual tidying up: - combining into one sheet - merging some lines so that there is one row per site - fixing the dates. I want all the dates to be in the same format (eg Jan-2020) so that they are sortable. Then repeat until you have got them all.
Altogether I believe there are about 750 sites, so about 750 rows in the final spreadsheet - c.450 in the US and c.300 in the rest of the world. (I don't want the fulfilment centres, just the delivery sites so it is not everything on the page, and ignore the flag column!)
I think it will take about a day to do it.
If you are interested in doing it, please tell me about something you have done where you have had to manipulate data a little bit in excel, and answer this question at the start of your proposal to help me filter out people who haven't read the brief. Which country is Amazon based in?
