Blog

Guides and tutorials for exploring data in your browser.

4 min read

How to Analyze a CSV File Without Uploading It Anywhere

Learn how to open, filter, sort, and transform CSV files entirely in your browser. No server uploads, no accounts, no data leaving your device.
5 min read

Parquet vs CSV: When to Use Which Format

A practical comparison of Apache Parquet and CSV formats. When columnar storage wins, when plain text is enough, and how to convert between them.
4 min read

How to Run SQL Queries on CSV Files in Your Browser

Use DuckDB WASM to write SQL queries against CSV, Parquet, and JSON files directly in your browser. No database setup required.
5 min read

5 Ways to Clean Messy Data Without Writing Code

Fix common data quality issues like missing values, inconsistent text, duplicates, and wrong types using ExploreMyData's visual operations.
4 min read

How to Create Pivot Tables in Your Browser

Create pivot tables from CSV, JSON, or Excel files without Excel or Google Sheets. A step-by-step guide using ExploreMyData's pivot operation.
4 min read

How to Join Multiple CSV Files Without Coding

Combine data from two or more CSV files using inner, left, right, or full outer joins. All in your browser with ExploreMyData.
5 min read

Working with Dates: Extract, Calculate, and Transform

Extract year, month, and day from dates. Calculate differences between dates. Add intervals. A complete guide to date operations in ExploreMyData.