
Create spreadsheet of Amazon locations from website info
- or -
Post a project like this1816
£125(approx. $166)
- Posted:
- Proposals: 23
- Remote
- #3021781
- OPPORTUNITY
- Awarded
Virtual Assistant | Web Research Specialist | Excel | Fillable / Editable PDF |Data Mining Specialist |Data Extraction | & Project Coordinator

Data Entry | Web Research | Lead Generation | Virtual Assistant | WordPress Data Entry|Excel, Word and PowerPoint
Expert in Web Scraping| Lead Generation| Prospects List Building | Email Collection |Market Research

Internet Researcher/Research/Data entry/Lead generation/Data collection/Web search/Data scrapping/Market research/PDF conversion/web scrapping/virtual assistant/Email database/Excel/Email Database

Data scraping / data mining / data extraction / web scraping / scraping / data conversion / General admin support and more

2787133238543622748041788290365248172397619713981514301139058475517514488013873802
Description
Experience Level: Expert
Estimated project 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?
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?
Frank P.
99% (52)Projects Completed
43
Freelancers worked with
47
Projects awarded
42%
Last project
8 May 2025
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies
