All topicsFeatures & help

Getting started

Using the app

Settings › Security

Settings › Defaults

Settings › Data

What does this mean?

Spreadsheet import

Kept a log before Notchcount? Import it. The import reads your spreadsheet, guesses which column is which, and asks only about what it cannot tell, all before anything is saved.

The file is read on this device, and each entry is encrypted before it is sent, like one you typed. For 30 days afterward you can take the whole import back. Delete all encounters ends that early, because it deletes the record of the import too.

Start an import

  1. Open Settings, then Data.
  2. Click 📊 Import a spreadsheet. Tap 📊 Import a spreadsheet.
  3. Import a spreadsheet opens on its first of four steps. Click ← at the top to go back a step, or from the first step back to Settings. Import a spreadsheet opens on its first of four steps. Tap ← at the top to go back a step, or from the first step back to Settings.

Choose your file

  1. Under Spreadsheet file (.xlsx, .csv or .tsv), choose your file. Numbers and Google Sheets can both save a copy in one of those formats.
  2. The card under it shows what was found in the file, the sheet, the row the headers are on and how many entries. For a file with several sheets, pick one under Sheet, and tick any others with the same columns to import them together.
  3. Tick the boxes that describe your log, such as Comments carry onto the next row. or Week headings and totals are skipped. Each one says how many rows it changes.
  4. Click Next: match the columns. Tap Next: match the columns.

Match the columns

  1. Each column of your file is listed with a few of its values and the field it goes into. Pick another field to change it, or Skip or Add to notes. Any field can take a column, the activity fields included.
  2. A field marked Guess is outlined in teal and can be changed. One marked Needs an answer is outlined in amber and must be set before you can go on. Anything not matched to a field is added to the notes, so nothing is lost.
  3. Under Costs are in, say what currency the amounts are in, with One currency for every row, From the Currency column, Varies by venue or Varies by location. Written in thousands is ticked for you when a currency’s amounts look far too small to be real, as when your log writes 300 for 300,000. Tick or untick it if that guess is wrong. A currency sign or code inside a cell always wins for that cell.
  4. If some dates could be read two ways, pick the order under Dates are written.
  5. Rows that name two people, like Ava + Zoe, become one entry for each, with the cost shared. Pick Keep as one entry to leave them whole.
  6. If nothing in the file names a place, Where were these? asks for the place of each trip. Left empty, those entries keep no location and use your home currency.
  7. Click Next: check the values. Tap Next: check the values.

Check the values

  1. A column with set answers, such as a rating or a yes or no, lists each different answer once, with how many rows use it. Pick what each one means.
  2. A guess is outlined in teal, and one outlined in amber must be set. Rating words are guessed as stars, so a higher word gets more stars.
  3. Click Next: review. Tap Next: review.

Review and import

  1. Review counts the New entries and what will be skipped.
  2. Already in the app lists rows with the same date and name as an entry you have. Ticked rows are skipped.
  3. Met before lists rows logged as a first time when there is an earlier visit with the same person. Ticked ones become repeats and give up their Count.
  4. Rows with problems lists cells that could not be read, and says what happens to each one.
  5. Every first-time entry is numbered again by date, the imported ones and yours together. The review says how the numbers of your own entries change.
  6. Click Import with the number, such as Import 120 entries. Keep the page open until Spreadsheet import shows the result, then click Done. Tap Import with the number, such as Import 120 entries. Keep the page open until Spreadsheet import shows the result, then tap Done.
  7. The import needs a connection. If changes are still waiting to upload, it says Wait until everything has uploaded, then try again.

Take an import back

  1. For 30 days after an import, Settings, Data offers ↩️ Remove the last import, with how many entries it holds and until when.
  2. Click it. Remove the last import? says how many entries it deletes, and how many of those you have edited since. Tap it. Remove the last import? says how many entries it deletes, and how many of those you have edited since.
  3. Type the number where it says Type the number to confirm, then click Remove with the number, such as Remove 120 entries. This cannot be undone. Type the number where it says Type the number to confirm, then tap Remove with the number, such as Remove 120 entries. This cannot be undone.
  4. Entries it marked as repeats become first times again, and every first-time entry is numbered by date again.
  5. If an import or a removal stopped partway, the same place says The last spreadsheet import may not have finished. Click Remove it to take back what was saved. If an import or a removal stopped partway, the same place says The last spreadsheet import may not have finished. Tap Remove it to take back what was saved.