Google Sheets compared with Magpie

Google Sheets vs Magpie: an in-depth comparison

Google Sheets and Magpie both give a team spreadsheets in the browser, with formulas, several sheets, filters and sharing. Google Sheets does far more with the numbers; Magpie has more of the business around them.

  1. Google Sheets is a spreadsheet in the browser and on phones, free with a Google account and part of Google Workspace. It is built for anyone who works on numbers and lists with other people, from a household budget to a company's reports.
  2. Magpie is one subscription for a small business's software, and Spreadsheets is one area of it. Beside the grid it includes invoicing, booking pages, email at your domain, a shop and the rest of the areas a business runs on. It is built for someone whose spreadsheets are one part of running the business.
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.

How is Magpie different?

1. The spreadsheets come with the rest of the business

One Magpie subscription includes the areas a small business would otherwise buy one at a time:

  • Spreadsheets, Documents, Notes and Presentations for the team's numbers and writing
  • Invoicing, Store and paid Forms, with payment through your own Stripe account
  • Accounting, Expenses and Payroll for the books
  • Meetings and Appointments for booking pages, and Calendar for the team's events
  • Mail for email at your domain, Team chat and Video Chat for talking it through
  • Contacts, Kanban Boards, To-dos, Inventory, Websites and the other areas, in the same team

Everything is in one account with one bill. Google Workspace covers spreadsheets, documents, email, a calendar, meetings and files, and leaves invoices and selling to other software.

2. Everyone who opens a spreadsheet keeps their own filter views

Data, Filter views saves a named filter, a sort or both for one person, without changing what anyone else sees. Viewers and Commenters save views of their own too. Each view is there the next time they open the spreadsheet.

3. A team pays one price

The Team plan is one price for up to 25 people, and members do not pay. A team on the Free plan has places for 3 members and 10 guests. Google Workspace's plans are priced per user. Both plans' prices are on Magpie's pricing page and Google's.

Comparing Magpie and Google Sheets

Google Sheets does much more inside a spreadsheet; Magpie does more around it. Every line in the tables below was checked against Google's own pages, linked from each row, and against Magpie's code and Help.

Platform

WhatGoogle SheetsMagpie
Spreadsheets with formulasA grid of cells, several sheets and functions Yes Yes
Dropdowns and validationA list, a checkbox or a number range in a cell Yes Yes
Filter views of your ownSaved filters and sorts for one person Editors save them Yes
ChartsLine, bar, pie and other charts from a sheet Yes No
Pivot tablesA large table summed up by rows and columns Yes No
Editing together at onceSeveral people in one spreadsheet, seeing each other's changes Yes No
CommentsDiscussions on cells, with mentions and tasks Yes No
Version historyEarlier versions, and who changed a cell Yes No
Link anyone can openA link to view, comment or edit Yes No
Excel filesOpen and download .xlsx files Yes CSV only
Print and PDFPages set up for paper Yes No
AI in the spreadsheetFormulas, charts and summaries written by AI Eligible plans On Dashboard
Macros and scriptsRecorded steps, or code of your own Yes No
Form responses in a sheetAnswers to a form arrive as rows Google Forms CSV export
Phone appsApps for iPhone and Android Yes In the browser
OfflineOpen and edit spreadsheets with no connection Yes No
Email at your domainMailboxes at the business's own domain Gmail on Workspace plans Paid plans
Invoices and paymentsInvoices, a shop and forms paid by card No Yes
Free planMake spreadsheets without paying Yes Yes

Good to know: Where Magpie says No or Partly, the line under the row says what Magpie does instead. Each gap has an item on Magpie's roadmap, and the line changes on the day it ships.

Creating a spreadsheet

Both make a spreadsheet in the browser, with several sheets, frozen rows and grouped rows. Google Sheets starts from templates, continues a series of numbers or dates, and copies a whole spreadsheet.

