mrc's Cup of Joe Blog

Join us in exploring the world of modern development, evolving technologies, and the art of future-proof software

Struggling with spreadsheets? Turn them into web apps

EducationHow many business users in your company rely on spreadsheets on a regular basis? How many users access and edit a single spreadsheet? I know what you’re thinking: “How should I know?”

That’s the point. There’s no way to know. If your employees use spreadsheets to create reports, maintain business data, or even share data with other employees, it’s out of the IT department’s control. They could accidentally email spreadsheets full of critical business data to their friends, and you’d never know. Ten different employees could alter the same spreadsheet (often incorrectly), and you’d never know.

How do you regain control over your company’s data?

The ideal solution: Put all of that spreadsheet data into a secure database, and let employees create web applications over the top of it. The benefits of this approach are obvious:

  1. It’s safer: The IT department secures the data and controls user access.
  2. It’s more accessible: Rather than mailing spreadsheets to each other, users can access their data via the web.
  3. It opens up new options: Once data is in a database, users can create all types of applications over that data, like reports, BI apps, mobile apps, and more.

The question: How can users easily convert their spreadsheet data into a database, AND build web applications over that data? Believe it or not, it’s actually simple. Rather than try to explain it, this video walks you through the whole process (in under 3 minutes).

https://youtu.be/P6ZdmApFRXA