Talk Sheet

User guide

Everything you can do with Talk Sheet

Spreadsheets in your browser that save themselves, work on your phone, and stay private: they're encrypted before they leave your device.

Contents
  1. Getting started
  2. Editing cells
  3. Formulas
  4. Formatting and layout
  5. Tabs
  6. Import and export
  7. Folders, search and trash
  8. Sharing
  9. Version history
  10. Phones and tablets
  11. Keyboard shortcuts
  12. Privacy and encryption
  13. Your password and recovery key

Getting started

Create an account with a username and a password of at least 10 characters. No email address is needed (you can use one as your username, but nothing is ever sent to it). Usernames can't be changed later, and people you share with see yours. Right after, you get a recovery key: save it before you go on.

Your spreadsheets are listed on the home page. Press New spreadsheet (on a phone, New → Spreadsheet) to start one: give it a name, and tick Protect with a password if it should have a password of its own (see Sharing). Click its name at the top to rename it later. There's no save button: every change is saved a moment after you make it, and the top right of the editor shows All changes saved once it's stored.

If you lose your connection, your changes wait and are saved as soon as you're back online. The page warns you if you try to close it before then.

Editing cells

  • Click a cell to select it and just start typing, or double-click (or press Enter or F2) to edit what's there.Enter moves down, Tab moves right, Esc cancels.
  • The bar above the grid shows the selected cell's address and its full contents. Type an address like B12 into the address box to jump there.
  • Drag across cells, or hold Shift while clicking or using the arrow keys, to select a range. Click a row number or column letter to select the whole row or column. Hold Ctrl (⌘ on a Mac) to add more ranges.
  • Copy, cut and paste work as usual, also to and from other spreadsheet apps. Pasting from Google Sheets keeps its colors and bold or italic text.
  • Drag the small square at the corner of a selection (the fill handle) to continue a series like 1, 2, 3, dates or Item 1, Item 2, or to copy a formula down a column.
  • Undo and redo with the arrows in the toolbar, or Ctrl+Z and Ctrl+Shift+Z.

Formulas

Start a cell with = to calculate: =A1+B1, =SUM(B2:B20) or =IF(C2>100, "High", "OK"). Results update as soon as the cells they use change.

  • While typing a formula, click a cell to insert its address, or drag to insert a range. The cells a formula uses are outlined in color.
  • Point to another tab with its name: =Budget!B4, or ='Monthly costs'!A1:A12 when the name has spaces.
  • About 60 functions are built in, including SUM, AVERAGE, MIN, MAX, COUNT, COUNTIF, SUMIF, ROUND, IF, IFERROR, AND, OR, CONCATENATE, TEXTJOIN, LEFT, RIGHT, MID, SUBSTITUTE, VLOOKUP, HLOOKUP, MATCH and INDEX.
  • A cell with a red corner has an error, like #DIV/0!. Point at it to see why.

Formatting and layout

  • The toolbar makes text bold or italic, sets the text and fill colors, and aligns text left, center or right.
  • Right-click a cell (or use Rows & columns in the toolbar) to insert or delete rows and columns.
  • Drag the line between two column letters or row numbers to resize; double-click it to fit the column to its contents.
  • Sort A→Z or Z→A by the selected column from the toolbar.
  • Zoom in and out with the buttons next to the toolbar, or pinch on a touch screen.

Tabs

A spreadsheet can have up to 200 tabs, shown along the bottom. Press + to add one. Double-click a tab to rename it, drag it to reorder, or open its menu to move or delete it. Renaming a tab updates the formulas that point to it.

Import and export

  • Import on the home page turns CSV or Excel (.xlsx) files into new spreadsheets, up to 20 files at a time and 10 MB each. Each Excel worksheet becomes a tab, with its formulas and colors.
  • In the editor, File → Import adds a file as new tabs or replaces the current tab.
  • File → Download as CSV saves the current tab; Download as Excel saves the whole spreadsheet with its formulas and formatting.
  • Make a copy in a spreadsheet's menu on the home page duplicates it.

Folders, search and trash

  • Make folders (and folders inside folders) with New folder, then drag spreadsheets onto them or use Move to folder in a spreadsheet's menu.
  • The search box at the top finds spreadsheets by name in every folder.
  • Move to trash keeps a spreadsheet in the Trash for 30 days, where you can restore it; after that it's deleted for good. You can also empty the trash yourself.

Sharing

Press Share in the editor to make a link, then send it to people:

  • Can view links open a read-only copy, no account needed.
  • Can edit links ask people to log in or sign up; the spreadsheet then appears under Shared with me for them, and they can change it like you can.
  • Revoke a link to stop access through it. People who joined through an edit link lose access too.

Always send the whole link. Its last part, after the #, is the key that unlocks the spreadsheet, so treat a link like a house key: anyone who has it can open the spreadsheet.

