Export data from Zillow into Excel Spreadsheet and filter with other data

Export Data from Zillow for Excel

1. Use an Excel file containing property addresses to look-up the property record on [login to view URL], 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 [login to view URL]


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


(values seen)

Price Change


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


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 api, export zillow data to excel, export real estate listings to excel, trulia, zillow excel spreadsheet, zillow data scraper, real estate data api, zillow data download, Fill in an Excel Spreadsheet with COMPLEX Data, excel spreadsheet merge row data word, export webpage excel spreadsheet, import export information excel spreadsheet adobe pdf form, export data zillow excel spreadsheet, excel spreadsheet containing sales data, can export zillow data excel spreadsheet, export zillow data excel file, export data zillow excel, partime excel spreadsheet form filling data entry, export zillow excel, export zillow data excel

About the Employer:
( 0 reviews ) United States

Project ID: #17122565

34 freelancers are bidding on average $159 for this job


hi,sir/madam I am providing All types of Online and Offline Data Entry, Web Research Jobs. Whether you need an enthusiastic Virtual Assistant or Office Admin Support I'm very willing to work with you. I'm fully capabl More

$250 USD in 7 days
(1 Review)

Hi, I am an Excel automation expert and have prior experience in Excel macro based project releated to scrapping data from Zillow. I am assuming you have a Zillow account.

$250 USD in 4 days
(167 Reviews)

hello. nice to meet you. your project is very interesting to me. If you hire me, I can start working for you right now. I have a good experience in excel and excel vba. thank you for your job posting. best regard More

$155 USD in 3 days
(10 Reviews)

Dear Employer, I'm ready to work on zillow data export project. Relevant Skills Excel, VBA Milestones 88 USD - project requirements done and delivered 88 USD - last milestone after full checking and testing I have More

$177 USD in 3 days
(108 Reviews)

Hello Sir, We can use zillow API for this to get results very fast. I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am Excel and Web Scrapping Expert on freelancer.c More

$250 USD in 2 days
(567 Reviews)

Hi there, I will do the required excel work as mentioned by you in the job description, message me so that we can discuss in detail your requirements. Thanks

$150 USD in 3 days
(6 Reviews)

Hi, I have experience of pulling data from zillow in past to generate reports. SO I can help in your project according to your requirements. >> 2. Assume the method is a VB Macro embedded in the spreadsheet. >> 3. More

$200 USD in 3 days
(55 Reviews)

Hey, I'm interested in your project. Please send me a message so that we can discuss more. Web scraping and crawling documentation Language: Perl, Python Editor: Notepad++ Regex Matching: Exp More

$155 USD in 3 days
(0 Reviews)

I have excellent command on MS Excel and have worked with Zillow before. I can write a macro to extract the data in required format. I have completed complex projects in Excel before . For instance - Get match detai More

$250 USD in 3 days
(31 Reviews)

Hello. I have more than 9+ years of experience in Data processing,Data entry, Excel, Python,Software Architecture,Web scraping, scraping tools like python scraper which you can use to scrape data from Websites and othe More

$100 USD in 3 days
(11 Reviews)

Hello there! I have reviewed your requirement and based on the instructions mentioned in the description I have created few samples for you. Please reply to my bid so that I can share few samples for you. Looking fo More

$88 USD in 2 days
(263 Reviews)
$155 USD in 3 days
(0 Reviews)

I'm a biggner Relevant Skills and Experience Excel

$155 USD in 3 days
(0 Reviews)

1 year of experience in Data reporting and Data Analysis Proficiency in data manipulations and generating tables using Advanced Excel Proven ability in data cleaning and validation for quality reports Excellent rep More

$155 USD in 3 days
(0 Reviews)

Specialists in Microsoft Office, Data Mining, Data Entry, Graphic Designing and Writing. Commendable work ethic and most projects are completed within the desired duration, with utmost quality and relatively better pr More

$40 USD in 2 days
(0 Reviews)

I will work exclusively on the project when chosen

$155 USD in 3 days
(0 Reviews)
$155 USD in 3 days
(0 Reviews)

I have been working from home for almost 2 years now. I am well experienced with data entry and web research. I am well organized, reliable and fast learner. I am detailed oriented, organized and hardworking. I am conf More

$200 USD in 3 days
(0 Reviews)

I can scrape data from Zillow. Previously i have work on Zillow api, Redfin etc. Lets Chat for more details. Thanks.

$200 USD in 10 days
(0 Reviews)

i did understand your requirement, i have 3+ years of data mining and Machine learning Experience in python, i am feeling confident in python for your problem, looking for your response

$155 USD in 3 days
(0 Reviews)