What is the best way of tracking commercial real estate signage?

[Ethan S.]

I'm doing an internship this summer with a commercial real estate firm and they've assigned multiple projects for me to do. Right now they want me to come up with a way to keep track of all of the signs that they have in a warehouse and the signs at the listings. Any suggestions on methods of tracking them? Should I create a Microsoft excel doc and track them that way?

• They are currently using Microsoft excel to track the signs but it's not effective
• Over +300 signs 
• Multiple sizes of signs / riders / frames