WhatGoogle SheetsMagpie
Make a spreadsheet in the browser, with nothing to install Source Yes Yes
Type values into cells, copy and paste them, and undo a change Source Yes Yes
Keep several sheets in one spreadsheet Source Yes Yes
Insert, delete, group and freeze rows and columns Source Yes Yes
Drag rows and columns to move them, and hide the ones I do not need Source Magpie: Grouped rows or columns can be collapsed out of view, but a single row or column cannot be hidden, and rows and columns cannot be dragged to a new place: moving one takes cut and paste. Yes Partly
Start a spreadsheet from a ready-made starter, such as a budget or a project tracker Source Magpie: A new spreadsheet always starts empty; there are no starters for Spreadsheets. Yes No
Make a copy of a whole spreadsheet Source Magpie: A sheet's right-click menu duplicates that sheet inside the same spreadsheet, but a whole spreadsheet cannot be copied: the Spreadsheets page only makes, imports and moves them to Trash. Yes Partly
Drag to continue a series, such as 1, 2, 3 or a run of dates Source Magpie: Dragging the square at the corner of a selection repeats its cells and adjusts formulas, but it does not continue a sequence: 1 and 2 dragged down give 1, 2, 1, 2. Yes Partly

Good to know: A sheet's right-click menu renames, duplicates, moves, hides or deletes it. All sheets lists every sheet, hidden ones included.

Editing and formatting

Both make text bold, wrap it and merge cells. Google Sheets adds fonts, borders, links, pictures and smart chips in cells. They do these better than we do today.

WhatGoogle SheetsMagpie
Style cells with fonts, text and fill colours, borders and alignment Source Magpie: The website sets bold, italic and wrapping, and shows underline, alignment and text and fill colours, which only the Magpie app sets; the app is not yet in the App Store or Google Play. There is no choice of font or size, no strikethrough, no borders and no rotation. Yes Partly
Show numbers as money, percentages or dates, with the decimal places I choose Source Magpie: The bar's number format is Automatic, Number, Integer, Currency, Percentage or Date, and Currency uses the team's base currency. There is no control for decimal places and no format of your own. Yes Partly
Merge cells into one Source Yes Yes
Put a link to a web page in a cell and open it from there Source Magpie: A web address in a cell shows as plain text, and there is no HYPERLINK function, so nothing in a cell opens a page. Yes No
Put a picture in a cell or over the cells Source Magpie: A cell holds text, a number or a formula; there is no way to add a picture, and no IMAGE function. Yes No
Put a person, a file, a date or a place in a cell as a chip that shows its details Source Magpie: Cells hold text, numbers and formulas only; a name or an email address is plain text and links to no contact or teammate. Yes No

Good to know: Currency uses the team's base currency: the one in its settings, or the one its invoices or Store already use.

Functions and formulas

Both calculate with formulas, named ranges and help on each function as you type. Google Sheets has about 500 functions and Magpie about 170, and only Sheets reads other spreadsheets and the web.

WhatGoogle SheetsMagpie
Calculate with formulas, with help on each function as I type Source Yes Yes
Use the functions I know from other spreadsheets Source Magpie: About 170 functions cover math, statistics, conditional totals, logic, lookups including XLOOKUP, text, dates, finance, dynamic arrays and LAMBDA. QUERY, INDIRECT, OFFSET, the regular expression functions, SPARKLINE and the engineering and database functions are missing, and they show #NAME? when a sheet uses them. Yes Partly
Name a range and use the name in formulas Source Yes Yes
Pull cells from another spreadsheet into this one, kept up to date Source Magpie: A formula can reference other sheets of the same spreadsheet but not another spreadsheet; copying and pasting the values is the way across. Yes No
Bring live data from the web, such as a table, a feed or a stock price, into a sheet Source Magpie: Formulas cannot fetch addresses; data from the web is pasted in or imported from a CSV file. Yes No
Choose a spreadsheet's region and time zone, so dates, numbers and money read the local way Source Magpie: Every new spreadsheet gets the same region and the server's time zone, and nothing changes them. Typed dates are understood only in the form 2026-08-23. Yes No

Good to know: Magpie's functions include XLOOKUP, FILTER, SORT, UNIQUE, LET and LAMBDA. Named functions save a calculation to reuse on any sheet.

Sorting, filtering and working with data

Both sort, filter, validate entries, colour cells by their values and find and replace. Google Sheets adds pivot tables, colour scales, typed table columns and filters by values or colour.

