Free Merge Files
Add reference data columns quickly
Merge files are Omniscope files containing columns of useful data you can quickly add to your own files using the Merge Data wizard.
Geographic coordinate merge files:
Add data columns such as the latitudes and longitudes of capital or major cities or the geographic centres of countries to your files automatically using our By Countries, By Cities or By Post Codes merge files. Once merged into your data sets, these addtional columns of geographic coordinates will allow your records to be plotted automaticaly in the Map View, using either embedded vector maps (that work offline) or online mapping services such as Google Maps.
Below we offer a free library of Omniscope IOK format merge files containing decimal latitudes and longitude coordinates as well as other useful reference data. If you are a data publisher and would like to make files available (either free or by licensed download) for use as merge files in IOK format, please contact us.
Map Coordinates by ISO Country Codes (with capital cities):
(click for larger image) |  By ISO Codes Countries Merge file (IOK) 46 KB
Use this free merge file to import decimal map coordinates if your data includes ISO 2 or 3-letter, or numeric, codes. This file also includes official ISO spellings of Country Names and Capital cities in English. You can import coordinates of capital cities or the geographic centre of the countries, or both. |
Note: the flag images cannot be merged in with the data. Instead, you must download the flag images from the image catalogue, export the flag images to a folder, then associate the images with your file using the ISO 2-letter codes you can import from this file.
Map Coordinates by major cities and countries:
(click for larger image)
| By Cities Merge file (IOK) 1.0 MB Use this free merge file to add decimal coordinates of about 57,000 cities based on the city (and ideally also the country) names in your file. There are some duplicate city names, so either you must specify the country name/ISO code columns as additional join/merge criteria, or filter the file to remove countries and duplicate cities not in your file. Instructions and links to further help are contained in the file. |
Map Coordinates by Post Codes:
These Omniscope merge files contain columns of geographic coordinates (decimal longitudes and latitudes) keyed to post codes. If your data sets include a column of postal codes, you can use these IOK files to add geographic coordinates to your files.
Note: for some countries, using Google Maps you can plot a column also containing text other than postal codes, like a full address...for more information on plotting without using existing or merged-in coordinates in your file, see KnowledgeBase sections on working with Google Maps and Google Earth.
GB Map Coordinates by Post Codes
(click for larger image) | GB Post Codes Merge File (IOK) 0.1 MB Use this free merge file to add decimal longitude and latitude columns corresponding to the centres of British 4-character Post Codes, plus 6-digit British Ordinance Survey coordinates, to your files. This file can also be used to add Post Codes to files containing Ordinance Survey coordinates. Instructions and links to further help are contained in the file. |
US Map Coordinates by Zip Codes
(click for larger image)
| US Zip Codes Merge File (IOK) 0.9 MB Use this free merge file to add decimal longitude and latitude columns corresponding to the centres of 42,192 5-digit Zip Code districts, including those located outside the 50 States. Contains two formats, 5 digits of zero-padded text, and unpadded integer numbers (up to 5 places). Instructions and links to further help are contained in the file. |
Other Countries- Add Map Coordinates by Zip/Postal Codes:
Use the above free merge files to add map coordinates based on post code fields (columns) in your data. Other country files are available... if you need another country, please contact us. For a list of available Maps, see our Maps Library. A tutorial on Placing Markers manually to fill-in missing coordinate values and other map-related user information is available in our KnowledgeBase Maps & Coordinates section. See also the complete documentation for the Merge Data wizard .