File → Password… gives a spreadsheet a password of its own, and encrypts it with that password too. After that, being logged in isn't enough: everyone who opens it, you included, editors and people with a link, enters the password every time they open it: refreshing the page or leaving the spreadsheet asks again. Links you share no longer carry its key, so send the password separately. If you forget it, your recovery key opens your own spreadsheet (choose Forgot it? Use your recovery key); without either, it can never be opened again. Changing or removing the password asks for the current one (or your recovery key) first, even while the spreadsheet is open. Removing it gives everyone with access their key back.

Choose a long password: a few unrelated words, like velvet-ostrich-quarry-lantern, beat a short jumble of symbols. Anyone with a copy of the data can try guesses against it.

Version history

File → Version history shows earlier versions of each tab: a copy is kept every few minutes while you work, before large deletions, before a restore, and when a tab is deleted. Pick one to preview it, then press Restore this version. The current contents are kept as a version too, so a restore can be undone. Up to 10 versions per tab are kept for 30 days.

Phones and tablets

  • Tap a cell to select it; type in the bar at the bottom of the screen.
  • Press and hold a cell for copy, paste and delete.
  • Drag the round handles of a selection to resize a column or row.
  • File → Add to home screen puts an icon for one spreadsheet on your home screen, like an app.

Keyboard shortcuts

In the editor, press Ctrl+/ (⌘+/ on a Mac) for a searchable list. On a Mac, use ⌘ where it says Ctrl.

Navigation

Move one cell
↑ ↓ ← →
Jump to the edge of the data
Ctrl+↑ ↓ ← →
Move right / left
Tab or Shift+Tab
Move up
Shift+Enter
Start of the row
Home
Last value in the row
End
First cell of the sheet
Ctrl+Home
Last cell with data
Ctrl+End
Page down / up
Page Down or Page Up

Selection

Extend the selection
Shift+↑ ↓ ← →
Extend to the edge of the data
Ctrl+Shift+↑ ↓ ← →
Select another range (desktop)
Ctrl+Click
Select all
Ctrl+A
Deselect / clear the copy outline
Esc

Editing

Edit the cell
Enter or F2
Replace the cell's contents
Start typing
Save and move down / up
Enter or Shift+Enter
Save and move right / left
Tab or Shift+Tab
Cancel editing
Esc
Typing a formula: click a cell to insert it (drag or Shift+click for a range)
Click or Shift+Click
Typing a formula: add another cell
Ctrl+Click
Clear the selected cells
Delete or Backspace
Undo
Ctrl+Z
Redo
Ctrl+Shift+Z or Ctrl+Y
Copy
Ctrl+C
Cut
Ctrl+X
Paste
Ctrl+V
Fill down
Ctrl+D
Fill right
Ctrl+R
Copy instead of continuing a series (hold while releasing the fill handle)
Alt

Formatting

Bold
Ctrl+B
Italic
Ctrl+I
Align left
Ctrl+Shift+L
Align center
Ctrl+Shift+E
Align right
Ctrl+Shift+R

Menus & help

Open the cell menu
Shift+F10 or Menu
Open the sheet tab menu (on the selected tab)
Shift+F10
Show keyboard shortcuts
Ctrl+/

Privacy and encryption

Your spreadsheets are end-to-end encrypted. Their contents are locked on your device before they're sent, and only unlocked again on the devices of the people who can open them. What we store is unreadable without the key, so neither Talk Sheet nor anyone who got hold of our servers could read your cells.

Encrypted

Everything in your cells: values, formulas and formatting, in every tab and every saved version.

Not encrypted

Your username, the names of your spreadsheets, tabs and folders, sizes, and when things were changed. Keep secrets out of names.

  • Your key is unlocked by your password. We never receive your password itself, so we can't unlock your key, and we can't reset it for you either.
  • Your browser keeps your unlocked key until you log out. On a shared or public computer, always log out when you're done. On a new device you enter your password once to unlock it.
  • Sharing hands out the key in the link (the part after #, which your browser never sends to us). Anyone you give a link to can read the spreadsheet.
  • Revoking a link stops anyone from opening the spreadsheet through it. Someone who already opened it may have kept a copy of what they saw, as with any shared file.
  • Formulas are calculated on your device; their results are never stored.

Encryption protects your data from us and from anyone who breaks into our servers. It can't protect a device that has malware, or an account whose password someone else knows. Use a strong password you don't use anywhere else.

Your password and recovery key

Because only your password can unlock your spreadsheets, forgetting it means your data can never be recovered, unless you have your recovery key. You get the recovery key when you create your account: download it or copy it into a password manager, and keep it private.

  • Forgot your password? Choose Forgot your password? on the login page, then reset with your recovery key: enter your username, the recovery key and a new password, and everything stays as it was. The recovery key is the only way to reset a password: there's no email to send a link to.
  • Lost the recovery key too? Then nobody can get you back into that account, and the spreadsheets you own stay locked forever. People you shared them with keep their access. You can create a new account with another username.
  • Lost only the recovery key? While you're logged in, go to Account (your username at the top right) and create a new one. The old one stops working.
  • Changing your password on the Account page keeps all your spreadsheets and your recovery key, and logs out your other devices.