We are about to launch Helical Insight 3.0 which will allow you to connect to CSV (as well as other flat files and big data sources like Mongo) from frontend itself. If you would like you can get in touch with us at firstname.lastname@example.org to get a preview of the newer release as well as early access to try it.
Meanwhile for the current version, in order to use CSV, there are two options available.
a. You can either upload the CSV into a database and then can use that specific database at the frontend for reporting purposes.
b. You can refer to the below link to understand how you can directly use CSV in version 2.1 for reporting purposes.
Kindly reach back in case of any more questions.