If a bank export uses semicolons between fields, choose Semicolon in Separator. A file can still have a .csv extension while using a delimiter other than a comma.
- Inspect a source line to identify the character between the date, description and amount fields.
- Choose Semicolon and check that the preview separates those fields into the expected columns.
- Recheck the column mappings and amount interpretation before continuing.
The importer suggests a separator from the source, but the preview is your opportunity to confirm it. A description containing commas is not evidence that comma is the delimiter if semicolons separate the actual fields.
Check number formatting separately
Selecting a semicolon separator does not automatically convert locale-specific decimal notation. If an amount still shows Not read or a numeric problem, inspect the amount format and prepare a supported representation from the original evidence.
Keep the original export when preparing a working copy. Compare the first and last dates, transaction count and money-in and money-out totals after any conversion. The goal is to preserve the source values while making the file’s structure readable, not to alter the underlying financial activity.
Was this article helpful?
Tell us whether this answered the question you came with.