Search Not Just Numbers


Tuesday, 2 November 2010

Spreadsheet or database - How to decide

There are those who will tell you that every application should be a database and that spreadsheets should never be used, whereas others will look to address every problem with a spreadsheet. How do you decide what is best for your specific requirement?

As with most of these things, neither is right for every application. In this post I want to give you my thoughts about when I believe you should favour either - I would appreciate your views in the comment too, whether agreeing or opposing.

I thought the best way to address this would be as a series of questions about your specific requirement and some comments about how your answer might influence the decision.

I have assumed in the questions below that the decision has already been reached that a bespoke solution is required.

1. Does my application require access (and particularly editing) by multiple users at the same time?
Although there are ways to achieve this with a spreadsheet (for example using Sharepoint with Excel, or if you do not require the functionality of Excel, Google spreadsheets are great at this), a yes to this question should certainly push you down the database route. In most cases, if there is only one user then a spreadsheet is the most cost-effective option.

2. Will large amounts of data need to be held in the application?
If the data really does need to be held in the application, a yes would favour a database, however if the data is already held elsewhere (for example your accounting or ERP system), Excel is an excellent tool for reporting from the data.

3. What interaction (if any) does the application require with other applications?
As stated in point 2, Excel can be an excellent reporting tool from other applications where the data flow is one way (i.e. into Excel). If your application needs two-way communication with other applications, or if it needs to trigger real-time events, such as reminder emails, then a database would normally be more appropriate.

4. Who will use it?
Many users are comfortable with Excel and will find it easy to use, however it is much harder to make "idiot-proof". If you really want to lock it down in such a way that it can't be edited by the user at all, then a database may be more appropriate. With a reasonably competent Excel user, the ability to edit and enhance might be a positive for the spreadsheet solution.

5. Where are the users?
If everyone who might use the application is on the same network (and point 1 is not a major issue), then a spreadsheet held on the server might be what is needed. Alternatively, where the application performs a task (rather than holds data), multiple copies can be used - although this may need to be controlled. An on-line database can be great way to deal with multiple users who need to access the same data from anywhere as all they need is a web browser.

6. What is my budget?
In the real world, this one can't be ignored. Assuming that either approach could address your requirements, it will almost certainly be cheaper to pay a third party to have a spreadsheet built - in many cases you can do it yourself.

I hope this helps. If you need any help in deciding, please feel free to drop me an email. At Spreadsheets by Email we can help you with both spreadsheet solutions and online databases.

If you enjoyed this post, go to the top left corner of the blog, where you can subscribe for regular updates and your free report.


  1. Hi Glen,

    Very good article! I have never considered, or thought about Acess, as I assumed that, for eg, can not use Pivot Table, IF functins, and Table and etc. Yes, Access has the appeal of more than one user at the same time. I probably need to look at it again

  2. To be honest, my inclination would not be to use Access.

    Access is still really a desktop package which is a little easier to use for non-programmers, but there are far more robust and user friendly options available.

    We do all of our database solutions for clients on-line, using an SQL database. This makes them accessible from anywhere with a web browser.

  3. Seeking is really an a popular topic recreation and additionally entertainment rolex replica all over the place North america. There isn't anything comparable to simply being apart for the outdoors and additionally perception all the stirr and therefore the test about visitor thereafter destroying gameplay. Surely, essential safety at the same time seeking have to be a fabulous urgent priority, and therefore the trustworthy seeker should make sure the person outlet stores an individual's ammunition within the healthy means. To make sure you risk-free stash ammunition certainly is the impact approximately the and additionally triumphant day out along with huge moment prepared just by rolex replica and additionally often times the loss. There's a two new ways to risk-free stash ammunition the moment seeking. The most important solution necessitates the installation of shiny steel ammunition beers. Shiny steel ammunition beers really are preferred the moment seeking think about giant sufficiently to make sure you carry a large amount of gucci replica all of the derived from one of, easy to get at locale. All of these beers really are seen as a a fabulous tight-locking option indeed gives you searcher knowledge: It's always literally improbable for those ammunition to make sure you drip apart in the instance that this would can get knocked across and also set foot gucci replica belts. To make the software towards seeking locale, a are going to characteristically desire a fabulous procedures apart throughout the wilds. The moment driving within the van towards seeking locale, various about simple and easy memory space space most suitable throughout the used car intended to earn parking prada replica ammunition beers a fabulous cinch.

  4. No need to struggle between spreadsheet and database anymore. BAU DB is a real database tool that is as easy to use as a spreadsheet. No need to build anything and go straight to data entry work. It uses cells and SQL formulas to manipulate data and uses Excel for pre-formatted document or report template. It's