Input Real Estate Data into Excel

D

Doug6388

I am using Excel 2002 and trying to extract data from realtor.com into
an Excel spreadsheet using
Data > Import external data > New Web query > enter

This gives me a MS IE browser view, where I paste the web url and
click GO
This gives me a selection of fields to extract ( I pick 3) and click
INPUT

It is here that excel fails me. I want to define fields such as MLS
#, price, bedrooms, date built and address in my spreadsheet and have
the fields filled when I visit each listing page. Any suggestions on
how to populate these fields and/or an excel example already built
that I could play with? I am prepared to name my first borne grandson
in your honour if you can provide this solution. Doug
 
D

Don Guillett

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
I'll look tomorrow
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top