CSV Tools

Instantly remove duplicate rows from any CSV or spreadsheet. Keep your data clean and analysis-ready.

Strip leading and trailing spaces from every cell in your CSV or spreadsheet with one click.

Convert text in your CSV to UPPERCASE, lowercase, or Title Case — across all cells or specific columns.

Clean up blank rows from CSV and Excel files automatically. Get a compact, analysis-ready dataset.

Delete columns with no data from your CSV or spreadsheet. Simplify your schema automatically.

Convert your CSV from comma-separated to tab, semicolon, or pipe-delimited format — instantly.

Validate your CSV file and get a detailed report of formatting issues, encoding problems, and inconsistencies.

Convert CSV files to Excel (XLSX) or Excel files to CSV online. Fast, free, and no software required.

Keep only the rows that match your criteria — filter by column value, text match, or emptiness. No formulas needed.

Find any text in your CSV and replace it across an entire column or the whole file — bulk editing made easy.

Rename any column header in your CSV or XLSX file. Map old names to new ones before importing to another system.

Choose which columns to keep and in what order. Drop unwanted fields and reorder the rest before your import.

Sort your CSV or Excel file by any column — alphabetically or numerically, ascending or descending.

Add an auto-incremented ID or row number column to your CSV or Excel file. Set the column name, starting value, and position.

Keep only the first or last N rows of your CSV or Excel file. Ideal for sampling large datasets or taking the most recent records.

Combine two or more columns into a single column with a separator. Great for building full names, addresses, or IDs.

Split one column into multiple columns by a delimiter. Separate full names, addresses, or compound values into distinct fields.

Replace blank cells with a static value, or fill them from the cell above (forward fill) or below (backward fill).

Rotate your data 90°: rows become columns and columns become rows. Instantly reshape wide data into tall format or vice versa.

Upload a CSV file and instantly convert it to a clean JSON array. Free, no signup required.

Upload a JSON file (array of objects) and convert it to a clean CSV instantly. Free, no signup required.

Upload a CSV and generate SQL INSERT statements ready to paste into your database. Free, no signup required.

Split a large CSV into smaller files by row count. Download all parts as a ZIP archive.

Convert inconsistent date formats in any column to a single consistent format — ISO, US, EU, or custom.

Choose exactly which columns to keep and drop the rest. Simpler than reordering when you just need to cut columns.

Extract a random sample of N rows from a large CSV. Perfect for testing, ML datasets, and audit sampling.

Remove HTML tags, control characters, symbols, and non-ASCII characters from text cells in your CSV.

Insert a new column into any CSV or spreadsheet file, with a default value for every row.

Standardize numeric columns: set decimal places, add thousands separators, prepend a currency symbol.

Pull all distinct values from a single column and export them as a clean list. Great for building lookup tables.

Upload a CSV and instantly generate a clean HTML table. Paste it straight into any webpage or email.

Convert a CSV file to a Markdown table in one click. Perfect for README files, wikis, and documentation.

Reshape long-format CSV data into a wide pivot table. Turn category values into column headers.