Jul 09 2010
Should you use a spreadsheet or a database?
Are spreadsheets and databases interchangeable? No. Most people use a spreadsheet like a database, but that doesn’t make it one. Spreadsheets and databases allow you to store and manipulate data. Spreadsheets are better at making charts and graphs and manipulating calculations. Databases are better at storage and retrieval of large sets of data.
What is a spreadsheet? A spreadsheet is a table of data or values arranged in rows and columns. Spreadsheet applications like Microsoft Excel are also called spreadsheets. You can use spreadsheets to manage your checkbook, calculate your mortgage or create pie charts. Spreadsheets also allows you to pull data from a database, so that you can create a chart or test out new calculations.
You can use a spreadsheet to insert data into a database. A database is a collection of data or records organized for fast search and retrieval. It contains one or more tables that contain values arranged in fields and records. A field contains a single piece of information and a record has a set of fields. A table is a collection of records. Databases like MySql and MSSQL allow you to store large sets of data, used by many users at the same time and build applications with them.
Which one do you use? It depends on your project. You need to consider the following questions:
- How many records are you going to be working with?
- Who is going to use this data?
- Do you want to control how the data is entered?
- How are you going to use this data?
For example if you are in charge of membership for your local users group, you may have 200 or more members. You need to track names and contact information. Do you use a spreadsheet or a database? By looking at the above questions, you see that you have a small number of records, you are the only person who needs to use this data, you don’t need to control how the data is entered and you are going to use it to email them an newsletter. A spreadsheet is the best choice for your project. This is fine until you have reached the 2000+ members mark. Then you are going to need a database. A database lets you open the data to multiple users, manage a large set of data and control how other users are going to enter the data. For your members, you can create a website that allows your members to update their own contact information.
For your next project involving data, consider how you are going to use the data before you decide on using a spreadsheet or a database.