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.
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
B12into 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:A12when 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.
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.