PDA

View Full Version : Exporting Pushpins from MapPoint to Excel



Winwaed
05-31-2010, 04:59 PM
MapPoint has an "Export to Excel" option which can export the pushpins contained by a shape, to Excel.

The next version of MPSuperShape has a similar option but it can work on multiple selected shapes at once. This is much quicker to use if you want to export all pushpins contained by numerous shapes. Individual shapes have their pushpins exported to separate worksheets in a new workbook. Of course a pushpin that is contained by multiple shapes will be written to multiple worksheets corresponding to these shapes. All data fields are written for each pushpin that is written.

Is anyone interested in testing this new option?

Richard

ipt
06-30-2010, 12:46 PM
Hi, Richard!

I'm Interested to test your new and seems interesting improuvement...

Winwaed
07-01-2010, 07:49 AM
Thanks for your interest. It has since been released, see here:

MPSuperShape: Home Page (http://www.mpsupershape.com/)

There's a free 14 day trial. Cost is US$75 to unlock it beyond that period.


Richard

SteveH
07-21-2010, 07:34 AM
Hi Winwaed.

This is good thanks I will try this soon. One thing I would like to do is to create multiple radius rings arround known locations, then export items contained within the multiple ring as discribed. Then use an identifier to find which ring they relate to.

Is there a quick way to produce say 800 radius rings, and will the export show which these relate to?

Thanks
Steve

Eric Frost
07-21-2010, 09:33 AM
I would normally use something like MapInfo Professional to do this, it's about $2,000 software. There are cheaper GIS packages like Caliper and Manifold that should accomplish the same thing easily.

MPSuperShape should help get the data into and out of MapPoint.

Eric