Spreadsheet versus Database

Explore

Spreadsheet versus Database

Webinar - Spreadsheets vs. Databases

How to switch from spreadsheets to databases

Nina Kastenauer

Goodbye, Spreadsheet!

Hello, Database!

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!

Goodbye, Sheets!

Hello, Coda!

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”

⁠

Are you ready to get started?

Let’s get right to it:

⁠

Bye, Sheets!

⁠

and

⁠

Hi, Coda!

⁠

Gallery

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.