TRIM WHITESPACE

Which Cleanups Can You Choose?

• Trim spaces at the start and end of every value.
• Turn double spaces into one space.
• Remove invisible characters: zero-width spaces, soft hyphens, and stray byte-order marks. Non-breaking spaces become normal spaces.
• Replace line breaks inside cells with a space.
• Remove empty rows, and remove empty columns that have no value in any row.
• Clean header names too, so column names lose the same stray spaces.

Each option is independent, so you can trim ends without touching line breaks, for example. After the run the tool reports how many cells, rows, and columns each option changed, which tells you how messy the file really was.

Why Do Invisible Characters Matter?

An invisible character is a character that takes no visible space but is still part of the value. Zero-width spaces and non-breaking spaces often arrive when text is copied from a web page or a word processor. Two cells that look identical then fail to match, so duplicates survive, filters miss rows, and lookups in other systems fail.

Removing them before you remove duplicates or filter is one of the most useful cleanups you can run, because the problem cannot be seen in the grid at all. The reported count tells you how many cells were affected, which is often more than expected.

Is Trimming Safe for Every Column?

For almost every column, yes. Spaces at the ends of names, emails, and codes are nearly always accidental. Be careful only with fixed-width codes where a space is meaningful, and with notes columns where line breaks inside a cell are intended. In those cases leave that option off, or undo the change.

What Else Can You Do With a CSV Here?

• CSV viewer: Open a CSV of any size, scroll every row, and see a profile of each column.
• Sort CSV: Sort rows by one or more columns, as text, numbers, or dates, ascending or descending.
• Filter CSV: Show only the rows that match an expression such as price > 10 AND state = "NY".
• CSV validator: Find ragged rows, broken quotes, bad headers, encoding problems, and values of the wrong type.
• Remove duplicates from CSV: Find and remove duplicate rows, comparing whole rows or only the columns you choose.
• Find and replace in CSV: Find text in one column or every column and replace it, with match case, whole cell, and regex options.
• Remove rows from CSV: Delete rows by number or range, the first or last rows, empty rows, or rows that match a rule.
• CSV editor: Edit cells, add or delete rows, and add, delete, rename, or move columns.
• Split CSV column: Split one column into several at a delimiter, such as a full name into first and last.
• Merge CSV columns: Join two or more columns into one with the separator you choose, skipping empty values.
• CSV column type converter: Convert a column to clean numbers, ISO dates, true/false, or upper, lower, or title case.
• CSV to JSON converter: Convert CSV to a JSON array of objects or arrays, or to JSON Lines, with typed values.
• JSON to CSV converter: Convert a JSON array or JSON Lines to CSV, flattening nested objects into dotted column names.
• CSV to SQL converter: Turn a CSV into SQL INSERT statements, with an optional CREATE TABLE, for PostgreSQL, MySQL, SQLite, or SQL Server.
• CSV to TSV converter: Convert a comma-separated file to tab-separated values that paste cleanly into spreadsheets.
• TSV to CSV converter: Convert a tab-separated file to a standard, properly quoted comma-separated CSV.
• CSV splitter: Split a large CSV into smaller files of a set number of rows, with the header repeated in each.

All eighteen tools are on the 2csv home page, and once a file is open you can switch between them without reloading it. Part of the 2suite.io privacy-first ecosystem.