The Pillar Post
When Should You Use Spreadsheets Versus Databases?
As a fiction novel writer who holds a full-time job working 100% of the time from my home that simply does not manage itself, I prefer to commit all the information I track to a spreadsheet or a database. But sometimes I get it wrong - I should have created a database instead of a spreadsheet or vice versa.
Therefore, I’m here to save you the trouble as I work out the answer to the question in writing - as a writer.
A Common Denominator Between Databases & Spreadsheets
Before you pick sides, let's agree on the one thing both tools share. A spreadsheet and a database are both homes for information — rows and columns, labeled and stored. That's the whole foundation. But you're here to decide which home fits which job.
Put even more plainly, you are choosing where your records live.
It isn't about how clever you are or how technical your tools are. It really is simply where you want each bit of information to sleep, and how easily you can wake it up when you need it.
Three Things You Already Know How To Do
Whichever home you pick for your information, you get to:
- store information somewhere that won't detach from the surface you stuck it to, or be accidentally thrown in the garbage with your other napkins from lunch;
- sort rows in an order you can use, unlike your sock drawer; and
- filter everything except what matters right now - kind of like you wish you had done at last year's Christmas party (am I right?).
And the best news? You can do all three in a simple tabular format without being a coder. At least you can learn how to with Pick Click Stack Track™, where you will come to understand that spreadsheets and databases are essentially two different tools you can use to do the same three things.
The fun is in deciding how you will accomplish building your customized tracker.
Spreadsheets Shine
I'm a firm believer in learning something new every day — especially when it's easy. But I'm flexible, so I appreciate a tool that adapts to my needs. Sometimes I overshare, but sometimes I work on things that are made to be shared.
I even like working a jigsaw puzzle of a natural landscape captured in watercolor; and even better if I can finish the puzzle within a month. So I'm drawn to a tool that's got a natural beauty and is right-sized, well-connected, and free to run.
And because some of my best ideas are still too young to be locked into a fixed shape, I want a place that lets me begin before I fully understand the problem.
Greetings, spreadsheet!
Easy To Learn
No SQL, no schema, no ceremony.
- the grid is a mental model you've carried since grade school — columns up top, rows below;
- there's no foreign computer language to pick up first, just a cursor and a blinking cell; and
- it opens in a browser, works on a phone, and even works offline.
Free To Run
Your budget has enough line items! Your information tracker shouldn't be one of them.
- it's free on a personal Google account — no invoice, no trial banner;
- there's no server to rent, no hosting package to compare, and no installation wizard; and
- there's nothing to patch, nothing to back up, and no credentials to babysit.
Happy To Bend
The spreadsheet treats a change of mind as a feature instead of a felony.
- type straight into cells, drag to fill, and make quick edits without sending up a flare;
- add, rename, or reorder columns whenever the plan shifts without having to file a blueprint first;
- use dropdowns and checkboxes to keep a column honest without building a whole rulebook; and
- paste from almost anywhere, and move data in or out as a tidy file.
Pretty By Default
It's the rare tool where the working document can double as the finished report.
- fonts, colors, conditional formatting, and notes sit right beside the data;
- charts and pivot tables come built in, with no query language to learn; and
- formulas recalculate instantly, so what if is answered before you finish asking.
Made To Share
Collaboration here isn't an add-on. It's just an email address entry away.
- two people can edit the same cell at the same moment and both see it happen;
- comments and chat live where the work lives, not in a separate inbox; and
- per-person permissions, shareable links, and a version history let you rewind your own mistakes.
Right-Sized
Some trackers are meant to be lean, quick, and temporary — and that's a strength.
- it's comfortable from a single row up to tens of thousands of rows;
- it's ideal for one-off, exploratory, short-lived, or gloriously disposable work; and
- it's a superb scratch pad for prototyping something that might one day become a database.
Well Connected
It plays nicely with the rest of your toolbox.
- Google Forms, Docs, Drive, and Calendar all flow into it natively; and
- Apps Script and third-party add-onscan automate the boring bits.
Who Calls A Spreadsheet Home
- writers keeping story logs, character sheets, submission trackers, and timelines;
- researchers logging sources, evidence, and interview notes;
- inventors stacking idea logs, experiment matrices, and prior-art notes;
- homeowners tracking budgets, inventory, maintenance, and contacts; and
- anyone whose idea is still too early to take shape.
This home has a curfew, though. Cells eventually run out, and a formula can break when things get moved around. However, reliability and scale is where the database dazzles.
Databases Dazzle
I'm the biggest advocate for how I spend my time, and I prefer not redoing work the moment my tracker system outgrows itself.
Anything that delivers facts is speaking my language; so I admire a tool that's honest and fluent in relationships.
I prefer to be prepared, which is why I like a tool that arrives good and ready to go so I can build for years until I stop delivering to it information to track.
Hello, database!
Built For The Long Haul
Some information can outgrow a grid, but the database doesn't flinch.
- millions of rows and many linked tables with no spreadsheet ceiling overhead;
- indexes and query optimization keep enormous piles of data moving fast; and
- nothing breaks when rows shuffle — data is addressed by table and column, not by a cell's street address.
Honest To A Fault
A database would rather be correct than pretty.
- data types and constraints enforce the rules;
- normalization keeps one authoritative copy of each fact, which means duplicated details can't drift apart; and
- referential integrity keeps related records pointing at things that actually exist.
Fluent In Relationships
When your trackers start talking to each other, the database is the translator.
- genuine joins across many tables, returned efficiently and correctly;
- set operations plus recursive queries for hierarchies; and
- full-text search across long passages of writing.
Good And Ready To Go
It assumes more than one thing might happen at once so it's born ready.
- safe simultaneous reading and writing across many users when you build with locking and transactions;
- granular per-user privileges and encrypted connections; and
- all-or-nothing multi-step updates, meaning nothing gets half-saved if the last step fails.
Made To Talk To Everything
A back room with a door for every guest.
- standard SQL plus drivers and APIs for any language, app, or website;
- the natural backend for sites and apps you'll build later; and
- scheduled events, stored procedures, and triggers for work that runs while you sleep.
Built To Outlive You
Designed to be handed to your future self and still make sense.
- backup, restore, replication, and point-in-time recovery are part of the job; and
- a long-lived, documented schema that doesn't silently drift while you're not looking.
Who Calls A Database Home
- inventors and homeowners with high-volume sensor or automation logs beyond a spreadsheet's comfort;
- writers and researchers with a long-term corpus of interlinked entities and facets; and
- anyone with data that deserves one authoritative source instead of forty drifting copies.
This home sits at the top of a well-sloped hill, though. The setup demands a few more cups of coffee and many nights without streaming. However, dialing it back a bit is where the spreadsheet shines.
MySQL Glossary of Terminology (Sheets, Too)
column (Spreadsheets) A vertical group of cells in a spreadsheet, identified by a letter (A, B, C, etc.).
field (Spreadsheets) A specific type of information being tracked, such as a date, name, or amount, usually represented by a column.