Spreadsheet-Coordinate Tool

Please open a spreadsheet to begin using tool.

Gazetteer Search

KML Export Settings

Indicate which column has the relevant information, starting with 0 (ie: the first column is 0, the second is 1, etc):

Title Latitude Longitude Description Start date End date

Export all columns as extended data
Fill in empty dates with estimates
Export as a journey*

* Places must be in order without date overlaps.

Date Settings

Add columns for well formatted start and end dates, with calendar picker.

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 title (or place name), 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.