Community of VE/MapPoint Users and Developers
This is a discussion on Exporting places inside a selection to Excel within the MapPoint 2006/2009 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 ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| |||
| Exporting places inside a selection to Excel |
| |||
| 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. |
| |||
|
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 |
![]() |
| Tags |
| excel, exporting, inside, places, selection |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Exporting the "show or hide places" | jhoffend | MapPoint 2006/2009 Discussion | 5 | 09-20-2007 01:43 PM |
| Exporting to Excel | getgo | MapPoint 2006/2009 Discussion | 1 | 06-06-2006 03:07 PM |
| Exporting to Excel | bakibbe | MapPoint 2006/2009 Discussion | 2 | 09-07-2005 08:15 AM |
| Exporting territory info to excel | Anonymous | MapPoint 2006/2009 Discussion | 0 | 11-06-2002 06:16 PM |
| Exporting data to Excel | Anonymous | MapPoint 2006/2009 Discussion | 0 | 08-28-2002 03:57 PM |