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

Cerrado Publicado hace 5 años Pagado a la entrega
Cerrado Pagado a la entrega

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]

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.

Extracción de datos Excel Extracción de datos web

Nº del proyecto: #17122565

Sobre el proyecto

31 propuestas Proyecto remoto Activo hace 5 años

31 freelancers están ofertando un promedio de $164 por este trabajo

jaylancer43

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 Más

$250 USD en 2 días
(758 comentarios)
8.6
schoudhary1553

Hello, I can help with you in your project Export data from Zillow into Excel Spreadsheet and filter with other data. I have more than 5 years of experience in Data Mining, Excel, Web Scraping. We have worked on sev Más

$250 USD en 3 días
(340 comentarios)
8.0
Dhruvika111

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 Más

$88 USD en 2 días
(371 comentarios)
8.0
deepbluetech

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 en 4 días
(173 comentarios)
7.4
SigmaVisual

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. Más

$200 USD en 3 días
(58 comentarios)
6.9
katilinas

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 Más

$177 USD en 3 días
(116 comentarios)
6.5
archanaoswal

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 Más

$250 USD en 3 días
(79 comentarios)
5.7
TypingNOW

Hi, I am an experienced web scraper. I can scrape data from Zillow using the provided input. Kindly reply so that I can send you the sample. Looking forward!

$244 USD en 5 días
(14 comentarios)
4.5
Nada100200

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 Más

$100 USD en 3 días
(12 comentarios)
4.8
hamzaisb

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 en 3 días
(2 comentarios)
4.0
caprateekr

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 en 3 días
(14 comentarios)
3.8
RAZAQ786

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 Más

$250 USD en 7 días
(1 comentario)
3.2
youssefelhady

Hello sir, I am very experienced in python and web scraping using selenium. I am going to read all the data fields you listed, examine if there are additional ones that can be extracted. I will then export the data t Más

$155 USD en 3 días
(4 comentarios)
3.1
markann0802

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 Más

$200 USD en 3 días
(0 comentarios)
0.0
rakeshshingala

Hi, I want to work on this project. Let's have discussed on chat. Thanks & Regards Rakesh Shingala Fortune Technology India

$155 USD en 3 días
(0 comentarios)
0.0
sheikh13041

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

$200 USD en 10 días
(0 comentarios)
0.0
anggaadit18

I have experience with data entry jobs

$30 USD en 3 días
(0 comentarios)
0.0
mukeshgarg1992

Hello Sir/M'dam If you are looking for someone who can work on Excel Spreadsheet then you must go with a Chartered Accountant like me who has been working on spreadsheet from last years and good in excel as well wi Más

$155 USD en 3 días
(0 comentarios)
0.0
elab1te

I will work exclusively on the project when chosen

$155 USD en 3 días
(0 comentarios)
0.0
archanacheella18

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 Más

$155 USD en 3 días
(0 comentarios)
0.0