What is a spreadsheet?
A spreadsheet is a grid of rows and columns, like Excel or Google Sheets, where people type, sort and calculate information by hand.
Last updated
In real life
Like a notebook ruled into columns: quick and flexible, but it doesn't check what you write unless you set up rules.
Try it yourself
The demo adds the same rows to a spreadsheet and a database. A normal row goes into both. Type "two" as a number, or add the same customer twice, and the spreadsheet accepts it, so the totals come out wrong. The database refuses, because it checks its rules first.
Spreadsheet: takes whatever you type
| A | B | C | |
| 1 | name | orders | |
|---|---|---|---|
| 2 | Maya | maya@example.com | 3 |
| 3 | Tom | tom@example.com | 1 |
Total orders: 4 · Customers: 2
Database: checks its rules first
- Rule: “orders” must be a whole number
- Rule: each email appears only once
| name | orders | |
|---|---|---|
| Maya | maya@example.com | 3 |
| Tom | tom@example.com | 1 |
Add the normal row first, then try the word and the repeat. Watch which side notices.
Spreadsheet vs database
A spreadsheet is made for people to type into and calculate by hand. A database is made for apps: it checks every change against rules and handles many users at once.
Common questions
What are spreadsheets good for?
Budgets, lists, small trackers and quick sums: anything a few people edit by hand and want to see at a glance.
Can a spreadsheet be an app's database?
For a tiny project, sometimes, and some tools connect apps to a sheet. It gets risky as the data and users grow, because a sheet doesn't check what goes in unless you set that up.
Where you will use this
Quick check: Spreadsheet
Question 1 of 3