Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 5 of 5

Export Zip Codes To Excel

This is a discussion on Export Zip Codes To Excel within the MapPoint Desktop Discussion forums, part of the Map Forums category; Export Zip Codes to Excel. I am new to MapPoint and looking for the easiest way to export Zip Codes ...

  1. #1
    JimS is offline Junior Member White Belt
    Join Date
    Jan 2006
    Posts
    4

    Export Zip Codes To Excel

    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

  2. #2
    JimS is offline Junior Member White Belt
    Join Date
    Jan 2006
    Posts
    4

    Export to Excel

    I figured it out. Thanks for allowing me to post the question.

    Jim S

  3. #3
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433
    Hi Jim,

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

  4. #4
    I.T. is offline Junior Member White Belt
    Join Date
    Mar 2005
    Posts
    9
    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.

  5. #5
    JimS is offline Junior Member White Belt
    Join Date
    Jan 2006
    Posts
    4

    Zip Codes from MapPoint to EXCEL

    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.
    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Importing Zip Codes from Excel to MapPoint
    By Jennl881 in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 02-05-2006, 06:03 AM
  2. Export Zip Codes to Excel Problem
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 11-09-2004, 05:24 PM
  3. Export to excel
    By Dazzer in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 10-23-2003, 05:29 AM
  4. export to excel
    By gsully in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 05-08-2003, 10:39 AM
  5. Find and Export of ZIP Codes
    By Anonymous in forum Wish List
    Replies: 1
    Last Post: 01-16-2003, 07:22 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96