Troubleshooting
Start by checking the file structure, search options and header setting.
The CSV file will not open
If all values appear in one column or accented letters look wrong, try File → Import CSV with Options…. Adjust the separator, encoding and quotation style, then check the preview.
Komma reports malformed quotation marks with a row number, such as a missing closing quote or unexpected text after it. First check that the selected quotation style matches the file. Otherwise, correct damaged data in the source program or a text editor.
A field containing separators or line breaks must be enclosed in the selected quotation marks. A matching quote inside that field is doubled, for example "" for double quotes. With multiline fields, the reported CSV row can differ from the visible line number in a text editor.
If the file still cannot be opened with the appropriate encoding, export it again as UTF-8 CSV from the source program if possible. Character encoding correction in Komma CSV requires an open document.
Search, selection or sorting behaves unexpectedly
- For missing matches, check Aa,
.*, the selected column and the header option. - Search does not hide rows. Find and Select sets checkboxes and must be triggered again after changing the search condition.
- Automatic selection always excludes the header row.
- Sorting and replacement are not restricted to checked rows.
- Sorting uses natural text order (A2 before A10), not mathematical values such as decimal amounts.
- If the first data row is displayed as headings, turn off Header row.