When an entire source line appears as one column, the selected separator probably does not match the file. Check the delimiter before changing the date or amount mappings.
- Look at the source text and identify the character between fields: comma, semicolon, tab or pipe.
- Choose that Separator and inspect the preview again.
- Map Date, Description and the applicable amount fields once the columns split correctly.
If the source really contains one combined text field per transaction, obtain a structured export from the bank or prepare a reviewed table from the original evidence. The importer needs separately mapped values for reliable dates and amounts.
Check quoting too
A whole row enclosed as one quoted field can also appear as a single column. Preserve legitimate quoted descriptions, but correct an accidentally quoted entire table through the source export or spreadsheet application.
After fixing the structure, compare the row count and totals. A delimiter change can reveal additional fields or rows that were previously unreadable. Do not commit the import based only on the disappearance of the initial formatting error; confirm that the interpreted transactions match the source.
Was this article helpful?
Tell us whether this answered the question you came with.