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 6 of 6

Export of Pushpin Data to Excel

This is a discussion on Export of Pushpin Data to Excel within the MapPoint Desktop Discussion forums, part of the Map Forums category; I need to find out how to export the push pin Information data into a an Excel spreadsheet where each ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    Export of Pushpin Data to Excel

    I need to find out how to export the push pin Information data into a an Excel spreadsheet where each line item of the push pin Information box appears as a column in the spreadsheet. I know this can be done since I have one map in which this is being accomplished already. However I am creating a new map and when I attempt this it puts all of the info into 1 column. FYI- I am currently running Map Point 2002nwith the WIN_XP platform.

  2. #2
    John Meyer's Avatar
    John Meyer is offline Senior Member Blue Belt
    Join Date
    Jul 2002
    Posts
    478
    If it is only one map that is doing that maybe the map is corrupt? How are you exporting to excel? How may pushpins/datasets are on the map? What have you tried so far (what have you ruled out?

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    Import

    When I place a push pin I create a data set such as pin shape' color, and data set name. I then create an elipse of the area of pushpins I want to create a spreadsheet on. Right click, export to Excel.and the spreadsheet is created. The typical format I use for the push pin is: Name in name area. Lat:#####/Lon:#### in the information area. What I am trying to do is set a column for the lat & lon.

  4. #4
    KasiaP is offline Junior Member White Belt
    Join Date
    Jun 2008
    Posts
    2

    Question Re: Export of Pushpin Data to Excel

    Hi,
    Have a quick question, on the mappoint I've added pushpin, and then added them as a stop. Question is how I can make export to excel together with those numbers of stops?
    Can someone help me with this??
    PLEASE

  5. #5
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60

    Re: Export of Pushpin Data to Excel

    I'm not quite sure what you mean.
    MapPoint itself can export pushpins to Excel by using the "Export to Excel" option. Select the pins and then right click. "Export to Excel" is on the menu.

    John Meyer's Pushpin Tool (available from this site or mine) will export pushpins with some additional information such as longitude, latitude coordinates.

    If you have created a route from some pushpins, and wish to export the pushpins in route order, then you need my "RouteWriter" add-in. See http://www.routewriter.com

    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  6. #6
    KasiaP is offline Junior Member White Belt
    Join Date
    Jun 2008
    Posts
    2

    Re: Export of Pushpin Data to Excel

    Thanks, it looks like i need routwriter.

    Thank you for your help!

    Regards
    Kasia

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to export data to excel using C#
    By xortam in forum MapPoint Desktop Discussion
    Replies: 7
    Last Post: 02-15-2012, 09:00 AM
  2. What it is the command to export data in excel format ?
    By Elbarto in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 03-15-2006, 05:38 AM
  3. Export Map Point Data to Excel
    By Anonymous in forum Wish List
    Replies: 0
    Last Post: 12-09-2004, 04:30 PM
  4. how to export the data of an Excel table on a chart mappoint
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 02-17-2004, 05:37 AM
  5. Export pushpin notes to excel
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 06-02-2003, 07:00 AM

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