Spreadsheets

Magpie gives you spreadsheets with formulas, several sheets and filters. You can share each one with your team or with people you invite.

Spreadsheets is Magpie’s spreadsheet program. A spreadsheet is kept in Personal or in one of your teams. Several people can edit it at once, and it saves as you type.

Create account
Callahan Studio’s Autumn launch budget spreadsheet, with each item’s category, units, cost per unit, estimate and notes, and a total row.

Formulas and functions

Formulas can use cells, whole columns, other sheets, named ranges and table columns. The functions cover maths, statistics, logic, text, dates and finance. Lookups include XLOOKUP and VLOOKUP, and conditional sums include SUMIFS.

FILTER, SORT and UNIQUE fill several cells with their results. A named function saves a calculation you repeat, for use on any sheet. An error value such as #REF! or #N/A shows what went wrong.

Sorting, filters and data validation

You can sort a range by one of its columns, or filter its rows for everyone. A filter view filters and sorts rows for you alone. Nobody else’s view changes.

Data validation gives cells a dropdown, a checkbox or a number range. Conditional formatting colours cells by their values. A table names a range and its columns, for use in formulas.

Callahan Studio’s Client projects spreadsheet filtered to the jobs In progress, with the row numbers skipping the hidden rows, and each job’s client, lead, due date, budget and hours.

Sheets, formatting, sharing and CSV

Several sheets
A spreadsheet holds several sheets. A formula can use values from another sheet.
Formatting and layout
Cells can show currency, percentages and dates. You can merge and wrap cells, freeze rows and columns, and group rows that collapse.
Copy and paste
Cells copied from another spreadsheet program paste into rows and columns. A copied formula adjusts its references to its new place.
Sharing one spreadsheet
You can let someone outside the team view or edit one spreadsheet. They join as a guest who can open only that spreadsheet.
CSV in and out
Import makes a new spreadsheet from a CSV or TSV file of up to 5 MB. Export CSV downloads a sheet, with each formula’s last result.

Plans

Spreadsheets is on every plan, with no limit on spreadsheets. Each person you share one with from outside the team is a guest. The Free plan has 10 guests, and Pro and the Team plan have 100.

Questions

Can I bring in a workbook from Excel or Google Sheets?

Yes. You save or download each sheet as CSV and import it. Magpie detects comma, tab or semicolon separators and keeps accented letters. A file can be up to 100,000 rows and 1,000 columns. A CSV file holds a sheet’s values, so formulas are written again in Magpie.

Can several people edit a spreadsheet at once?

Yes. Changes from a collaborator, another tab or the assistant appear without a reload. Your own changes are kept on top of them. Everything saves in the background, and the page bar reads Saved once it has.

Who can see a spreadsheet?

A spreadsheet belongs to Personal or to one team. The team’s members open it through the team. People you add yourself can open that one spreadsheet and nothing else in the team.

Can I keep my own filter without changing the sheet for others?

Yes. A filter view filters or sorts the rows for you alone. The stored cells and other people’s views stay as they are. People who can only view the spreadsheet can save their own filter views too.

Can I move a spreadsheet to another team?

Yes. Move to another team takes its sheets, filter views and history. The people it is shared with keep their access. The destination team’s members get access. A spreadsheet moved to Trash can be restored for 30 days.

Start a spreadsheet.

Create an account to make a blank spreadsheet or import a CSV file.

Create account