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, can export zillow data excel spreadsheet, export zillow data excel file, zillow data export, export zillow data excel, excel book data export, excel filter data export, excel copy data closed spreadsheet, data export excel spreadsheet web form, aspnet data export excel, excel data export web form, dreamweaver data export excel, excel data export webpage, excel data export, excel copy data spreadsheet macro

About the Employer:
( 0 reviews ) United States

Project ID: #12709242

48 freelancers are bidding on average $175 for this job

$250 USD in 3 days
(520 Reviews)
8.1
$200 USD in 4 days
(221 Reviews)
7.8
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
(145 Reviews)
7.3
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
(236 Reviews)
7.3
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
(168 Reviews)
7.3
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
(250 Reviews)
7.0
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
(86 Reviews)
6.7
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
(157 Reviews)
6.4
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
(170 Reviews)
6.7
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
(130 Reviews)
6.3
abupabuya

hi sir i had very high and fresh quality 2016 list may be u interested of it [url removed, login to view] 2016 150,000 email list [url removed, login to view] [url removed, login to view] 2016 200,000 More

$200 USD in 3 days
(84 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
(103 Reviews)
6.5
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
(145 Reviews)
6.3
onlinejob247

​​Hello, I'm an expert on all of data entry, scraping jobs. I've a great researching skills to find personal/business contact info and also an expert on all of product uploading jobs. I look forward to hearing from More

$250 USD in 3 days
(52 Reviews)
5.7
asin1987

Dear Employer, I can scrap any website available. PFA some of my samples. I have scrapped following property websites: 1) Zillow 2) Trulia 3) RealtyTrac 4) Google map and many more I can do scrapping using More

$155 USD in 3 days
(32 Reviews)
5.8
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
(71 Reviews)
5.9
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
(97 Reviews)
6.0
$250 USD in 10 days
(63 Reviews)
5.6
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
(15 Reviews)
5.5
$166 USD in 3 days
(71 Reviews)
5.1