Displaying a simple online database

[gar598]

This isn't exactly programming...

I have a few csvs (no more than 10k rows, 4 columns) - I would like to present them online and have them easily searchable with the ability to filter by columns/fields, etc. Some more advanced analytics such as charting or other sorts would be great as well. Ideally - I could integrate this into wordpress. Any ideas on how best to go about this would be most appreciated. Thank you.

 

[beginner99]

This sure is programming. Then csv or excel is not a database. This basically means you will need to import your data into a relational database managment system, like MySQL. This should be easy unless your csv's are in reality more complex than you pointed out.

The of course you need to access that data and display it in a web page. for that a server-side programming language is used were php probably is the most common one. But you can do the same thing and more in .net, Java, Python...
(if you need to host I would recommend php as it is easiest and cheapest)

Most of those languages have library for charting. Personally i would however recommend JavaScript to do it (client-side). This will lead to interactive charts (eg. more than just nice pictures).

Don't know about wirdpress but you can guess by now that you will either need to learn some stuff or have it done by a professional (my recommendation).

 

[jsedlak]

What are the columns and their data types?

It is easy to get it into the database - just write a simple script that takes each line of the CSV and turns it into an INSERT statement. Then preface the SQL manually with the CREATE TABLE command.