TABLUM.IO

Turn CSV, XML & JSON into an analysis-ready SQL database.

5.0•1 review•

161 followers

Turn CSV, XML & JSON into an analysis-ready SQL database.

5.0•1 review•

161 followers

Visit website

TABLUM.IO is a DataPrep SaaS that quickly transforms any data file, such as CSV, JSON, XML, or spreadsheets, into a live SQL database, pipelined to your favorite analytics software. It makes data cleansed, normalized, and accessible via SQL without coding.

Free Options

Launch tags:Analytics•Data•Business Intelligence

Launch Team

Unblocked AI Code Review — High-signal comments based on your team's context

High-signal comments based on your team's context

Promoted

LLM Explorer

Maker

📌

Hey, Product Hunt! 👋 I'm Greg, the CEO, and founder of TABLUM.IO. Today is a really special day for my team and me because we're finally launching our new product on PH! TABLUM.IO is an online tool that can turn any data file, like CSV, Excel, JSON, or XML, into analysis-ready SQL tables with just a few clicks. It's super flexible and can fetch data from an API (RESTful, SOAP), load data over HTTP, and parse, cleanse, and normalize data regardless of its original source. TABLUM.IO recognizes the content of columns, generates the corresponding SQL schema automatically, and loads the results into an internal relational database powered by ClickHouse. Ultimately, you get an analysis-ready SQL database out of raw and "dirty" data. Once your data is loaded into TABLUM.IO, you can explore, visualize, or query it using any third-party data analytics and business intelligence software via a standard database connector. Or, you can explore and transform loaded datasets with a powerful SQL console within the TABLUM.IO UI. Less time spent on data preparation means more time for data analysis. Check out this quick demo on how easy it is to ingest CSV, JSON, and XML files into a live SQL database and explore them with Metabase:

We're really excited to receive feedback from you on our product, so please try it out for free at go.tablum.io and leave your comments or feedback below. Thank you for your participation and support!

Report

3yr ago

Optimized Toolbox

@gregz Congratulations on the launch!

Report

3yr ago

LLM Explorer

Maker

@pm_optimizer Thank you!

Report

3yr ago

@gregz it looks really interesting for data intensive projects! Will try in the couple of days!

Report

3yr ago

LLM Explorer

Maker

@new_user_28684f38402aa Thank you! Feel free to reach out to me on any questions. I will demonstrate the product.

Report

3yr ago

@gregz Congrats with the lunch and fingers crossed!

Report

3yr ago

Great idea! So it is a hosted ClickHouse, right? What are the limitations? Are you able to update the records in the generated database? What if you upload the same csv again, will it tackle and resolve duplicates? Will it add new records to the same tables or generate new tables? Do you have any API for ingesting the data or it's only manual?

Report

3yr ago

LLM Explorer

Maker

@gleb_sologub it is using ClickHouse under the hood to store ingested data and share the generated tables via standard ClickHouse interface (the one on 8443 port over http). The essential part of the solution is the way it ingests data from various sources: it takes raw and unstructured data and turn it into the normalized and cleansed SQL tables regardless of its origin. There’s API for automation. It is possible to update/replace/clenased already loaded data. It also allows you to download it back in various formats. The embedded subqueries on the loaded data enable you to transform ingested data that includes aggregations, joins, duplicate removals and many other ways to manipulate data.

Report

3yr ago