How to Import a Spreadsheet Into Anki
Use one row per note. Decide which column becomes the card prompt and which becomes its answer before you convert the sheet.
Worked example
Two spreadsheet rows
What is the Spanish word for chair? silla What is the Spanish word for table? mesa
Ready-to-import text
#separator:tab #html:false What is the Spanish word for chair? silla What is the Spanish word for table? mesa
Steps
- Make columns A and B the question and answer. Remove empty rows, duplicated prompts and data such as row IDs that you do not want on cards.
- Copy just the data cells into the browser exporter. It adds tab-separated import headers. Alternatively, save a UTF-8 tab-separated text file from your spreadsheet.
- Choose File → Import in Anki desktop. Pick Basic and a practice deck, then verify that column 1 maps to Front and column 2 to Back.
What to check
- Preview two questions and two answers. If you imported the column headings, delete that note and export without the header row.
- A Basic note produces one card. A note type with multiple templates changes the number of cards.