Access GeoNames in Excel

Data results output in Excel

Purpose

The GeoNames geographical database covers all countries and contains over eleven million searchable placenames.

Search Mode - Determines how you want to match locations against your query. Available modes:

  • Default
  • Exact
  • Starts With
  • Fuzzy

Country Code - Allows you to filter the results to a specific country.

Order by - Sort results by one of the following options:

  • Relevance
  • Population
  • Elevation

Access

Add from Manager

The GeoNames Connector is available in the Connectors Manager in the top ribbon:
Manager position in main ribbon

Head over to the GEO Category and install GeoNames:
Connector category in Manager window

To use the Connector you need a GeoNames account.

  1. Register a new account.

  2. Your registered username is used as the username input in SeoTools:Paste credentials in Excel

Contribute

This connector suite is open-sourced on GitHub.

See

Official Documentation

Related Functions

Resources

Get help with this function in the community →