Spreadsheet-Coordinate Tool

Please open a spreadsheet to begin using tool.

Gazetteer Search

KML Export Settings

Please designate the relevant columns in your spreadsheet starting with 0 (ie: the first column is 0, the second is 1, etc)

placename latitude longitude description Export table as extended data (required to include extra columns) Export in Journey format*

* Places must be in order without date overlaps.

KML Export Settings

Designate the start and end date columns in your spreadsheet using a zero-based index (ie Column A is 0, Column B is 1, etc)

start date end date Fill in empty dates

Spreadsheet Loader

Click the map to copy coordinates to your clipboard.
When loading CSV the 1st row will be headings. The 2nd and 3rd column will be latitude and longitude. Or you can add columns later by right clicking.

j-excel spreadsheet help

Assumptions

Column 1 is placename, 2 is latitude, 3 is longitude.

Uploaded CSV has column headers as first line.

Basic Usage

Click any cell in the row you wish to edit.

Click the map to enter mouse coordinates into spreadsheet.

Press ENTER to make a new row. Press TAB to make a new column.

If you add a date column use negative values for BC dates (eg: 10,000BC is -10000).

Toolbar

Undo:

or Ctrl+Z

Redo:

or Ctrl+Y

Save:

Save to disk (as csv)

Export:

Save to disk (as kml)

Date:

Add Date column

Help:

Show help (this popup!)

Delete:

Delete sheet (won't affect local files)

Spreadsheet

Functions similarly to other software, such as Microsoft Excel.

Left click to select cell, click row/column header to select that row/column.

Left click and drag to select specific cells.

Double left click a cell to manually edit the contents

Right click to display a context menu (for functions such as delete row, copy, etc).

For more detailed help, see the Help section.