The site table on the Data page lists every site in your data version. Use it to browse, search, sort and filter your sites, add or remove sites and fields, and open any site for editing. This guide covers everything you can do with the table.

How the table is laid out

Columns are grouped under three headings:

• Key identifiers - Site name and Fascia.

• Location - the address. Click the arrow next to Location to show more columns, such as how each site was located and how confident the match is.

• Other fields - any other columns from your upload, such as size or revenue.

On the left, a tick box selects each row and the pencil icon opens the site for editing. On the right, the Sources column shows where each site's data came from.

Sites that still need a location or identifier are highlighted and listed at the top of the table.

Search, sort and filter

• Search - click the magnifying glass at the top right and type in Search all columns to find sites by any value, e.g. a town or postcode.

• Sort - click a column heading to sort ascending, again for descending, and a third time to remove the sort.

• Filter - click the filter icon in a column heading. Columns with a short list of values, such as Fascia, show tick boxes you can search. Other columns let you add up to 10 conditions combined with AND / OR, with a Reset button.

When a search or filter is active, click Clear all filters to show every site again. Filters only change what you see in the table - to choose which sites go into your analysis, create a subset on the Subsets page.

Add, edit and delete sites

• Add a site - click Add new site. The site editor opens so you can enter its name, fascia and location.

• Edit a site - click the pencil icon on its row. Values can't be typed directly into the table; see how to edit a site's details and location.

• Delete sites - tick one or more rows, then click Delete selected and confirm. Tick the box in the header to select every site that matches your current filters.

Add or delete fields

Click the ⋯ button next to Other fields (scroll right to find it):

• Add a field - type a field name and click Add. The new column appears under Other fields.

• Delete fields - tick the fields to remove and click Delete selected.

Only Other fields can be added or deleted. Site name, fascia and location fields are always kept.

Rearrange columns

Drag a column heading left or right to move it. The tick-box and pencil columns stay fixed on the left, and Sources stays on the right.

Save your changes

Changes to sites and fields aren't saved until you save the data version. Click the Save progress icon at the top right and choose Update current version or Save as new version. If you try to leave with unsaved changes, Sloc warns you first.

Pro tips

• The table shows up to 500 rows per page; use the arrows at the bottom to move between pages.

• Filter by Fascia, then tick the header box, to select every site of one brand at once.

• Use Save as new version before large deletions, so you can always go back.