WhatGoogle SheetsMagpie
Sort rows A to Z or Z to A by a column Source Yes Yes
Filter rows by the values I tick, a condition or a colour Source Magpie: Data, Filter hides rows that fail one condition on one column (blank, not blank, equal to, contains, greater than or less than), and everyone sees it. There is no list of values to tick, no filter by colour or formula, and no conditions on several columns. Yes Partly
Let anyone who can open the spreadsheet, viewers too, keep filter views of their own Source Google Sheets: Filter views filter and sort for one person without changing what others see, and a view's link can be shared; people who can only view get a temporary view that is not saved. Partly Yes
Offer a dropdown list or a checkbox in a cell Source Yes Yes
Colour cells by their values, including a colour scale Source Magpie: Format, Conditional formatting sets text colour, fill colour or bold when a cell is greater than, less than, equal to or contains a value, or is blank or not. There are no colour scales and no rules written as formulas. Yes Partly
Turn a range into a table whose columns have types, and group its rows by a column Source Magpie: Data, Tables names a range, shades its header and alternate rows, adds rows typed just below it, and lets formulas use its columns by name, such as Sales[Revenue]. Columns have no types and rows cannot be grouped by a column. Yes Partly
Find and replace text across sheets Source Yes Yes
Remove duplicate rows, split text into columns and trim spaces in one step Source Magpie: The UNIQUE, SPLIT and TRIM functions give cleaned results in new cells, but no command removes duplicate rows or splits a column in place. Yes Partly
Sum up a large table with a pivot table Source Magpie: There are no pivot tables; totals by group are written with SUMIFS, COUNTIFS or UNIQUE formulas. Yes No

Good to know: Data, Tables names a range, so formulas can use its columns by name, such as Sales[Revenue]. A row typed directly below a table joins it.

Charts and other views

Google Sheets makes line, bar, pie, scatter, waterfall and other charts, and a timeline of rows with dates. Magpie's Spreadsheets has no charts and no timeline yet.

WhatGoogle SheetsMagpie
Make a chart from a sheet's numbers Source Magpie: There is no way to make or see a chart. The server stores column, bar, line, area, pie, donut and scatter charts, but neither the website nor the Magpie app has a control for them. Yes No
See rows with start and end dates as a timeline Source Magpie: A spreadsheet is only a grid; dates show as values in cells. Yes No

Good to know: Export CSV downloads a sheet's numbers, with each formula's last result, for a program that draws charts.

Gemini

Gemini works inside a Google Sheet: it builds tables, writes formulas, makes charts and sums up the data. Magpie's assistant works from Dashboard and cannot read a sheet's cells.

WhatGoogle SheetsMagpie
Describe a table or tracker and have AI make it Source Magpie: After you confirm, the assistant can import CSV text it writes into a new spreadsheet, or change cells in an existing one. Nothing in the spreadsheet itself asks AI for a table. Yes Partly
Ask AI to write a formula, make a chart or explain what my data shows Source Magpie: Spreadsheets has no AI help, and cell contents are never sent to the assistant, so it cannot read or explain a sheet. Yes No
Use AI in a formula to sum up, sort into groups or write text for each row Source Magpie: There is no AI function in formulas. Yes No

Good to know: The assistant makes a spreadsheet from CSV text it writes, or changes cells in one. It does so once you confirm it in your message.

Sharing and working together

Both share a spreadsheet with named people as a Viewer, Commenter or Editor. Google Sheets adds live editing together, comments, version history, locked ranges and a link anyone can open.

WhatGoogle SheetsMagpie
Share a spreadsheet with chosen people as viewers, commenters or editors Source Yes Yes
Share a link that anyone can open Source Magpie: Spreadsheets has no link to send: its address opens only for members of its team and the people added with Share, who are emailed an invitation. Yes No
Several people editing one spreadsheet at the same time, seeing each other's changes Source Magpie: Saves are checked against the spreadsheet's latest version: a change made in another tab or by someone else means reloading before carrying on, and nobody sees another person's edits as they happen. Yes No
Comment on cells, mention a teammate, give them a task and resolve the discussion Source Magpie: Spreadsheets have no comments; the Commenter role can do only what a Viewer can. Yes No
Chat or call with the people working on a spreadsheet without leaving it Source Magpie: The spreadsheet page has no chat or call; Team chat and Video Chat are separate areas. Yes No
See earlier versions of a spreadsheet and who changed each cell, and bring one back Source Magpie: Undo and Redo reach only the changes made since the spreadsheet was opened, and there is no list of earlier versions or of who changed a cell. Yes No
Lock cells or a sheet so only chosen people can change them Source Magpie: Access is for the whole spreadsheet: anyone who can edit it can change every cell. Yes No
Get an email when someone changes a spreadsheet, or when a row meets a condition Source Magpie: Changes to a spreadsheet send no notification. Yes No
Stop the people I share with from downloading, printing or copying Source Magpie: Everyone who can open a spreadsheet, Viewers included, can export its sheets as CSV. Yes No

