Converted file is not separating the columns correctly

[7ArticFox7]

Hello,

Although I have created a csv. file where the data is correctly separated by commas, for some reason the convertion to the YNAB format keeps not recognising the columns (see photos attached and csv. file "error"). The convertion works well for other csv. files (see file "correct" attached), yet I see no difference between those and this new on I'm trying to convert to YNAB format.

error.csv

correct.csv

Appreciate any help!

Kind regards,
Nuno

[aniav]

Hey @7ArticFox7 it seems there is something wrong with the text and specifically with the " signs in the text. This is causing the file to be split into wrong columns or rather no columns.

Even opening it in a Numbers app doesn't properly split it into columns. I'm not entirely sure what can be done with that in the longer run, you probably need to pre-process the file on your laptop before using the CSV concerter. I was able to have this file looking properly when I played with the settings in the Numbers app when I changed the text qualifier.