Choose a tool to view, edit, clean, validate, combine, split, or convert your data. Each tool has its own page with the controls and instructions for that task.
VIEW & EDIT · 9 tools
Open a CSV or TSV table, then search and sort its rows.
→Upload a file or paste CSV text, then search and sort it.
→Read, copy, or download a CSV as plain text.
→Search files up to 50 MB and browse 100 rows per page.
→Check file dimensions and preview the first 25 rows.
→Change CSV cell values and download the edited file.
→Edit values in a familiar spreadsheet-style grid.
→Inspect, search, copy, or download one column at a time.
→Find records and inspect their fields individually.
→CLEAN & FIX · 13 tools
Remove duplicate rows from a CSV file.
→Remove duplicate rows from a CSV file online. Keep the first copy of each matching record, then download the cleaned CSV.
→Remove blank and empty rows from CSV files. Keep your column headings and download a cleaner CSV table.
→Remove columns with no data from a CSV file. Keep columns that contain values and download the result.
→Remove CSV data rows that contain blank cells. Preserve the header and download rows with complete values.
→Trim leading and trailing whitespace from CSV headings and cell values, then download a cleaned file.
→Clean special symbols from CSV headings and values while preserving letters, numbers, spaces, and common punctuation.
→Replace repeated spaces inside CSV cells with a single space while preserving the rows and columns.
→Repair common CSV formatting by parsing delimited rows and exporting a consistently quoted comma-separated file.
→Clean CSV data by trimming cell whitespace, removing empty rows, removing duplicate rows, and dropping empty columns.
→Normalize CSV headings and values by trimming whitespace, standardizing Unicode text, and collapsing repeated whitespace.
→Find and replace text in CSV headings and cell values. Choose whether matching should be case-sensitive.
→Remove identical columns from CSV files while keeping the first copy and its values.
→MERGE & SPLIT · 9 tools
Combine multiple CSV files into one.
→Split CSV data into smaller files.
→Combine CSV files into one table by matching their column headings, even when columns appear in a different order.
→Join two CSV files by a matching column. Choose an inner, left, or full join and download the combined table.
→Split a CSV file into smaller parts by setting the number of data rows in each output file. Each part keeps the header.
→Split a wide CSV file into smaller files by choosing how many columns each part should contain.
→Split a CSV file into smaller parts by choosing a target size in kilobytes. Every part includes the header row.
→Merge multiple CSV files into one table. Match columns by heading and keep values from every file.
→Append CSV files with matching headings and column order into one CSV. Keep the first header and add all data rows.
→FILE CONVERTERS · 14 tools
Convert rows of CSV data into JSON objects.
→Generate an HTML table and preview or download the markup.
→Convert an array of JSON objects into CSV.
→Export CSV data as an Excel workbook.
→Convert an Excel workbook to CSV.
→Export a CSV table as a paginated PDF.
→Turn CSV rows into XML records.
→Extract simple XML records into CSV rows.
→Convert a headed table into a YAML list.
→Convert flat YAML records into CSV.
→Format rows as a Markdown pipe table.
→Convert comma-separated fields to tabs.
→Convert tab-separated fields to CSV.
→Export a CSV table as plain text.
→DATA MANIPULATION · 14 tools
Sort CSV rows by a selected column in ascending or descending order, with an option to sort numeric values as numbers.
→Filter CSV data by a chosen column and condition, such as contains, equals, starts with, or blank.
→Select and extract the columns you need from a CSV file while preserving their original order and row values.
→Reorder CSV columns by entering their new sequence. Keep every row aligned with its column heading.
→Rename CSV column headings and download a copy with the updated header row.
→Keep or remove CSV rows based on a selected column, including empty checks, text matches, and numeric comparisons.
→Count the data rows in a CSV file, excluding its header row, and download the count as a small CSV report.
→Count the columns in a CSV file using its widest row and download the count as a CSV report.
→Transpose a CSV table by switching rows and columns, then download the reshaped data.
→Search all columns in a CSV file and extract every data row that matches your search term.
→Group CSV rows by a selected column and calculate a count, sum, or average for each group.
→Create a CSV pivot table by selecting row categories, column categories, and a count, sum, or average calculation.
→Calculate the count, sum, average, minimum, or maximum for a numeric CSV column.
→Extract unique non-empty values from a selected CSV column while keeping their original order.
→VALIDATION & ANALYSIS · 12 tools
Check whether CSV rows have a consistent structure.
→Check CSV quote syntax and find rows with a different number of fields than the header.
→Find blank, duplicate, or whitespace-padded column headings in a CSV file.
→Detect whether a delimited text file uses commas, tabs, semicolons, or pipes between fields.
→Inspect a CSV file for a byte order mark, valid UTF-8, UTF-16, or bytes that may use a legacy encoding.
→Generate per-column CSV statistics, including missing values, unique counts, and numeric ranges.
→Profile CSV columns with inferred data types, missing values, unique counts, and sample values.
→Find missing or blank CSV cells and see their counts and row locations by column.
→Find repeated complete data rows in a CSV file and report the first and duplicate row numbers.
→Validate CSV column names and order against an expected schema that you provide.
→Detect whether CSV columns contain integers, numbers, dates, booleans, text, mixed values, or blanks.
→Check CSV data for missing values, duplicate rows, blank rows, extra whitespace, uneven field counts, and quote errors.
→DEVELOPER TOOLS · 11 tools
Generate SQL table definitions and INSERT statements from CSV rows.
→Convert CSV rows into a JavaScript array of objects with the column headings as keys.
→Generate a TypeScript interface and typed array of objects from CSV column headings and rows.
→Convert a CSV file into a PHP array of associative records keyed by the column headings.
→Convert CSV records into a Python list of dictionaries keyed by the column headings.
→Generate PostgreSQL INSERT statements from CSV data with quoted identifiers and escaped text values.
→Generate MySQL INSERT statements from CSV rows with backtick-quoted identifiers and escaped values.
→Generate SQLite INSERT statements from CSV data with quoted column names and escaped text values.
→Generate Python code that loads CSV records into a pandas DataFrame from a list of dictionaries.
→Generate a Java class and object list from CSV column headings and records.
→Generate C# classes and object initializers from CSV headings and records.
→ADVANCED TOOLS · 15 tools
Compare two CSV files and download the records found only in each file.
→Compare two CSV files row by row and find every changed, added, or removed cell value.
→Run simple SQL-style SELECT queries against a CSV file with WHERE, ORDER BY, and LIMIT clauses.
→Create a bar or line chart from a CSV category column and numeric value column.
→Plot numeric CSV columns on an X and Y axis to create a scatter graph.
→Visualize filled and missing cell counts for each column in a CSV file.
→Generate a CSV dataset with chosen fields and random sample values for names, emails, dates, cities, and numbers.
→Create a blank CSV template from a list of column headings and a chosen number of empty rows.
→Generate sample customer, product, or event CSV data for demos, prototypes, and testing.
→Replace values in selected CSV columns with consistent anonymous labels while preserving repeated-value patterns.
→Map CSV source columns to a target set of column names and reorder the output to match your schema.
→Add a spreadsheet formula column to CSV rows using a formula template with a row-number placeholder.
→Convert CSV text between UTF-8, UTF-8 with BOM, and UTF-16 little-endian encodings.
→Convert CSV files between comma, tab, semicolon, and pipe delimiters while preserving quoted cell values.
→Convert CSV rows into a JSON object with a configurable data property and row-count metadata.
→Use the CSV Table Viewer to inspect rows and columns, search values, and sort a table. To focus on a particular field or record, use the CSV Column Viewer or CSV Row Viewer. To change cell values and save an updated file, open the CSV Editor.
Remove duplicate rows with the CSV Cleaner, check a file's structure with the CSV Validator, or combine multiple CSV files and split a large file into smaller parts.
Convert CSV data to HTML, JSON, Excel, XML, YAML, Markdown, TSV, plain text, PDF, or SQL. Convert XML, YAML, TSV, JSON, and Excel back to CSV.
CSV stores table rows as text, with fields separated by a delimiter such as a comma. A header row is commonly used for column names. Quoted fields may contain commas or line breaks, so review the preview and output when a file uses special characters or has missing values.