Now that we’ve established the key differences between spreadsheets and databases, we’ll outline
How to move your data out of your existing spreadsheet
This requires transforming your current data set-up, to ensure that it’s fulfills a database’s requirements
How to move your data into your database
Import your data into Coda, define the relationship between your data points and set up your views
But before we do, you might have a question in the back of your mind
(I know I did when I started out!) ➡️
The reason lies in the fact that when databases were first invented, they required an engineer or an IT professional to query them (ie extract data out of them). Databases were not built with structure such that any arbitrary cross-referenced query was possible.
If you wanted to ask a question, someone would have to build it ➡️
Today, that’s no longer the case. With tools like Coda, Airtable, Notion, etc, anyone - regardless of technical expertise - can set-up their own database.
And that includes you!
If databases are so great, then how come spreadsheets became the one tool that everyone uses to get their work done?
”Which of our clients that live in Deltona and are older than 60 years old have bought the red coffee table last year?”
“We’ve received your request and will be able to carry it out for you within the next 21 days, give or take.
Cheers, your overworked and understaffed IT department”