# Table of places

The **Table of Places** is a global place editor used as a spreadsheet, to help you edit and clean all the places of your genealogy.

[![en-places-table.png](https://docs.ancestris.org/uploads/images/gallery/2021-03/scaled-1680-/en-places-table.png)](https://docs.ancestris.org/uploads/images/gallery/2021-03/en-places-table.png)

## Description

The Table of Places lists all the locations of your genealogy. Each line represents a place, and each column represents a jurisdiction.

If a place is used several times in the genealogy, only one line will appear.

Two columns with the stored coordinates are added after the jurisdictions.

If places have different formats, Ancestris will display as many columns as the place with the largest number of jurisdictions, regardless of the place format defined in the genealogy (Gedcom header). For more details on the format of places, see the [Places section](https://docs.ancestris.org/books/user-guide/page/places "Places").

The list can be **sorted on multiple columns**, by clicking on the header of the column and maintaining Ctrl pressed.

The **columns can be moved** with the mouse by dragging the header.

A filter bar above the table can be used to filter the list for the places you are interested in.

<p class="callout info">Column's order and sizes, as well as sorting criteria and filtered column are memorized for each genealogy.</p>

### <span class="mw-headline" id="bkmrk-barre-de-filtre-0">Filter bar</span>

The filter displays places corresponding to the criteria entered in the filter. This filter includes the following controls:

- The **Filter by** drop-down menu: selects the jurisdiction column on which to filter. The list differs for each Genealogy since the list of jurisdictions is read from the Gedcom header file itself. The choice "\*" filters on all columns at the same time.
- The **input field** is the string criteria to filter places. The filtered places have to contain this string in order to be displayed. Ancestris uses regular expressions to filter, letting you indicate smart filtering.
- The **Filter button** executes the filtering once a string has been entered. The **Enter key** can be used as well.
- The **Clear button** clears the input field which removes the filter and display the full list again.
- The **Place format settings** button can be used to change the place format.
- The **Export button** exports the table to a CSV file.
- The **total number of different places** in the genealogy is displayed to the right of the bar. Please note that the same place used many times in the genealogy would count as one.

## <span class="mw-headline">Usage</span>

<span class="mw-headline">The **Table of Places** can be used to visualize all places, to edit them as you would in a spreadsheet, to search for a place on the Internet and edit it in details, or to export places.</span>

### <span class="mw-headline">Visualization</span>

<span class="mw-headline">The table simply gives a global overview of all your places and let to classify, analyse them, etc. as in a table.</span>

#### Context menu / Show related events

<span class="mw-headline">From each place, you can also identify quickly which individuals and events are association with a place.</span>

<span class="mw-headline">For that, a context menu accessed by right click can show you these related events. Select one to display the corresponding event in the Ancestris editors.</span>

[![en-places-table-popup-event.png](https://docs.ancestris.org/uploads/images/gallery/2021-03/scaled-1680-/en-places-table-popup-event.png)](https://docs.ancestris.org/uploads/images/gallery/2021-03/en-places-table-popup-event.png)

### <span class="mw-headline">Global editing  
</span>

<span class="mw-headline">You can edit places by directly editing the table cells. </span>

<span class="mw-headline">Either directly enter text in the cells, drag-and-drop other cell content or paste some text in cells.</span>

#### Validating changes

When a cell is modified, the OK and Cancel buttons appear at the bottom right corner of the Table Places.

For this, you need to have set your preferences to confirm changes (please refer to Preferences / Edition / Confirm changes for more details).

Press Enter or click OK to confirm changes, or else press Esc key to cancel.

[![en-places-table-ok-cancel.png](https://docs.ancestris.org/uploads/images/gallery/2021-03/scaled-1680-/en-places-table-ok-cancel.png)](https://docs.ancestris.org/uploads/images/gallery/2021-03/en-places-table-ok-cancel.png)

If a change is confirmed, the cells of the Table of Places will be refreshed, potentially changing the order of the lines.

In the editing mode where the modifications are automatically taken into account without confirmation, the simple fact of going to another cell validates the modification made to the previous cell. This displays the table again and is likely to change the order of the rows.

<p class="callout success">For greater efficiency when modifying cells, it is best not to automatically accept changes in the Editing preferences.</p>

#### <span class="mw-headline">Drag-and-Drop</span>

You can drag and drop one cell or several cells at a time. When dropping cells onto other cells, Ancestris will maintain the same cell structure.

For instance, in the image below, we are dragging 4 cells on one column and dropping them on the next column.

<span class="mw-headline">[![en-places-table-drag-drop.png](https://docs.ancestris.org/uploads/images/gallery/2021-03/scaled-1680-/en-places-table-drag-drop.png)](https://docs.ancestris.org/uploads/images/gallery/2021-03/en-places-table-drag-drop.png)</span>

#### Context menu for Cut / Copy / Paste

To copy and Paste cells, select on or several cells and use the context menu to either copy or cut.

In a second step, select the cells where you want to paste the content, right click to display the context menu and paste the cells.

The content will be pasted in the selection in one of two ways:

- If only one cell has been selected for the paste, the whole copied area will be pasted using this selected cell as the top left corner.
- If more than one cell has been selected, two situations can occur: 
    - Either the selected area is smaller than the copied area : in this case, Ancestris will truncate the content to the selected area.
    - Or the selected area is larger than the copied area : in this case, Ancestris will repeat the content throughout the selected area.

[![en-places-table-copy-paste.png](https://docs.ancestris.org/uploads/images/gallery/2021-03/scaled-1680-/en-places-table-copy-paste.png)](https://docs.ancestris.org/uploads/images/gallery/2021-03/en-places-table-copy-paste.png)

### <span class="mw-headline" id="bkmrk-ouverture-de-l%27%C3%A9dite-0">Search and Detailed editing</span>

Double-clicking on a place in any column opens the [Places Editor](https://docs.ancestris.org/books/user-guide/page/places-editor-%28l%29 "Places editor") where you can edit it.

[![en-places-table-popup-edit.png](https://docs.ancestris.org/uploads/images/gallery/2021-03/scaled-1680-/en-places-table-popup-edit.png)](https://docs.ancestris.org/uploads/images/gallery/2021-03/en-places-table-popup-edit.png)

All events that use this place will be modified at the same time.

<p class="callout info">Note: when the Places editor is called from the table of places, it will edit all places of the genealogy that have the same name and coordinates.</p>

If you only want to edit the location of a particular event, use the Cygnus, Aries or Gedcom editor to edit this particular event, and then edit the single place from within the event.

### Set place criteria

If you need to align all places to a given place format, or if you want to rename or change the order of the jurisdictions, you will need to use this tool.

From the context menu or from the toolbar button, the following panel will appear.

[![en-places-table-format-Correct.png](https://docs.ancestris.org/uploads/images/gallery/2021-03/scaled-1680-/en-places-table-format-correct.png)](https://docs.ancestris.org/uploads/images/gallery/2021-03/en-places-table-format-correct.png)

If you change the place format, yo will need to indicate to Ancestris how you convert from the existing format to the new format. Use the Convert button for this.

The following panel will appear. Follow the instructions and press OK.

[![en-places-table-converter.png](https://docs.ancestris.org/uploads/images/gallery/2021-03/scaled-1680-/en-places-table-converter.png)](https://docs.ancestris.org/uploads/images/gallery/2021-03/en-places-table-converter.png)

Once you confirm the transcription of the jurisdictions, yo are taken back to the previous panel. Press "Proceed and set places criteria" to make the change in the genealogy.

The cells of the Table of Places will be refreshed.

### Exporting places

Use the **Export** button to get a file with all the places of the list. The file will be in a TXT or CSV format that can be used in any standard spreadsheet software.

It is also possible to partially export places using the clipboard.

- To do this, select the cells you ant to export, or type Ctrl+A to select all locations
- Ctrl+C to copy them to the clipboard.
- Ctrl+V from a spreadsheet to paste them

## Customization

Apart from memorizing filters and columns, there are no customizable elements in the location table.