Good to know: Someone outside the team joins as a guest who opens only that spreadsheet: 10 guests on the Free plan and 100 on a paid one.

Excel, printing and publishing

Google Sheets opens and downloads Excel files, prints with page setup and publishes a sheet to the web. Magpie imports and exports CSV.

WhatGoogle SheetsMagpie
Open an Excel file and keep working on it Source Magpie: Import makes a spreadsheet from a CSV or TSV file of one sheet; an Excel file has to be saved as CSV first, losing its formulas, formatting and other sheets. Yes Partly
Download a spreadsheet as an Excel file Source Magpie: File, Export CSV downloads the sheet you are on as CSV, with each formula's last result; there is no Excel download. Yes Partly
Print a sheet or save it as a PDF, with the pages set up Source Magpie: There is no print layout or PDF; the browser's own print prints the page as it is on screen. Yes No
Show a sheet on my own website, kept up to date Source Magpie: A spreadsheet cannot be published or embedded; it opens only for people with access. Yes No
Have form responses arrive in a spreadsheet Source Magpie: Forms exports its responses as CSV, which Spreadsheets can import as a copy that new responses do not reach. Yes No

Good to know: A CSV or TSV import takes up to 5 MB and 100,000 rows. Magpie finds the separator itself, or you choose one.

Phones, offline, add-ons and connected data

Google Sheets has apps for iPhone and Android, works offline, and runs macros, Apps Script and AppSheet. Magpie's Spreadsheets works in a phone's browser and needs a connection.

WhatGoogle SheetsMagpie
Edit spreadsheets on a phone Source Magpie: In a phone's browser, the website opens a spreadsheet, scrolls the grid and changes the cell you tap through the formula bar, but the editor is laid out for a computer. The Magpie app, which edits spreadsheets with formulas calculated on the phone, is built but not yet in the App Store or Google Play. Yes Partly
Work on a spreadsheet with no connection Source Magpie: A connection is needed: a save made without one fails, and the page says so. Yes No
Automate a spreadsheet with recorded steps or a script of my own Source Magpie: There are no macros or scripts; named functions reuse a calculation, and Magpie's API changes cells from another program. Yes No
Build a simple app on top of a spreadsheet's data Source Magpie: On the Team plan, Magpie builds a tool a team describes, using Magpie's own records; members cannot build one from a spreadsheet themselves. Yes Partly
Work with data from another tool, such as BigQuery or Salesforce, in a sheet Source Magpie: No other tool's data can be connected to a spreadsheet; it comes in by CSV import. Yes No

Good to know: The Magpie app edits spreadsheets and calculates formulas on the phone. It is not yet in the App Store or Google Play.

Price comparison

How Google Sheets charges

Google Sheets is free with a Google account. A business pays per user each month for a Workspace plan: Business Starter, Standard, Plus or Enterprise. The plans add storage and admin controls. Gemini in Sheets comes with Standard and above, and AppSheet with every Business plan. Prices are on Google's pricing page, in your currency.

How Magpie charges

Magpie charges by plan, Free or a paid plan, for everything in the account. Personal is on Free or Pro, and a team on Free or the Team plan, one price for up to 25 people. The plan sets limits such as storage, guests and websites, not which areas you can use. Prices are on Magpie's pricing page.

