Closed

Export data from Zillow into Excel Spreadsheet

Export Data from Zillow for Excel

1. Use an Excel file containing property addresses to look-up the property record on [url removed, login to view], export the data, and paste it into the address source spreadsheet in the appropriate columns.

2. Assume the method is a VB Macro embedded in the spreadsheet.

3. If creating a separate CSV file containing the data is easier, more accurate, or costs less, let’s discuss.

4. Please note that I may not have identified all of the potential Fields (data columns) available in Zillow listings since many of the field only appear under specific conditions.

Input Source: An Excel file containing address fields. (See Spreadsheet for Example Layout)

Export: Zillow Field data to be exported listed below. (See Spreadsheet for Example Layout)

Field Example Format

Zillow Property URL [url removed, login to view]

Text

Street Address Text

City Text

State Text

ZIP Text

For Sale: Number

Price Cut: Number

Zestimate: Number

Rent Zestimate: Number

Beds: Text

Baths: Text

SqFt: Text

Lot: Text

Year Built: Number

Last Sold: Text

Parking: Text

Cooling: Text

Heating: Text

Fireplace Text

On Zillow: Number

MLS#: Text

Descriptive Paragraph: YOU CAN HAVE IT ALL!! Fabulous 5 bedroom home in West Petaluma located in the heart of Victoria, featuring over 2,500 sq ft of living area with a professionally landscaped backyard that backs up to open space. Master is on the 1st floor and 4 spacious bedrooms are upstairs. Very peaceful setting only a block from Helen Putnam Regional Park with hiking and biking trails. Private playground and tennis courts nearby too! Text

Zestimate: Number

Rent Zestimate: Number

From Price History Table

Date Date

Description:

(values seen)

Price Change

Sold

Listing Removed

Listed for Sale Text

Price: Number

From More Facts:

Combined Facts

Construction quality: Number

Neighborhood Name: Text

Parcel #: Format in Zillow: 008580003

Return in this format: 008-580-003 Text

# Stories: Text

Zillow Home ID: Text

Notes:

1. Field “Price Cut” is a dynamic variable field, e.g., not always included in the visible record.

2. For any field with no data, return the placeholder “—“ if present or “N/A”, if field is blank.

3. Price History Table: Note: “Historical data not available for this property” can be returned.

4. Price History Table: Return only most recent entry from this table.

5. Parcel #: Leading zero, if present, is a part of the number and must be returned. NICE TO HAVE: Return data in this format: nnn-nnn-nnn. Insert a hyphen after the first three digits; insert a hyphen after the next three digits.

6. If property record not found on Zillow, return “N/A” in the Zillow Property URL field.

Skills: Data Mining, Excel, Web Scraping

See more: zillow data excel spreadsheet, zillow data export, export zillow data excel, excel book data export, excel filter data export, aspnet data export excel, dreamweaver data export excel, excel data export webpage, excel data export

About the Employer:
( 0 reviews ) United States

Project ID: #12709242

49 freelancers are bidding on average $174 for this job

$250 USD in 3 days
(388 Reviews)
7.7
$200 USD in 4 days
(205 Reviews)
7.5
ehsankayani

HI, I already have a zillow scrape by address bot i created some time back it has most of the needed fields and will add the other. Thank you

$210 USD in 5 days
(123 Reviews)
7.1
Webxpert4u

Hello, I am ready to extract data from Zillow for all required fields using VB Macro. LETS DISCUSS before starting the task. I'm using python/scrapy/django for all kind of data extracting & Mining tasks. Sometime More

$250 USD in 7 days
(129 Reviews)
6.9
mirniyazuddin92

Dear Sir/Ma'am, I am a Web research, Data Entry & Webs Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information More

$200 USD in 3 days
(158 Reviews)
6.7
khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India

$250 USD in 3 days
(219 Reviews)
6.8
flashsaiful

Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful

$155 USD in 3 days
(163 Reviews)
6.7
abupabuya

hi sir i had very high and fresh quality 2016 list may be u interested of it YELP.com 2016 150,000 email list https://www.dropbox.com/s/qkmly9cp3siehmt/yelp_email_sample_2016.csv?dl=0 houzz.com 2016 200,000 More

$200 USD in 3 days
(81 Reviews)
6.1
Verz1Lka

Hello! I'm web-scraping and web-automation expert and i think i can help you. I use python language and scrapy framework. My scripts works on windows, mac or linux, but linux is preferably. I can schedule scripts on s More

$133 USD in 3 days
(76 Reviews)
6.2
dpune

Hi, I have more than 14 years of Web Scarping and Excel/VBA exp and I am expert in this kind of work. Please send me more details so that I can estimate cost and time better. I have completed more than 300 p More

$250 USD in 12 days
(115 Reviews)
6.2
Eagles90

Dear Client, I am interested in your project and ready to go for it. I have done many similar projects so confident to handle this project. You can check my profile and reviews and hope you would consider me for you More

$222 USD in 6 days
(34 Reviews)
5.9
mehedi276

"Rate and duration will be fixed on discussion" Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed sev More

$144 USD in 3 days
(133 Reviews)
6.2
Tanmoy236

I am fast accurate and at the same time understand the value of quality and deadlines. I have already done 100 works on Freelancer where majority of the works I got all 5 star rating and the employer was extremely happ More

$200 USD in 3 days
(69 Reviews)
5.7
$250 USD in 10 days
(59 Reviews)
5.5
ponnarasiBabu

In order to make your project a success, you need someone who has ample knowledge and a keen eye for detail, both of which I have. However I would require more details of the work. So i hope you would open a PM to disc More

$277 USD in 3 days
(30 Reviews)
4.7
$250 USD in 5 days
(21 Reviews)
4.6
asifdwan

Hi there! I am specialist on scraping data from any kind of websites including frequently blocking sites. Also an expert on all of data entry & research jobs. I’m ready to start it right away. I look forward to hea More

$250 USD in 5 days
(53 Reviews)
4.7
mohamedrdait

Hello sir I can create a bot to scrape data i have developed many bot Please contact me to share with you my script The script will be a desktop application for windows os vb.net Contact me for more details Best More

$155 USD in 3 days
(9 Reviews)
4.0
eskemar

Dear please give me the chance to work for you I have good computer skill and I have been through Ms Office, PDF, Data entry, Typing and copy/paste for many years. Now I need to work to get a good feedback and increas More

$50 USD in 3 days
(7 Reviews)
3.7
shahiddar

Hello, My name is shahid from Kashmir I have a rich experience in the field of data mining data scrapping, I am certified python developer, I have successfully completed more than 1000 projects in this field you wi More

$30 USD in 0 days
(4 Reviews)
4.0