I need to take a very large Excel spreadsheet (17,000+ rows by 100+ columns) and turn it into a very user-friendly, searchable, sortable, filterable online database that can generate reports. This would be pulled into pages on a Wordpress site I’m hosting here on DH.
Users should be able to quickly run queries and narrow down to a subset of the data they are interested in, and export it to common file formats (.csv, .xlsx, etc.) or print nicely formatted reports.
Sounds like a lot of data and it is – totally should not be in Excel! But seems fairly straightforward as far as a Web application goes.
I just don’t have experience building large Web databases like this. I could migrate the data into a MySQL database and build a custom UI, but with my (low) level of skill that would take a long time. I have to believe a canned solution would get me 80% of the way very quickly.
Excellent data security is an absolute requirement, which makes me think I should host the data with a solution provider who will guarantee security & accept liability for any problems. (Client will pay for this.) Where privacy and data access is concerned, we want a “big boy” solution rather than something cobbled together.
But here’s the kicker: I also need to be able to create a clean, customized UI with great usability and modern Web standards (HTML5, CSS3, responsive.) This is my area of specialty. I want a solution that will let me apply my own CSS, tweak the markup as needed, and so on.
Know of any solutions out there that I could evaluate?
So far I’ve found a few services but the Web UI’s are terrible and I can’t customize them easily. (Inline CSS, hello? It’s 2011, right?) It seems everything I’ve looked at was “designed by developers” with little thought to providing flexibility for a Web UI designer. A big differentiator for this product will be user experience and ease of use.
Any ideas? Thanks!