On top of the planGoogle SheetsMagpie
Making spreadsheetsFree with a Google accountIncluded on every plan, Free too
How a business paysPer user, per monthOne Team plan for up to 25 people
AI in spreadsheetsGemini in Sheets on Business Standard and aboveThe assistant on Dashboard
Apps built on your dataAppSheet on every Business planA tool built for your team, on the Team plan
Connected BigQuery dataA Google Cloud billing projectNot available
Email at your domainGmail on every Workspace planIncluded on a paid plan
Invoices, a shop and paid formsNot offeredIncluded; Magpie takes 4% of Store sales and 4% of paid forms

When to choose Magpie or Google Sheets

  • Want your spreadsheets beside invoices, bookings, email and a shop, with filter views for everyone and one price for the team? Go with Magpie.
  • Want charts, pivot tables, Gemini, comments and live editing together, with apps that work offline, free with a Google account? Google Sheets is the right choice.

Recommendations by kind of business

For anyone whose spreadsheet is the work
Google Sheets. Google Sheets has charts, pivot tables, about 500 functions and live data from the web. Magpie's Spreadsheets has no charts or pivot tables yet.
For a team that edits one sheet together
Google Sheets. Several people edit at once, comment on cells and see every earlier version. In Magpie, one person's save asks the others to reload.
For a service business: a consultant, a coach, an agency
Magpie. Booking pages, invoices paid online, email at your domain and a shop are in the same team as the spreadsheets. Google Workspace has no invoices.
For a small team that pays per seat today
Magpie. The Team plan is one price for up to 25 people. Google Workspace's plans are priced per user.
For a business that keeps lists in spreadsheets
Either. Google Sheets does more with the list itself. Magpie has an area for many of those lists: Contacts, Inventory, Expenses, Staff Scheduling and To-dos. Choose by whether the list is better as a grid or as an area of its own.

Frequently asked questions

What is the difference between Google Sheets and Magpie?

Google Sheets is a spreadsheet, free with a Google account and part of Google Workspace. Magpie is one subscription for a small business's software. Its Spreadsheets area is one of many, beside invoicing, booking pages, email and a shop. Google Sheets does much more inside a spreadsheet; Magpie does more around it.

Does Magpie replace Google Sheets?

Yes, for lists and calculations: a price list, a budget, a stock count or a rota. Magpie has formulas, several sheets, tables, dropdowns, conditional formatting and filter views. It adds the invoicing, booking and email the business was buying elsewhere.

Consider keeping Google Sheets if you need charts or pivot tables, or several people editing at once with comments. Keep it if you open Excel files, print sheets or work offline. Google Sheets does each of these better than Magpie does today.

How much does Google Sheets cost?

Google Sheets is free with a Google account. A business pays for a Workspace plan: Business Starter, Standard, Plus or Enterprise, priced per user each month. Gemini in Sheets comes with Standard and above, and AppSheet with every Business plan. The prices are on Google's pricing page.

How much does Magpie cost?

Magpie has a Free plan and paid plans, each covering every area. Personal is on Free or Pro. A team is on Free or the Team plan, one price for up to 25 people. Magpie takes 4% of Store sales and 4% of paid forms. The prices are on Magpie's pricing page.

Can Magpie make charts?

No. Neither the website nor the Magpie app has a way to make or show a chart. Charts in Spreadsheets are on Magpie's roadmap. Google Sheets makes line, area, column, bar, pie, scatter, waterfall, histogram and treemap charts from the selected cells.

Does Magpie have pivot tables?

No. Totals by group are written with SUMIFS, COUNTIFS or UNIQUE formulas instead. Pivot tables are on Magpie's roadmap. Google Sheets sums up the selected data by chosen rows, columns and values. The pivot table refreshes when the data changes.

Can several people edit a Magpie spreadsheet at once?

No. Each save is checked against the latest version. When someone else has changed the spreadsheet, you reload before carrying on. Nobody sees another person's edits as they happen. Live editing together is on Magpie's roadmap. In Google Sheets several people edit at once and see each other's changes.

Can I comment on cells in Magpie?

No. Spreadsheets have no comments, so the Commenter role can do what a Viewer can. Comments are on Magpie's roadmap. Google Sheets attaches a discussion to cells, emails the people you mention and turns a comment into their task.

Does Magpie keep a history of a spreadsheet?

No. Undo and Redo reach the changes made since you opened the spreadsheet. There is no list of earlier versions or of who changed a cell. Version history is on Magpie's roadmap. Google Sheets restores earlier versions and lists one cell's earlier values.

