๐ Online spreadsheet
An Excel-style sheet right in your browser: type numbers and formulas, drag to fill, format dollars, sort and make a chart. Then download it for Excel or Google Sheets.
How to use it
- Click a cell and type. Enter moves down, Tab moves right, F2 edits a cell.
- Start a formula with
=, like=SUM(B2:B10). While typing a formula, click or drag across cells to insert their addresses. - Drag the small square at the corner of a selection to fill a formula down; use
$to lock a cell, like$B$1. - Select a table and use the toolbar to make text bold, format dollars, sort, or draw a bar or pie chart.
- Download an Excel (.xlsx) or CSV file, or print.
New to spreadsheets? The free Excel course teaches everything step by step in this same sheet, and Excel & Google Sheets for students covers lookups, pivot tables and charts for reports.
Questions & answers
- Can I open the file in Excel or Google Sheets?
- Yes. โExcel (.xlsx)โ downloads a real Excel file with your formulas, bold and dollar formats. It opens in Excel, Google Sheets (File > Import), Numbers and LibreOffice. You can also download a CSV.
- Which formulas work?
- Arithmetic (+ โ ร รท ^ and &), comparisons, $ absolute references, and functions including SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTBLANK, MEDIAN, PRODUCT, ROUND, ROUNDUP, ROUNDDOWN, INT, MOD, ABS, SQRT, POWER, PI, STDEV.S, STDEV.P, VAR.S, IF, AND, OR, NOT, COUNTIF, SUMIF, AVERAGEIF, CONCAT, LEN, UPPER, LOWER and TRIM.
- Is my spreadsheet saved?
- Yes, automatically, in this browser on this device only. Nothing is uploaded. Download an .xlsx or CSV to keep a copy or move it to another computer.
- How big can a sheet be?
- Up to 26 columns (A to Z) and 500 rows โ plenty for a budget, a grade tracker, a lab table or a class list.