Using Excel to retrieve data fromm web site which requires search parameters

%3CLINGO-SUB%20id%3D%22lingo-sub-2001427%22%20slang%3D%22en-US%22%3EUsing%20Excel%20to%20retrieve%20data%20fromm%20web%20site%20which%20requires%20search%20parameters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2001427%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%20-%20I%20am%20a%20real%20estate%20appraiser.%20Everyday%20I%20use%20an%20industry%20aggregation%20web%20site%20which%20provides%20information%20on%20real%20estate%20sales%20and%20other%20statistics.%20Usually%20I%20go%20to%20the%20web%20page%20for%20the%20site%2C%20enter%20a%20bunch%20of%20search%20parameters%20and%20get%20a%20resulting%20page.%20I%20know%20how%20to%20copy%20a%20URL%20and%20use%20that%20as%20a%20source%20for%20an%20excel%20spreadsheet.%20What%20I'm%20trying%20to%20develop%20is%20a%20way%20to%20use%20excel%20as%20a%20sort%20of%20API%20that%20allows%20me%20to%20enter%20the%20search%20parameters%20while%20connected%20to%20the%20wen%20site%20and%20then%20pull%20the%20resulting%20data%20back%20into%20a%20spreadsheet.%20I%20have%20attached%20a%20jpg%20of%20a%20portion%20of%20the%20search%20mask%20to%20give%20some%20idea%20of%20the%20parameters%20that%20are%20required%2Fallowed.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2001427%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi all - I am a real estate appraiser. Everyday I use an industry aggregation web site which provides information on real estate sales and other statistics. Usually I go to the web page for the site, enter a bunch of search parameters and get a resulting page. I know how to copy a URL and use that as a source for an excel spreadsheet. What I'm trying to develop is a way to use excel as a sort of API that allows me to enter the search parameters while connected to the wen site and then pull the resulting data back into a spreadsheet. I have attached a jpg of a portion of the search mask to give some idea of the parameters that are required/allowed.  

1 Reply

@HTXAppraiser Which web-site would that be? Perhaps you can connect to it via "Get&Transform Data" (a.k.a. Power Query).