Completed

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 excel, export data zillow, export zillow data excel, export zillow excel, zillow export excel, zillow spreadsheet, export zestimate history, export data zillow excel spreadsheet, export zillow, zillow excel data, zillow export, zillow data spreadsheet, zillow data excel, export mls excel zillow, export zestimate, zillow excel file, zillow export data, export zillow data, export data excel url, export excel zillow

About the Employer:
( 3 reviews ) Petaluma, United States

Project ID: #1344355

Awarded to:

developerphp2007

Please check PMB...................Thank you..............

$110 USD in 5 days
(17 Reviews)
4.8

20 freelancers are bidding on average $143 for this job

srinichal

I am an expert in automation and can deliver the same

$180 USD in 4 days
(26 Reviews)
6.1
vbexcel

Data mining expert - ten years experience.

$120 USD in 2 days
(27 Reviews)
5.3
kulhanekd

I would like to bid on this Project. Thanks Donna

$150 USD in 5 days
(9 Reviews)
4.4
Engineer85

Hi, I am interested in doing this project. Please check your PM to answer my few question. Thanks

$130 USD in 3 days
(13 Reviews)
4.4
diepbp

I am confident to handle your project. Please check your inbox for details, thank you.

$100 USD in 2 days
(7 Reviews)
4.1
muthumuni

Hi, I can make iMacro script which can pull all the data in to CSV file. or can make Excel VBA for same. So kindly contact me for more information or, start the project. thank you. muthumuni.

$100 USD in 3 days
(6 Reviews)
3.5
habayabah

Please read my PM for details of my bid.

$45 USD in 1 day
(3 Reviews)
3.2
hereforfreelance

Hi, Please check pmb for details Thanks Priya

$50 USD in 5 days
(7 Reviews)
3.1
jkumarsanson

Please refer my inbox

$30 USD in 1 day
(8 Reviews)
3.1
jyovai

Project can be done using VBA and I am ready to start immediately. Refer to inbox for message.

$65 USD in 4 days
(1 Review)
1.3
ravijmca

Hi Please check my PM

$80 USD in 5 days
(0 Reviews)
0.0
creativeorg

I want to do this job for [login to view URL] check my PM for more details.

$60 USD in 1 day
(0 Reviews)
0.0
VUSOLS

Please, check my PM.

$100 USD in 2 days
(0 Reviews)
0.0
HemantJeur

Hello, I am having 5 years experience in US real estate projects. Please see your inbox.

$100 USD in 5 days
(0 Reviews)
0.0
MDISystems

I can do this work.

$100 USD in 5 days
(0 Reviews)
0.0
danielthibitie

Well explained, well understood. I'm ready to begin. Thank you.

$120 USD in 5 days
(0 Reviews)
0.0
ngbm1310

I´m ready for that job

$75 USD in 7 days
(0 Reviews)
0.0
mfd1976

I've reviewed your example document and spreadsheet and can make a adaptive windows macro (not just excel) that will look up the property and copy all the relevant data into the spread sheet with 100% accuracy and then More

$250 USD in 7 days
(0 Reviews)
0.0
rmp3

Good day! my bid stands at $750.00 for 22 days, that is with the minimum of 8 hours work a day for 5 days a week. i have been doing data entry work for more than 4 years. i fully understand the importance of credibi More

$750 USD in 22 days
(0 Reviews)
0.0
dentonc12

I'm a US born and based software developer with 15 years+ of excel development experience. I just actually completed my fist Freelancer.com gig of web scraping similar to yours and the clients is very happy it seems. More

$250 USD in 2 days
(0 Reviews)
0.0