.

Excel as a TomTom POI - Points Of Interest (ov2) file editor / converter

As i use Tom Tom GPS a lot, i thought it was time to scratch an itch and have Excel as an editor program for different types of POI files.
There are of course enough online solutions and a series of installable Windows programs, but as a lot of Office workers are blocked by an internet firewall and also do not have the permission to install a third party program on their PC's this is not an ideal solution.

Therefor a 'simple' local Excel workbook with 'macro's' could then be a solution to do some quick editing and exporting to manage these specific POI files.
As the TomTom POI files (ov2) are encoded in a binary format, you cannot simply use Notepad for this task. Even file formats like XML are not easily processed using Excel.

This VBA - Workbook is tested in Excel 2007, 2010, 2013 and 2016 32Bit (still testing for 64Bit) Windows 7/8.1/10 English version.

It supports importing and exporting KML, ov2 files. Importing only your 'Mydrive' export file, exporting only CSV for Garmin and GPX formatted files.

Bugs solved in version 4.41: still in development

Bugs solved in version 4.40:

Bugs solved & new functionalities in version 4.30:

Bugs solved & new functionalities in version 4.20:

Bugs solved in version 4.11:

Added capabilities in version 4.00:

Capabilities of version 3.00:

Possible developments in the future, if time permits ...

The download of this Ms Excel 2007, 2010, 2013, 2016 xlsm file is available here: Download
This solution is contained in a ZIP compressed archive.

Screen shots:

If you open this Excel Workbook tool for the first time, you'll see this screen.

It's displaying the security message that pop's up every time you open up an Excel Workbook containing 'Macro's'

If you click on 'Enable Content', you'll have the possibility to add this Workbook to the list of Trusted documents.

After this step the POI editor will be working normally, and will open normally as in the next screen.

This is needed to use all the buttons and functionality of this file.

The empty Excel POI editor Workbook is opened normally (if Macro's/ VBA are activated)

There is one empty "Locations" sheet available where the imported locations are inserted or where you can manually insert or copy/paste your location data.

If you import an ov2 file from your TomTom GPS, the results are appended in the current Excel table. The loaded location records are ADDED below existing locations.

Importing is supported from:

  • TomTom ov2 files
  • TomTom MyDrive Export
  • Google KML Files (Not KMZ files)

The format is Longitude, Latitude, Description

In the description you can further specify a telephone number by using the '>' separator inside the description.

You can also use the 'Add Telephone Suffix' button on the selected row.

Exporting is supported for the following formats:

  • OV2 for TomTom GPS
  • CSV Text file for Garmin GPS systems and other compatible systems.
  • KML Text file for interaction with Google Maps
  • GPX format for Garmin GPS systems and others.

MyDrive data is available after you log in om the TomTom site

  • Go to the settings (gear/cog icon on the bottom)
  • Select MyDrive tab on top
  • Click on "Download your MyDrive data"
  • This will start the download of your MyDrive data, containing your Favorite locations you have created.

    A double click on a row cell will open your favorite browser on Google maps and it will pinpoint the exact location of your Point of interest. (POI)

    You can also use the button: Show Selected Row in Google Maps.

    The type of map that is opening is defined by the choice in the Excel Ribbon:

    • Normal (Google Maps)
    • Earth (Google Street view)

    It's possible to add new Sheets to you Excel Spreadsheet. This sheet can be filled with another import or another set of POI's.

    Each sheet is exported separately to another file.

    Adding, Deleting and Clearing a sheet can is done with the buttons in the Table group on the ribbon.