View, filter, and clean CSV data

View CSV rows, search selected columns, remove duplicate output rows, and download selected columns.

How to use CSV viewer and cleaner

  1. 01Choose a CSV file.
  2. 02Search rows, select columns, and choose whether to remove duplicate output rows.
  3. 03Download the selected CSV.

Frequently asked questions

What are the limits?

The first row is treated as the header. Delimiter choice, quoting, embedded line breaks, duplicate column names, inconsistent row widths, character encoding, and spreadsheet formula interpretation can change how another application reads the same text. Filtering and column selection do not establish a schema. Verify header names, row count, representative records, escaped values, leading zeros, dates, and the downloaded file in its destination before replacing the source.

What should I check before using the result?

Check the aspects that determine the meaning of the result: keys, field names, value types, nesting, row and column counts, delimiters, quotes, escaping, line endings, and character encoding. For comparison results, inspect both additions and removals instead of reading only the highlighted summary. For Base64, distinguish encoded text from arbitrary binary data. For checksums, compare every character and confirm the algorithm name. Validate important output with the system that will receive it because syntactically valid data can still violate a schema, required field, uniqueness rule, or business constraint.

What is the difference between formatting and validation?

Formatting and validation answer different questions. Formatting parses valid data and writes it again with consistent indentation or layout so people can inspect it more easily. Validation checks whether the syntax can be parsed, but it does not automatically confirm that the values satisfy a schema or business rule. Minifying removes unnecessary whitespace without changing the parsed value. Inspection summarizes structure and depth. For XML and YAML, formatting can normalize insignificant whitespace or representation choices, so compare semantic values rather than expecting the original text style to remain identical.

Why can valid-looking data still produce an error?

Data that looks valid can contain an invisible delimiter, non-breaking space, unmatched quote, duplicate structural marker, malformed escape, mixed line ending, unsupported encoding, or format-specific feature that changes parsing. Start with the reported line, column, or path when available. Reduce the input to the smallest section that still fails, then restore surrounding records gradually. For CSV, confirm the delimiter and header assumption. For JSON, XML, or YAML, check brackets, indentation, quoting, entities, and nesting. Preserve a copy of the source while diagnosing so a correction does not remove valid information.

Do I need to install anything?

No installation or registration is required to use the listed data utilities. Open the action that matches the task, add or paste the source, choose the relevant mode, and copy or download the result. Before replacing an important file, keep the original and test the output with the receiving application. Installation is not the main compatibility question: schema expectations, encoding, delimiters, workbook features, and supported syntax still determine whether another system will accept the result.