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 FinderFlag similar text values for review.
- 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 an Excel (.xlsx) workbook while keeping cell values as text.
- 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 Text to CSVExtract selectable PDF text into one CSV row per page.
- Image Text to ExcelRecognize English text in an image and save it in an Excel cell.
- 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 CSVConvert structured XML records into CSV with attributes retained.
- CSV to PDFExport CSV rows as a complete, printable text report.
- CSV to TSVConvert comma-separated to tab-separated values.
- Markdown to CSVParse Markdown tables and convert to CSV format.
- HTML Table to CSVConvert one simple HTML table into CSV.
- YAML to CSVConvert YAML records into CSV while preserving scalar text.
- 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 CSVConvert INSERT statements with explicit columns and literal values into 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 UTF-8 vCards while retaining repeated fields and contact details.
- CSV to GeoJSONConvert latitude and longitude columns into GeoJSON features for maps and GIS workflows.
- GeoJSON to CSVConvert GeoJSON features while retaining every geometry and property.
- CSV to ICSCreate calendar events from CSV titles and explicit dates.
- ICS to CSVExport calendar event records with original dates, recurrence rules, and time zones retained.
Edit & Clean
Fix values, whitespace, columns, and duplicates.
- Find & ReplaceReplace matching text in CSV data cells while keeping headers unchanged.
- 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 DatesNormalize unambiguous ISO dates and timestamps.
- Column ManagerChoose which columns to keep and drag them into the order you need.
- 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 selected column in ascending or descending order.
- 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 CSVNormalize CSV structure and preserve extra fields. Broken quotes require manual correction.
- 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 ProfilerSummarize column fill rates, unique counts, and basic numeric or text types.
- Frequency AnalysisCount how often each value appears in a column.
- Correlation AnalysisFind relationships between numeric columns.
- Outlier DetectionIdentify statistical outliers in numeric columns.
- CSV Completeness ScoreMeasure the share of populated CSV cells.
- Column Type DetectorAutomatically detect data types for each column.
- Missing Value ReportIdentify empty cells and missing data patterns.
- CSV ViewerPreview and search the first 500 CSV rows privately in your browser.
- 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 & ReplaceReplace patterns in CSV values using a regular expression.
- 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 SQLite ScriptGenerate a SQLite CREATE TABLE and INSERT script from CSV.
- 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 FormatterFormat numbers in one column with two decimal places and thousands separators.
- Currency ConverterMultiply a numeric column by an exchange rate you supply.
- Unit ConverterConvert measurement units (length, weight, temperature, etc.).
- Slugify TextConvert text to URL-friendly slugs (lowercase, dashes, no special chars).