A CSV file is plain-text tabular data. It can look simple, but delimiters, quoting, character encoding, and automatic spreadsheet conversions can change what you see.
What CSV means
CSV stands for comma-separated values. Each record normally occupies one line, and delimiters separate fields into columns. Despite the name, some regional exports use semicolons or tabs. A CSV file stores values and structure, not workbook styling, formulas, charts, macros, or multiple worksheets.
How to open a CSV file
- Keep an untouched copy of the source file.
- For a quick inspection, open it in a plain-text editor and identify the delimiter and quote character.
- For a table view, import it into a spreadsheet and explicitly choose the delimiter and character encoding.
- Check dates, leading zeros, long identifiers, decimal separators, and non-Latin characters before saving.
- Use the CSV Cleaner when you need a local preview and straightforward row cleanup.
Rows, columns, quotes, and delimiters
The first record often contains column names, though CSV itself does not require a header. A field containing a delimiter, quote, or line break must be escaped according to the exporting system's CSV rules. Opening malformed data by double-clicking can put values into the wrong columns, so use an import dialog when accuracy matters.
Combine or convert CSV data
Use Excel Merger to append compatible CSV rows or keep imported sources on separate sheets. Use CSV to JSON when a software workflow needs structured JSON, or Excel to CSV to export one workbook sheet as delimited text. Verify headers and data types after every conversion.
Common data problems
- Spreadsheet software removes leading zeros from account, product, or postal codes.
- Dates are interpreted in the wrong regional order.
- UTF-8 text is opened with a different encoding and characters become corrupted.
- Commas inside quoted values split into extra columns.
- Different source files use similar column names with different meanings.
- Duplicate records are removed without confirming which copy is authoritative.
CSV safety
CSV files can contain values that spreadsheet software treats as formulas. Review cells beginning with formula-triggering characters before sharing or importing untrusted data. ToolZone processes supported CSV operations in the current browser, but you should still avoid exposing confidential files on shared devices and retain a recoverable original.