Why not to use spreadsheet as a data storage

Reasons not to use Excel

Don't use an Excel application as a data storage software to store company data. Use cloud-based data storage instead.

  • Client: Clientigent
  • Date: September 2021
  • Style: Hand-drawn

Main ideas

Using Excel appliaction leads to several problems you can avoid using cloud-based data storage.

  1. Granularity of access control list in Excelu in not detailed enough, it is difficult to track changes done by different users.
  2. Data is not structured in Excel table/sheet, you can use rows and columns only.
  3. Data can be hardly shared, you can experience exchanging XLSX files, everyone worsk with its own version, data is overwriten, the vesioning is difficult.
  4. Solution based on Excel sheets is suitable for small data at maximum, the solution is not scalable.

Script

  1. Not Secure/Safe
    • the man like Holmes looks for changes in sheet
    • some bad guy changed data and hide
  2. Not Structured
    • you need a value from another table, complicated formula, more sheets…
    • the man thinking about formulas, steam comming out of his head
  3. Not Shareable
    • two different users change data in their own versions, it is impossible to merge that versions
    • those users push its table, trying merge them (unsuccessfuly)
    • man tries to merge data from different files that other users are sending to him
  4. Not Scalable
    • table grows, too many columns and rows
    • table pushes down the man from a chair

Storyboard

Storyboard