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
- Prepare Front, Back and Tags columns in that order. Add one or more short tags to the third cell of each row.
- 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.
- 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.