6
4 Comments

Free web-based tool to query (csv, xls, json) data files with SQL

Hi,

I created https://simplql.com/ to make it simple to query common data files like CSV, JSON, and Excel. Usually, when I needed to make queries to some data export files from marketing tools, CRM, etc., I built a quick node.js script or imported them to a local DB.

Simplql is an in-browser private tool that makes SQL queries fast as the data is stored in the memory. The tool doesn't upload your files - everything stays local and therefore adding a file with 100k rows is almost instant. This also makes it private and secure to use with sensitive data.

Hope you find it useful!

on January 17, 2021
  1. 2

    Excellent idea! Congratulations.

    1. 1

      Thanks @ryanh1!

  2. 2

    This comment was deleted 3 years ago

    1. 1

      Thanks @meoweloper! It’s using alasql for memory based JS SQL.

      Currently keeping it as a pet project. I have thought on open sourcing but it would require better work on the codebase and I also have some additional ideas to try out first with it :)

      1. 2

        This comment was deleted 3 years ago

        1. 1

          It is! Definitely try it out, would like to see what you come up with. Similarly to this, one of the ideas is to have an option on simplql to add external links including google sheets airtable, etc. in addition to local files.

          And I will keep in mind.