Need to create locally-hosted, searchable database of vendors--help!
April 22, 2014 11:56 AM Subscribe
I maintain for my company a spreadsheet that contains a list of vendors and their associated information: address, contact(s), service area(s), service(s), website, and so on. It's becoming rather unwieldy as a vendor might have up to 5 different services, 2 addresses, 3 contacts each with their own email and phone number, etc. The information's all there, it's just very annoying to use.
I had the idea of creating an "intranet" type website that staff could use to filter vendors by name, service area, service type, and so on, with the results displaying in an easy-to-read format (easier than a mile-long Excel sheet, anyway). I am open to solutions like Wordpress and Joomla, just not sure how best to implement. Any ideas?
posted by erinsaurus to Computers & Internet (8 answers total) 2 users marked this as a favorite
I would also like to keep in mind that I have to update the spreadsheet on a regular basis as there are constantly new vendors to include, so any viable solution should also be fairly easy to keep up to date.