Structural cleanup is not type conversion
CSV cleaning can remove unwanted structure without turning dates, numbers, identifiers, or boolean-looking words into guessed types. OpenFileTools performs only operations you individually select.
Available cleanup operations
Trim removes leading and trailing cell whitespace. Empty-row removal keeps rows containing at least one nonempty value. Empty-column removal keeps columns with at least one value. Exact duplicate removal compares complete rows after selected earlier cleanup.
Review before downloading
Choose the input delimiter, output delimiter, and desired operations. Run Clean CSV, then compare rows and columns before and after plus counts of empty and duplicate rows removed.
Exact duplicate does not mean similar
Rows differing by case, internal whitespace, punctuation, or any cell value remain distinct. Selecting Trim can make edge-whitespace variants identical, so review the chosen operations before accepting duplicate removal.
Protect meaningful blanks
An apparently empty column may represent a reserved import field. Keep empty-column removal off when a receiving system requires fixed positions, and preserve the original CSV for rollback.
- No dates or numbers are normalized.
- Line endings in generated output use CRLF.
- The preview is bounded while the summary covers the full parsed model.