
a no-code database like Airtable? Because 100% of the time, Airtable is a better tool for storing data, while for building models (story-telling), I generally still favor Excel or Google sheets. Why is this relevant to the decision between using a spreadsheet vs. This probably covers the majority of typical uses for spreadsheets, and is what I mean by "storing data".īasically, where "Storing Data" is a log of specific pieces of information, a model is the more free-form act of tying different kinds of information together to tell a story. For example, real estate listings would have the address as the first column, then the price, year built, property taxes, etc. If you want to keep track of retail inventory, real estate listings, expenses, or a million other common use cases, you create a list with names in the first column and more identifying characteristics in the columns to the left. You could categorize this in various ways, but generally I lump all major uses into two buckets: First, let's zoom out a minute and think critically about why we use any of these tools.

At the end of this article, you will have a clear set of criteria to use in choosing between Airtable and a conventional spreadsheet like Excel or Google Sheets. All three of these applications are excellent pieces of software, and they even look pretty similar, but one is very different from the other two.
