Csv import header creates a card bug

When importing cards from CSV files the first row which is a header and is used to map it into cards (in my case front, back, tags) creates an actual card with front as front and back as back.

There’s also a reddit thread describing this problem. I cant post links for some reason here but if you google “Import csv to anki without including first row column headers” you should find it.

Is this coming from (A) a properly designated #file header – see: Text Files - Anki Manual – or (B) your own “column headers” in the first row of your spreadsheet/file?

If it’s B – That’s not a bug (despite what some folks in that reddit thread seem to think). Each row of your CSV will create a note. Anki doesn’t have any way to distinguish between the ones you want imported and the ones you don’t.

If it’s A – I don’t believe that designating fields is supported in a file header (see the link).

Please paste the headers and first few rows of your CSV here – as text
```

in a preformatted text/code block (by putting backticks before/after).

```

[Fixed the link. Thanks, @Anon_0000 !]

1 Like

Danika_Dakika: You accidentally linked the manual again instead of the reddit post.


If it is indeed B: It might be worth to post it in the Anki > Suggestions category. An option like “ignore firsts row” would solve the issue OP is having after all.

1 Like

Columns specified via the header key seem to be automatically mapped to respective fields during import if the selected note type has them named accordingly.

It was B (my own column headers). Thanks for the explanation, it’s not a bug then.

1 Like

Good point! Thanks for making that connection for me.

1 Like