Our organization deals with many different personal contacts with mailing addresses on file. These addresses all have a "region code" assigned to the city, based on geographical location.
We currently have this list of region codes in a shared spreadsheet and whenever we need to lookup a city or number, we have to open that file in Excel and use the built-in Find function.
What I'd like to do is create a simple webpage that can be hosted locally on our office server that will simply display our entire list of cities and their corresponding region codes and then have the ability to filter that list as you type, similar to this example:
How to build a fast, simple list filter with jQuery
Is there a way to use this method of filter-as-you-type but with an external text file of some sort? The list is routinely updated with new cities and region codes so I'd like to be able to quickly update an external file (preferably a file based on a spreadsheet for sorting purposes) and immediately have those changes reflected on the webpage.
Thanks for your help.