Can I open an Excel file in Magpie?

Not as an Excel file. Import makes a spreadsheet from a CSV or TSV file of one sheet, up to 5 MB. Save each Excel sheet as CSV first; formulas, formatting and the other sheets are left behind. Excel import is on Magpie's roadmap. Google Sheets opens .xlsx, .xls and .ods files.

Can I download a Magpie spreadsheet as Excel or PDF?

No. File, Export CSV downloads the sheet you are on as CSV, with each formula's last result. There is no Excel download, print layout or PDF. Both are on Magpie's roadmap. Google Sheets downloads Excel files and PDFs and prints with page setup.

Can I share a Magpie spreadsheet with a link?

No. A spreadsheet opens for its team's members and the people added under Share. Someone outside the team is emailed an invitation and gets a free account if needed. They join as a guest who sees only that spreadsheet. Google Sheets can let anyone with the link view, comment or edit.

Does Magpie have AI like Gemini in Sheets?

Partly. The assistant on Dashboard makes a spreadsheet from CSV text it writes, or changes cells, once you confirm it. It cannot read a sheet's cells, so it cannot explain your data or write a formula for it. Gemini works inside a Google Sheet on eligible plans.

Does Magpie have the functions I use in Google Sheets?

Most everyday ones. Magpie has about 170 functions, including SUMIFS, XLOOKUP, INDEX and MATCH, FILTER, UNIQUE, LET and LAMBDA. QUERY, IMPORTRANGE, INDIRECT, OFFSET, the regular expression functions and SPARKLINE are missing, and a cell using one shows #NAME?. Google Sheets has about 500.

Can Magpie hide a row or drag it to a new place?

Partly. Grouped rows or columns collapse out of view, but a single row cannot be hidden. Rows and columns move by cut and paste, not by dragging. Both are on Magpie's roadmap. Google Sheets hides a row from its right-click menu and moves rows by dragging.

Does Google Sheets save filter views for people who can only view?

No. A Google Sheets viewer gets a temporary filter view that is not saved. In Magpie, Viewers and Commenters save named filter views of their own, which stay for the next visit.

Does Google Sheets do invoices or take payments?

No. Google Workspace's pricing page lists email, a calendar, meetings, files, documents and spreadsheets, and no invoices or shop. Magpie has Invoicing, Store and paid Forms, which take payment by card through the team's own Stripe account.

Can form responses go into a Magpie spreadsheet?

Not by themselves. Forms exports its responses as CSV, which Spreadsheets imports as a copy; new responses do not reach it. Responses in a spreadsheet are on Magpie's roadmap. A Google Form sends its responses to a new or existing sheet.

Does Magpie have an app for my phone?

No. Spreadsheets opens in a phone's browser, but the editor is laid out for a computer. The Magpie app edits spreadsheets and calculates formulas on the phone. It is not yet in the App Store or Google Play. Google Sheets has apps for iPhone and Android.

Can I use Google Sheets and Magpie together?

Yes. A team can keep its reports in Google Sheets while Magpie runs its bookings, invoices, email and shop. A CSV file imports into Magpie, and a Magpie sheet exported as CSV opens in Google Sheets.

How do I move from Google Sheets to Magpie?

Save each sheet as a CSV or TSV file. Then select Import on Magpie's Spreadsheets page and choose the file. Each file becomes a spreadsheet of one sheet. Formulas come across as their results, so write the ones you need again in Magpie.

What is included in Magpie's Free plan?

Spreadsheets, Documents, Notes, Kanban Boards, To-dos, Forms, Calendar, booking pages, Invoicing and most other areas. It has a team of 3, 10 guests and 5 GB of storage. Mail is not on the Free plan: email at your domain needs Pro or the Team plan.

If a line on this page is wrong, tell us and we will correct it.

Google Sheets changes, and so does Magpie. If a line is out of date about either product, email support@magpie.diy with the page that shows it. We check the line against that page, change it, and give it the new date. That goes for Google's own team as much as for anyone who uses Sheets.

Put your team's spreadsheets beside the rest of the business.

Create a Magpie account, then make your first spreadsheet.

Create account