web query question

TrippyTom

Well-known Member
Joined
Nov 16, 2004
Messages
587
Does anyone know where I can find a free web query that lets me look up zipcodes? I know there can be several zipcodes per city, but any one will do -- I don't do this often, but when I do, it's annoying having to look it up on usps.com and copy/pasting it into my Excel file.
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,357
Office Version
  1. 365
Platform
  1. Windows
Tom

What's the problem with using that site?

Couldn't you use it in a webquery and/or automate IE using VBA?
 

TrippyTom

Well-known Member
Joined
Nov 16, 2004
Messages
587
Perhaps I don't understand how to setup the web query. I tried to follow the instructions in Excel help, but it didn't work with USPS.com. Also, it looks like USPS.com has a web query, but wants to charge for it. That's why I asked if there are free sites to do the same thing.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,357
Office Version
  1. 365
Platform
  1. Windows
Tom

I've just looked at the site, and I can't see charges mentioned anywhere.

I'm assuming your using the Zip Code Lookup page accessed via the Find a Zip Code link.:)
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,357
Office Version
  1. 365
Platform
  1. Windows
Tom

Well I just tried that with ALBUQUERQUE, NM and I wasn't charged or asked to pay anything.

Note I mean I did it manually, not using Excel.

Oh, and I spelt ALBUQUERQUE wrong but it corrected it.:)
 

TrippyTom

Well-known Member
Joined
Nov 16, 2004
Messages
587
Yes, I do it manually whenever I need to plot cities on maps, but how would you utilize this site in a web query in Excel so I don't have to copy/paste all the time?
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,357
Office Version
  1. 365
Platform
  1. Windows
Tom

Did you see where I mentioned automating IE?:)
 

TrippyTom

Well-known Member
Joined
Nov 16, 2004
Messages
587
yes.... ?

I'm clueless what you're getting at, so I've decided to go another route. I was able to extract the zipcode info from my mapping program and convert it to a spreadsheet. I plan on using a vlookup with that data to make my life easier.
 

Forum statistics

Threads
1,181,733
Messages
5,931,726
Members
436,800
Latest member
abowalid98

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top