In Progress

Export Data from Excel to Zillow back to 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.

Export: Zillow Field data to be exported listed below.

Field Example Format

Zillow Property URL [url removed, login to view]

Text

Street Address Text

City Text

State Text

ZIP Text

Zestimate: Number

Rent Zestimate: Number

Est. Mortgage: Number

Beds: Text

Baths: Text

SqFt: Text

Lot: Text

Type: Text

Year Built: Number

Last Sold: Text

Parking: Text

Cooling: Text

Heating: Text

Fireplace 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

--From Charts and Data Table--

Zestimate Value: Number

Zestimate Range (Low): Number

Zestimate Range (High): Number

Zestimate Last Updated: Date

Rent Zestimate: Number

Rent Range (Low): Number

Rent Range (High): Number

Rent Last Updated: Date

--From Price History Table--

Date Date

Description: Text

Price Number

--From More Facts:--

Last remodel year: Date

Notes:

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

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

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

4. 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 ca, value city, park west, open source data entry, mortgage master, in victoria, excel spreadsheet rent, date entry home, data entry open source, backyard remodel, master excel, data entry edinburgh, zillow, victoria, vb excel, trails, table tennis, remodel, playground, parking lot, park street, master bedroom, master data, ln, hiking

About the Employer:
( 1 review ) Long Beach, United States

Project ID: #2453666

Awarded to:

jagjeetjs25

Hi, I am ready to do it very well.

$60 USD in 1 day
(1 Review)
2.4

9 freelancers are bidding on average $89 for this job

Innovative116

Hi. I am interested in the project. Please check my private message for more details. Thank you

$100 USD in 1 day
(59 Reviews)
6.7
mantislin

Hi sir, please check PM, thx Kimi.

$100 USD in 2 days
(76 Reviews)
6.2
hossionsumon

Hello sir,Expert's team here of Export Data from Excel.Check pm.plz

$90 USD in 1 day
(63 Reviews)
6.1
Kamalkishover

We have done similar project, Pls Check PM

$100 USD in 2 days
(116 Reviews)
6.0
lisaspools

I have over 25 years experience with excel spread sheets and a great work ethic. I am confident you will be pleased with the results of my work. Thank you for considering me for this project.

$180 USD in 8 days
(1 Review)
3.2
ranawaqarlx

I can get all require data in csv. "Sample Attached" more details sent to you, thank you

$80 USD in 6 days
(5 Reviews)
3.1
randomnut

I'm confident I'll be able to complete this project.

$50 USD in 3 days
(2 Reviews)
1.6
hardikdusara

Hello Project Owner, I can accomplish your project as per your requirement. So your trust on me makes the project more early than I specifies...Hopping for positive response.

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

Hi, Ready to start your work. Eagerly awaiting for your positive reply. Please check your inbox for futher details. Thanks, Shaik.

$99 USD in 6 days
(1 Review)
0.0
tommmy1

ready to start here..

$35 USD in 2 days
(0 Reviews)
0.0