How to Import Tags From a CSV File Into Anki

Use a separate tags column when you want tags to vary by note. Separate individual tags in a cell with spaces and use a hyphen or underscore for a tag that needs two words.

Worked example

Comma-separated file with a Tags column

#separator:comma
#html:false
What does CPU stand for?,Central processing unit.,computing week-1
What does RAM stand for?,Random access memory.,computing hardware

Expected tags

CPU note: computing, week-1
RAM note: computing, hardware

Steps

  1. Prepare Front, Back and Tags columns in that order. Add one or more short tags to the third cell of each row.
  2. Save the sheet as UTF-8 CSV or TSV. In Anki's import preview, map the third column to Tags rather than to a note field.
  3. Import a small test batch and look for the tags in Browse. Check both a shared tag and a note-specific tag.

What to check

  • The two-column browser exporter is for Basic Front and Back only. Use your spreadsheet export for a Tags column.
  • Quote CSV fields that contain commas, including an answer with a comma.

References