Is data stored in Excel undermining your ability to provide legal advice? Know when it’s time to move on to a database solution.

Which file has the data I want?

How a database fixes 3 common Excel problems

Each entry is now referenced by a unique id.
Contractors can be referenced by their unique ids …
… and Emails can be referenced by their contractor id.
So a query can produce a clean mapping of emails to contractor names.
It looks like there are 3 different roofing companies in your table, but you know these are all supposed to be the same entity.

But what exactly is a database?

The two signs that it’s time to break up with Excel

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store