PDA

View Full Version : Export Zip Codes To Excel



JimS
01-14-2006, 09:06 AM
Export Zip Codes to Excel. I am new to MapPoint and looking for the easiest way to export Zip Codes to Excel. I've tried creating a territory with a radius circle around a city, adding the Zip Codes to the territory and exporting, but the export button is greyed out. What am I doing wrong.

Thanks

Jim S

JimS
01-18-2006, 08:55 AM
I figured it out. Thanks for allowing me to post the question.

Jim S

Wilfried
01-19-2006, 01:59 PM
Hi Jim,

Glad it works for you. Can you give some explanation on how and what? This will then benefit other users :)

I.T.
01-22-2006, 08:24 AM
I am not familiar with Zip Codes but would imagine it is very similar to the following method for exporting Postcodes (UK) to Excel...

Open New MapPoint Map and Click Data>Data Mapping Wizard (Ctrl + W)
Leave at default of "Shaded Area" then <Next>
Leave at default of "Add Demographics to Map" then <Next>
Select any of the options (eg Area_sq_km) (will be deleted later anyway)

In the lower part of the dialog select the level of info you want
For the UK this breaks down as:-
Postcode Area (eg "G" for Glasgow)
Postcode District (eg "G2" for Glasgow City Centre)
Postcode Sector (eg "G2 4" for Charing Cross, Glasgow City Centre)

Then click on finish and MaPoint will map your selected data to the selected detail level. Once mapping has finished use the drawing tools to draw a line (or circle, rectangle, freeform etc) around the area you want to export (rectangle can be done by left click and dragging on the map).

You can now export the data to Excel (Data>Export to Excel) and it will open as a new workbook. Delete the columns with the Demograpic Data and Country/Region - you are then left with a list of the Postcode Sectors.

There is no way the full Postcode / Zip Codes information could be exported as they would run into hundreds of thousands. With the UK there are 9145 Postcode Sectors alone and each of these has a potential 676 further variations.

Hope this helps :-)

I.T.

JimS
01-24-2006, 01:46 PM
The following worked for me:
1) Open MapPoint
2) Open the Drawing Toolbar - go to View\Toolbar\Drawing
3) Click on the radius circle and click on a city on the map.
4) Expand the radius to the desired distance.
5) Click Data\Territories\Create Manually. Click Next.
6) Select Zip Code and click Next.
7) Click Finish.
8) Within the radius circle select Zip Codes needed and add them to the
territory.
9) When they are all added, select the box from the Navigation toolbar.
10)Draw a box around the outside of the radius circle. It doesn't matter
how big the box is as long as it covers the entire circle and all Zip
Codes that have been selected.
11)Click Data\Export to Excel. A spreadsheet is created called Custom
Territories. Click on it, save and rename it as needed.