COLUMN TYPES

Which Conversions Are Available?

• Number: writes values like 1234.5. Strips $ and thousands separators, so $1,250.00 becomes 1250, and parentheses become negative. Optionally reads 45% as 0.45.
• Whole number: the same, rounded.
• Date: writes ISO dates such as 2026-03-14, keeping the time when you ask.
• True/false: reads yes/no, y/n, 1/0, true/false, and on/off; writes true/false, yes/no, or 1/0.
• Text: UPPER, lower, Title Case, or trimmed.

How Are Dates Read?

The date conversion reads the common formats people actually type, then writes every value as an ISO date, the year-month-day format that sorts correctly and imports cleanly. It reads 03/14/2026, 3/14/26, 2026/03/14, Mar 14, 2026, and 14 March 2026, and it keeps a time of day if you ask it to.

1. Pick the date column and choose Date.
2. Choose US month/day or day/month order for ambiguous dates such as 04/05/2026.
3. Choose whether to keep times.
4. Check the preview and the list of values that could not be read.

Why Convert Column Types Before Exporting?

Clean types make everything downstream easier. Numbers stored without dollar signs sort and sum correctly, ISO dates sort in order as plain text, and consistent true/false values import into a database boolean column. CSV to JSON and CSV to SQL both detect numbers and dates more reliably after a conversion.

Converting is one column at a time, with a preview each time. To check a whole file for values of the wrong type first, set column rules in the CSV validator, which lists every value that breaks a rule by row.

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.
• Trim CSV whitespace: Trim leading and trailing spaces, collapse double spaces, and drop invisible characters and empty rows.
• 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 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.