How to create a searchable database with EASA
While Excel is not a searchable database, a spreadsheet can be used with EASA to create one in three simple steps that involve no coding whatsoever:
1. Identify the data
Your spreadsheets may contain lots of different pieces of information. EASA is a powerful tool, but it’s not a mind reader. The first step, then, is to let the software know what data you want to save into your searchable database. This is achieved by defining Named Ranges within Excel itself — it’s a simple way to flag the cells which contain data that you would like to be searchable. To use our previous example, if you want to create a searchable database of your employees, you’d want to mark the relevant information and then label them using Named Ranges such as ‘name’, ‘date of birth’ and so on.
2. Build your app
Now it’s time to define what the users will actually see. Usually, it’s possible to use EASA’s Excel Wizard to automatically create a professional-looking web app that resembles the layout of your original spreadsheet. But that’s not a requirement — with EASA, the world is your oyster, and if you want to create a web app that looks nothing like your existing spreadsheet, the software provides options to enable that.
3. Configure the search page
Finally, we need to add a landing page to your app. This is where users will be able to search and filter saved data and optionally select cases that have been previously saved. Gone are the days of opening tens or even hundreds of versions of a spreadsheet to find the one you wanted to open. Windows File Manager, which lets you see filenames and save dates, but not the data inside, will become obsolete using EASA. However, it doesn’t end there! Although your data is generated by your original spreadsheet, placing it into EASA, deploying it as an app, and saving instances to a database gives you the opportunity to use it in ways you couldn’t have in Excel. For example, you can choose to present your data in visual ways using programs like Tableau.
Beyond a searchable database
EASA allows you to create much more than just a searchable database, though. By converting your spreadsheet into a web app, you can enjoy many other benefits and solutions to some of Excel’s main faults. Both employees and clients using your spreadsheets would be able to do so directly from their browser without having Excel installed on their computer, eliminating version incompatibility. What’s more, it means protecting your IP, avoiding people changing important information, and always knowing you’re using the correct version of your spreadsheet.
So, who said you couldn’t have your cake and eat it? Creating a searchable database app directly from your Excel file is completely possible. Contact us to learn more about how EASA can work for your company.
