Copy data from website and paste into excel spreadsheet
- or -
Post a project like this- Posted:
- Proposals: 26
- Remote
- #1811774
- Awarded
Description
Watch helpful hints video located at: https://youtu.be/J3PMxRzSCjY
The objective is to copy and paste the correct information in to excel for the first 600 records (6 pages)
You are to submit the information in either google sheets or excel file. (There are 6000 total records that need to be sorted through in another project. This job is a test to find the best candidate for more work in the future)
Step-By-Step Instructions:
Go to: https://www.muskegonrecords.com/recorder/web/
Click Login for Public users *no Username and Password required
Once you click Submit, there will be a search criteria page. Enter this
“Recording Date” → start date = 02/01/2017
“Recording Date” → end date = 12/01/2017
“Name” = Muskegon County Treasurer
Click Search
Once your search results appear, look on the left side of the screen and see the filter options. Under “Sort by” click the dropdown menu and select “Grantee.” Then wait for your page to load.
Under “Then sort by” click the dropdown menu and select “Recording date.” Again, wait for your page to load.
Under “Sort Order” click the dropdown menu and select “Descending.” Again, wait for your page to load.
Now create a New Google Excel sheet and input heading titles seen in video. View example Google Excel Sheet at: https://docs.google.com/spreadsheets/d/1ajH7rmLuCHlWaE2W9RK5QLQQSuif8PbJMG3NHu7UkEM/edit#gid=0
In your google excel sheet, column A, write today’s date MM/DD/YYYY.
In your google excel sheet, column B, write down how many entries your search result returned. This is the number of items found in your search.
In your google excel sheet, column C, write down which page of search results you are on.
Returning to the Muskegon County Treasurer search page, look for properties that have a TREAS/FORFEIT entry and no corresponding TREAS/REDEMPT entry.
Note: Ignore entries with descriptions of COUNTY DEED or TREAS/NOJUDFOR
Once you have found an entry of interest, click on it.
The information page that loads is where we copy information from. We need:
Column D, Doc Number → Document Number
Column E, consideration amt → Consideration Amount
Column F, Party 2 (name #1) → the first full name appearing under PARTY TWO
Column G, Party 2 (name #2) → if applicable, the second full name appearing under PARTY TWO
Column H, Property Address → at the bottom of the page under Property Address
Column I, HTML Doc ID → in the url address at the top of the screen, the last portion, “DOC34598S3”
Column J, Parcel ID → underneath Legal, there will be some lines of information. Only copy down the numbers that look like “Parcel: 09-390-000-0002-00”
On to the next entry
Note: we do not want properties that have been redeemed. You will know if a TREAS/FOREFEIT has been TREAS/REDEMPT because the Parcel ID will be the same for each entry. A TREAS/REDEMPT could come before or after a TREAS/FORFEIT.
There are approx 6000 entries to sort through. There are 60 pages with 100 per page. I am only looking for a sample.
WoodKite C.
100% (2)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Woodkite,
Kindly clarify on the number of entries that you require for the sample.
Thank you. -
Can you send me a new proposal request in fixed price? I will complete the work at 70$-80$.I have already attached a file with my hourly proposal which I have sent.I will delivery it in one day.You can give me a chance.
-
Hello Sir,What is your budget for this work?
-
Hello sir,
I have clearly understood the work.I want to know that what is your budget for this project?I think it is very hard to delivery it in one day 6011 entry but I will try my best.I will send a proposal with correct sample of this work after knowing the budget.Please response me. -
Hi Woodkite,
I understand the above job is meant of invited sellers only. However, I have gone through the instructions and interested in working on this. Would you mind giving me an opportunity to offer my services, for this project?
Thanks.