How To CSV

The product is a browser-based toolkit of 60+ tools for cleaning, converting, analyzing and visualizing CSV, Excel, JSON and TSV files, addressing encoding errors, deduplication, pivoting, format conversion and outlier detection without code or installation. It is for data analysts, marketers, developers, researchers and students handling one-off fixes or repeatable workflows on files up to 1GB. Unlike server-side converters, it runs locally via WebAssembly with zero-server architecture so files never leave the device.

Key features

• AI data chat and predictive forecasting
• Auto-repair broken CSV structure and encoding
• PII masking and anonymization
• Fuzzy matching deduplication via Levenshtein
• Convert between CSV JSON Parquet Excel
• Pivot tables and data transformation
• Filter and query CSV with logical operators
• Deduplicate rows and logical dedupe
• Fix encoding and UTF-8 BOM issues
• Merge multiple CSV files
• Remove whitespace and empty rows
• Fill missing values via interpolation
• Bulk rename headers to snake_case
• Detect outliers in datasets
• Visualize CSV data with charts