Airtable – A true spreadsheet / database hybrid?

Home » Blog » Software » Airtable – A true spreadsheet / database hybrid?

Lots of the software of the world is written in Microsoft’s Excel. A spreadsheet environment lends itself particularly well to addressing everyday computing problems. Compiling tabular data, creating connections between particular pieces of that data, condensing and aggregating over a dataset’s values. These are common tasks a spreadsheet solves very well with no need for complex database or application server software.

A spreadsheet is a flexible tool that provides simple, responsive and instant feedback to data input and algorithm changes. However flexible, what keeps spreadsheets from being useful as general next-generation computing tools is their lack of scalability and the maintenance headaches they cause.

Airtable is a self-proclaimed spreadsheet-database hybrid: An online spreadsheet application that’s backed by a robust database backend. The web app allows you to create new spreadsheets from pre-populated templates such as ‘Personal CRM’, ‘Sales Leads’ or ‘Applicant Tracking’. Entering data is just as easy as entering data in a normal spreadsheet but instead of a fragile spreadsheet file that’s hard to share and collaborate on the data ends up in a scalable database. Not only does this approach allow you to collaborate on a spreadsheet easily but it also provides several features that are not normally possible with spreadsheets or at least not without incurring a performance hit:

  • Complex filtering and sorting
  • Inline linking of database tables
  • Table views

What sets Airtable apart from competitors such as Google Docs is it’s really decent UI, which includes a good mobile user experience, too. It’s still far from being on par with competitors such as Microsoft Excel in terms of cell content manipulation, formatting or calculations. Currently, it’s more of a very decent tabular data entry and presentation tool. I suppose, Airtable will really begin to shine once they release their API and open up the underlying database for direct manipulation via SQL. This way you could easily and quickly enter data first and afterwards build complex, scalable apps upon that.

Leave a Comment

* Checkbox GDPR is required

*

I agree

By continuing to browse the site you agree to our use of cookies. Privacy Policy

Privacy Preference Center

Strictly necessary

These cookies are necessary for the site to function.

PHPSESSID: Preserves user session state across page requests.

__cfduid: Used by the content network, Cloudflare, to identify trusted web traffic.

PHPSESSID
__cfduid

Preferences

Remembers the user's submitted data when a comment is submitted in a blog post. The purpose is to aut o-populate form fields for subsequent comments, in order to save time for the user.

wfvt_#

Statistics

Statistic cookies help us to understand how visitors interact with our websites by collecting and reporting information anonymously.

_ga: Registers a unique ID that is used to generate statistical data on how the visitor uses the website.

_gat: Used by Google Analytics to throttle request rate.

_gid: Registers a unique ID that is used to generate statistical data on how the visitor uses the website.

collect: Used to send data to Google Analytics about the visitor's device and behaviour. Tracks the visitor across d evices and marketing channels.

_ga,_gat,_gid
collect

Security

We use Wordfence to secure our website against hacking attempts: https://www.wordfence.com/

wordfence_verifiedHuman

Close your account?

Your account will be closed and all data will be permanently deleted and cannot be recovered. Are you sure?