File Headers ignored on Import, if followed by commas (CSV)

I have tried using the File Headers as defined in the Anki manual.

However, if I put them in the top rows of my spreadsheet, when I save or export the spreadsheet as CSV, LibreOffice Calc adds commas at the end of these lines. Anki Import then ignores these lines because of these commas.

Having to open up the CSV and clear out these commas takes time.

Would it be possible to have Anki Import ignore any delimiters after #key:value, if those delimiters were specified by #separator:Comma ? This would mean that we could simply save our spreadsheets as CSVs and then import then immediately into Anki.

Perhaps another option, might be to use some other terminating character (e.g. semicolon) for these #key:value lines.

This is already how it works in the 25.05 betas

2 Likes

I had reported the same thing in

llama solved it in

1 Like

Thank you, @Anon_0000 and @llama !

1 Like