The Ragic Guide
Transforming the way your business works with IT software and cloud services
Follow us on Social Media!
Trending
Applications
Case Studies
What is Ragic
Talking Ragic
Facebook X YouTube
Product
Guide
About
Trending
Applications
Case Studies
What is Ragic
Talking Ragic

Excel: still not a database.

By Berrin Sun

The reason Excel still holds the throne as most popular "database" is simply because it's simple.


Yes, writing things in tables is the easiest way to go if you're making a list with a few categories, and there is nothing wrong with that. It just works, especially with formulas and a few types of sorting.


On the other hand, it gets out of hand very fast.


Two of the most common problems that we hear all the time are slow loading time due to having too many rows and columns, and a proneness to human error. According to Software Risk Management Consultant Louise Pryor's study, a whopping 80% to 90% of spreadsheets contain errors. This paper was published 10 years ago, yet when we do a quick google search for "Excel database", we come across a plethora of recent tutorials and how-to guides.


There are many experts who repeatedly point out that spreadsheet applications are not database tools, and even an establishment called European Spreadsheet Risks Interest Group (or EuSpRiG), that hold an annual conference. We are looking very forward to read their proceedings of this years', which is held tomorrow.


All in all, the fact that millions of people are already using spreadsheets to manage their data has been a good start and inspiration for us. Spreadsheets have become a common ground that all business people share, so we make the experience of designing a database system a lot like editing a spreadsheet, something everybody knows how to do, and make using the database application a lot like editing a spreadsheet too.

Category: Trending > Technology

Powered by Ragic! : #1 No Code tool for digitalizing your business processes
Keeping business data on Excel is not only a big productivity drain, it's error prone and provides no adequate trail of audit. As your team grows, managing data with spreadsheets become increasingly painful.
Create your first database now!

Start Ragic for free

Sign up with Google