Exporting to Excel

You can export any collection as an Excel workbook from its page in your dashboard, in one click. Exporting changes nothing on your account: the file is a copy, and you can export again whenever the collection changes.

The workbook has three sheets:

  1. the table, as you see it;
  2. every claim behind the table, with its source;
  3. a description of the collection and its columns.

Sheet 1: the table as you see it

The first sheet matches your screen at the moment you export: the columns you have showing, in your order, and the rows your filter and sort have kept. Hide a column and it is left out; filter to twelve rows and the sheet has twelve.

Values are written as text, exactly as they were recorded. "About 40" stays "about 40", and an identifier with a leading zero keeps it. If you need numbers, convert the column after you open the file.

Sheet 2: every claim, with its source

A cell in the dashboard's table shows one value, but it holds every claim ever made about it. This sheet lists them all, one row per claim per source, with:

  • the entity and attribute it belongs to;
  • when it was recorded, and by which assistant or from which imported file;
  • whether it is the claim the table shows, one that was superseded, or one that was retracted, with who retracted it and why;
  • for a web page that has been checked, the verdict: supports, partly supports, does not support, or could not be reached, with the confidence and the passage the verdict is based on.

Retracted claims are included because nothing is ever removed from the record. Sort by the verdict column to bring the claims worth a second look to the top.

Sheet 3: what the columns mean

The third sheet has the collection's description, when it was made and who has written into it. Below that is one line per attribute, with the guidance for what belongs in the column and the resolution rule that decides which claim wins when two disagree. Any notes assistants left on the collection come last.

This sheet helps anyone who opens the file later understand the data. For example, whether a Headcount column counts full-time staff only.

Importing an export

You can save the first sheet as a CSV and import it again, into the same collection or another. Each value becomes a new claim with the file as its source, added beside the original claim rather than replacing it.