CSV Files

CSV Files collects 12 free tools, with no sign-up, for preparing, checking and transforming tables separated by commas, semicolons, tabs or pipes. CSV viewer displays a file as a table, CSV Separator Converter adapts the format, and CSV column statistics calculate fill rate, unique values and numeric statistics. The subcategory suits spreadsheet exports, imports and datasets.

The right starting point depends on the stage. CSV viewer checks the content, CSV Separator Converter fixes columns, and Sort a CSV file and Filter a CSV File select rows. Select CSV columns, Remove CSV duplicates and CSV column statistics clean the structure. To produce an output, use CSV to HTML Table, Merge CSV, Split CSV, Pivot table or CSV to Markdown.

How to use

  1. Start with CSV viewer to display the table and spot columns, separators and missing values.
  2. If columns are badly split, use CSV Separator Converter, then check again with CSV viewer.
  3. To reduce the table, use Select CSV columns, Remove CSV duplicates or Filter a CSV File depending on the rows to keep.
  4. To understand values, run CSV column statistics then Pivot table, before producing CSV to Markdown or CSV to HTML Table.

Frequently asked questions

Which tool opens a CSV without a spreadsheet?

CSV viewer displays and checks a CSV file as a table. That helps spot columns before sorting or filtering. To change the separator, use CSV Separator Converter next.

How do I remove duplicate rows in a table?

Remove CSV duplicates deletes duplicate rows across all or part of the table. You choose the portion to compare based on your columns. To keep only some rows, use Filter a CSV File instead.

Can I summarize a large table?

Yes, CSV column statistics calculate fill rate, unique values and numeric statistics. Pivot table counts or sums across two columns. Both tools help understand a dataset without editing it by hand.

How do I prepare a CSV before importing it?

First open CSV viewer to check the columns. If the separator does not match, use CSV Separator Converter. Then remove repetition with Remove CSV duplicates and keep only useful columns with Select CSV columns. Finish with CSV column statistics to spot empty or strange values.

When should I merge or split a CSV?

Use Merge CSV when two tables share their columns and need to be joined. Split CSV when the table must be divided into equal blocks. For a summary, Pivot table counts or sums across two columns. Always check the result with CSV viewer before using it elsewhere.

Tools in the same category