Tool directory
Every HappyCSV tool in one place
All 101 tools run entirely in your browser — files are never uploaded to a server. Pick a category below, or jump straight to any tool.
Organize
Merge, split, compare, and arrange files.
- Merge FilesUpload multiple files and stack them into one large master file.
- Split Large FileBreak a large file into smaller files of N rows each.
- Split by ColumnAutomatically split one file into many based on a specific column.
- Remove DuplicatesUpload a list and in your browser delete duplicate rows.
- Compare FilesFind rows that are different (or matching) between two files.
- Fuzzy Duplicate FinderFind near-duplicate rows using similarity matching. Suitable for names with typos.
- Join CSV FilesJoin two CSV files by email, ID, SKU, or another matching column with inner, left, right, and unmatched modes.
Convert
Turn data into the format your next tool needs.
- Excel to CSVConvert messy .xlsx files into clean, machine-readable CSVs.
- CSV to ExcelConvert CSV files to Excel (.xlsx) format with proper formatting.
- JSON to CSVTurn complex JSON data arrays into readable CSV spreadsheets.
- CSV to JSONConvert CSV spreadsheets into JSON format for developers.
- CSV to SQLTurn a spreadsheet into 'INSERT INTO' database code.
- PDF to CSVExtract text from PDF files and convert to CSV format.
- Image to ExcelExtract text from images using OCR and convert to Excel format.
- CSV to MarkdownConvert CSV files to beautiful Markdown tables for docs and GitHub.
- CSV to HTML TableConvert CSV files to HTML tables ready to embed in websites.
- CSV to YAMLConvert CSV data to YAML format for configuration files.
- TSV to CSVConvert tab-separated values to comma-separated CSV format.
- CSV to XMLConvert CSV data to structured XML format.
- XML to CSVParse XML files and convert to CSV format.
- CSV to PDFExport CSV as a beautifully formatted PDF table.
- CSV to TSVConvert comma-separated to tab-separated values.
- Markdown to CSVParse Markdown tables and convert to CSV format.
- HTML Table to CSVExtract tables from HTML files and convert to CSV.
- YAML to CSVConvert YAML arrays to CSV spreadsheet format.
- CSV to LaTeX TableGenerate LaTeX table code from CSV data.
- CSV to PHP ArrayGenerate PHP array code from CSV data.
- CSV to Ruby HashGenerate Ruby hash array code from CSV data.
- SQL CREATE TABLEGenerate SQL CREATE TABLE schema from CSV structure.
- SQL UPDATE GeneratorGenerate SQL UPDATE statements from CSV data.
- SQL DELETE GeneratorGenerate SQL DELETE statements from CSV data.
- SQL INSERT to CSVParse SQL INSERT statements and convert to CSV.
- CSV to VCFDetect and manually map contact columns, preview the result, choose vCard 3.0 or 4.0, and export contacts for iPhone, iCloud, Google Contacts, and Outlook.
- VCF to CSVConvert vCard contact files into a spreadsheet-ready CSV for cleanup, analysis, or migration.
- CSV to GeoJSONConvert latitude and longitude columns into GeoJSON features for maps and GIS workflows.
- GeoJSON to CSVFlatten GeoJSON features and coordinates into a spreadsheet-ready CSV file.
- CSV to ICSConvert event rows into an ICS calendar file for Google Calendar, Outlook, Apple Calendar, and iPhone.
- ICS to CSVConvert calendar events from ICS into CSV for reporting, cleanup, or migration.
Edit & Clean
Fix values, whitespace, columns, and duplicates.
- Find & ReplaceBulk replace text across the entire file.
- Case ConverterFix capitalization (e.g., convert to Title Case).
- Trim WhitespaceRemove invisible accidental spaces from cells.
- Transpose CSVFlip rows into columns and columns into rows.
- Remove Empty RowsDelete rows with no data or all blank cells.
- Standardize DatesConvert mixed dates into one standard format (YYYY-MM-DD).
- Column ManagerSelect which columns to keep in your CSV file.
- Smart Column SplitterSplit full names into Title, First, Middle, Last, Suffix.
- Remove Empty ColumnsDelete columns that have no data or all empty cells.
- Add Row NumbersAdd an auto-incrementing ID/index column.
- Reverse Row OrderFlip the order of all rows in your file.
- Sort CSVSort rows by one or more columns (ascending or descending).
- Filter RowsKeep only rows that match your conditions.
- Random SampleExtract a random subset of rows from your data.
- Head / TailExtract the first or last N rows from your CSV.
- Pivot TableSummarize data by grouping and aggregating values.
- Unpivot / MeltTransform wide format to long format (unpivot columns to rows).
- Column CalculatorAdd a new column with calculated values using math formulas.
- CSV EditorEdit CSV cells locally in your browser, review changes, and download a clean copy without uploading your data.
Optimize & Repair
Repair structure, encoding, and import issues.
- Repair Broken CSVFix files with bad delimiters or unclosed quotes.
- Fix EncodingFix weird symbols (e.g., é -> é).
- Minify JSONCompress a JSON file by removing all whitespace.
- CSV DiagnosticFind delimiter, encoding, header, row-shape, type, and data-quality problems before importing a CSV.
- Change CSV DelimiterDetect and change CSV separators such as comma, tab, semicolon, or pipe without opening the file in Excel.
- Fix CSV HeadersTrim, normalize, and safely deduplicate CSV headers before importing data into another system.
- Find Duplicate CSV ColumnsDetect repeated or empty CSV headers and download a reviewable report before importing the file.
Data Analysis
Profile, validate, and understand your data.
- Column StatisticsCalculate Sum, Average, Min, Max, Count, and StdDev for numeric columns.
- Data ProfilerGet a complete overview of your data: types, distributions, and patterns.
- Frequency AnalysisCount how often each value appears in a column.
- Correlation AnalysisFind relationships between numeric columns.
- Outlier DetectionIdentify statistical outliers in numeric columns.
- Data Quality ScoreCalculate completeness, validity, and overall quality percentage.
- Column Type DetectorAutomatically detect data types for each column.
- Missing Value ReportIdentify empty cells and missing data patterns.
- CSV ViewerOpen CSV files in a fast, private spreadsheet-style viewer with search, sorting, and column inspection.
- CSV Row and Column CountGet an instant row count, column count, file size, and header summary without uploading your CSV.
- Extract Unique CSV ValuesChoose a CSV column and create a sorted list of unique, non-empty values for filters and validation.
Developer
Generate JSON, SQL, XML, YAML, and code.
- Mock Data GeneratorGenerate realistic fake data for testing: names, emails, addresses, etc.
- JSON PrettifyFormat JSON with proper indentation and line breaks.
- Regex Find & ReplaceUse regular expressions for powerful pattern matching and replacement.
- Extract EmailsFind and extract all email addresses from your data.
- Extract Phone NumbersFind and extract all phone numbers from your data.
- Extract URLsFind and extract all URLs and links from your data.
- Validate JSONCheck if your JSON file is valid and find any errors.
- CSV ValidatorCheck CSV for formatting issues, inconsistent columns, and errors.
- CSV to NDJSONConvert each CSV row into newline-delimited JSON for APIs, logs, BigQuery, and data pipelines.
- NDJSON to CSVFlatten newline-delimited JSON records into a spreadsheet-ready CSV file.
- CSV to SQLiteGenerate a safe SQLite schema and import script from CSV data for local databases and prototypes.
- CSV to ParquetConvert tabular CSV data into compressed Apache Parquet for analytics, DuckDB, Python, and data pipelines.
- Parquet to CSVOpen Apache Parquet files and export their rows to CSV for spreadsheets, sharing, and inspection.
- CSV Schema GeneratorInfer a practical JSON Schema from CSV headers and values for APIs, validation, and database imports.
Security
Anonymize, redact, hash, and encrypt locally.
- Anonymize DataMask specific columns (e.g., email -> j***@gmail.com).
- Hash DataSHA-256 hash specific columns permanently.
- Encrypt CSVEncrypt your CSV data with AES-256 encryption.
- Decrypt CSVDecrypt previously encrypted CSV files.
- Redact Sensitive DataAutomatically redact SSNs, credit card numbers, and other patterns.
- GDPR Data RemovalRemove columns whose headers match common PII terms. Review the result before sharing or reuse.
- CSV Formula ScannerFind cells that could be interpreted as spreadsheet formulas before sharing or opening a CSV in Excel.
Productivity
Handle the small transformations that add up.
- Unix Timestamp ConverterConvert Unix timestamps to readable dates or vice versa.
- Number FormatterAdd thousand separators, decimal places, and currency symbols.
- Currency ConverterConvert currency values between different currencies.
- Unit ConverterConvert measurement units (length, weight, temperature, etc.).
- Slugify TextConvert text to URL-friendly slugs (lowercase, dashes, no special chars).