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

Exporting places inside a selection to Excel

This is a discussion on Exporting places inside a selection to Excel within the MapPoint Desktop Discussion forums, part of the Map Forums category; I want to make a radius circle selection of places that are found using the info tool and export those ...

  1. #1
    Pat Lee is offline Junior Member White Belt
    Join Date
    Jun 2003
    Posts
    1

    Exporting places inside a selection to Excel

    I want to make a radius circle selection of places that are found using the info tool and export those to Excel. Is that possible? I don't seem to be able to do this. I would like to create a list of places like marinas, restaurants and such to visit on my vacation from the places that exist in MapPoint.

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

    Export places inside of selection to Excel - Same question

    I have the same question. How do I export to Excel items which are listed from a "Find Nearby Places" within the radius. I have imported into MapPoint recent house sales and want to export only those within 2.5 miles of an address.

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    I found the solution in the tutorial. You need to select area with a closed shape, such as a radius. (You cannot pull simply using the "Find nearby places" selection). Here is the section copied from Mappoint tutorial.

    Export data to Microsoft Excel
    Open the map from which you want to export data.
    Do one of the following:
    Draw a closed shape (such as a drivetime zone or freeform, rectangle, oval, or radius circle shape) around the data you want to export, and then select the shape by clicking its border.

    On the Navigation toolbar, click Select , and then drag from the upper-left corner to the lower-right corner of the area that includes the data you want to export.

    Select the data set name in the legend.

    On the Data menu, click Export to Excel.
    - or -

    Click Export to Excel .

    Microsoft Excel starts, and the entire data set or any data mapped entirely within the shape you drew is exported and presented in an Excel workbook (see the notes below for more information). The workbook includes a header sheet with the dimensions of the area you selected, the name of each data set that was included, and the total number of records exported from each set.

    Each data set is included on a separate tab of the Excel workbook with the first tab as the header sheet.

    Notes
    You can only export data from one closed shape at a time; that is, any shapes on the map other than the selected closed shape will be ignored.

    Selecting an area or shape at a high altitude could result in unreliable export data. It is possible that the two-dimensional shape will extend beyond the three-dimensional curvature of the Earth that is rendered on the map. To avoid this problem, try the following:

    Select the shape, and on the View menu, point to Zoom, and then click To Selection.

    Use the Select tool to zoom

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Exporting the "show or hide places"
    By jhoffend in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 09-20-2007, 12:43 PM
  2. Exporting to Excel
    By getgo in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 06-06-2006, 02:07 PM
  3. Exporting to Excel
    By bakibbe in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 09-07-2005, 07:15 AM
  4. Exporting territory info to excel
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 11-06-2002, 05:16 PM
  5. Exporting data to Excel
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 08-28-2002, 02:57 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