Blog
Guides and tutorials for exploring data in your browser.
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.
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.
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 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.
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.
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.
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.