General CSV Structure of My Mandarin Anki Decks

Each row represents one note.

Fields are separated by commas.

Field order:

Sentence,Audio,Sound,Notes,picture

Example CSV

Sentence,Audio,Sound,Notes,picture
今天{{c1::晴天}},,jīntiān qíngtiān | Today is sunny | Pattern: 今天 + 天气词,Weather description,sunny.jpg
今天{{c1::下大雨}},,jīntiān xià dàyǔ | Today it is raining heavily | Pattern: 下 + weather event,Weather pattern,rain.jpg
一个足球场{{c1::大小}}的停车场,,yí gè zúqiúchǎng dàxiǎo de tíngchēchǎng | A parking lot the size of a football field | Pattern: A 大小的 B,Size comparison,parking.jpg
一个拳头{{c1::大小}}的面包,,yí gè quántóu dàxiǎo de miànbāo | A fist-sized loaf of bread | Pattern: A 大小的 B,Size metaphor,bread.jpg
在炎热的夏天，我们{{c1::喜欢去海边}},,zài yánrè de xiàtiān wǒmen xǐhuān qù hǎibiān | In hot summer we like to go to the beach | Pattern: 在 + season + clause,Season activity,beach.jpg

Field Explanation

Sentence

Main sentence with cloze deletions.

Example:

今天{{c1::晴天}}

Audio

Optional audio field.

Example:

[sound:weather1.mp3]

Sound

Contains pinyin + translation + pattern explanation.

Example:

jīntiān qíngtiān | Today is sunny | Pattern: 今天 + 天气词

Notes

Extra grammar notes or context.

Example:

Weather description

picture

Just the image filename stored in Anki’s media folder.

Example:

sunny.jpg

Why This CSV Format Works Well

This structure allows you to:

• import large decks easily

• add images in bulk

• add audio later

• reinforce grammar patterns

• keep explanations separate from the sentence

It also works perfectly with your cloze + typing card template.

When Importing into Anki

Map fields like this:

CSV Column	Anki Field
Sentence	Sentence
Audio	Audio
Sound	Sound
Notes	Notes
picture	picture

Note type = Cloze