The mobile app lists the spreadsheets in Personal or the selected team, and those shared with you.

  • New makes a blank spreadsheet and opens it.
  • Import makes one from a CSV or TSV file.
  • Swipe a row to move a spreadsheet to Trash.

The grid

A spreadsheet opens on its grid, which scrolls over the whole sheet. Formulas are calculated on the phone, with the same results as on the website. Frozen rows and columns stay in place, and the sheet's tabs are under the grid; + Sheet adds one.

  • Tap a cell to select it, and tap it again to type in it. The bar above the grid shows what the cell holds; Enter saves it and moves down. While you type a formula, the bar offers the functions that match and shows the argument you are on.
  • Drag the round handle at the corner of the selection to select more cells. Tap a column letter or a row number to select the column or row, and tap another to select several.
  • The cell name at the left of the bar opens Go to: type a cell such as B120, a range such as A1:D20, a column such as C or rows such as 5:9.
  • Hold a cell, or use Edit, to cut, copy, paste, clear, fill down or right, and insert or delete rows and columns.
  • Format sets bold, italic, underline, wrapping, alignment, the number format and the text and fill colours of the selection.
  • Rows and columns inserts and deletes rows and columns, sets column widths, freezes rows and columns, and merges cells.
  • Data sorts the selection, turns the sheet's filter on or off, and adds or removes data validation and conditional formatting rules.

Undo and saving

Undo and Redo are the first tools under the grid. Everything saves as you go. If the spreadsheet changed somewhere else since you opened it, the app stops saving and offers Load the latest version, rather than overwriting the newer version.

The menu

The menu has Rename…, Find and replace, Manage sheets, Filter Views (your own filters, shown in the grid), Collaborators, Export CSV, Share spreadsheet link, Move to another team and Move to Trash. The app shows tables, groups, charts, named ranges and named functions and calculates with them. They are made on the website.

If a spreadsheet does not open or save in the app, Contact support.

Ask Magpie support

Send Magpie staff a question about anything this article does not answer.