While Excel is great for planning, Anki is great for memorization. Use your Excel sheet as the master database.
Do you already have the raw text of the , or do you need help finding a downloadable source?
To build an efficient learning system, your Excel spreadsheet needs a clean, relational structure. Set up your master table with the following seven columns: Column Name The target vocabulary word Abandon Part of Speech Text / Dropdown Verb, Noun, Adjective, Adverb Verb Frequency Rank Longman classification (W1, W2, W3 / S1, S2, S3) W3, S2 Definition Concise English definition To leave someone or something Example Sentence Contextual usage of the word The crew abandoned the ship. Status Your current mastery level Learning Last Reviewed Date of your last interaction 2026-06-02 Decoding Longman Frequency Markers longman 3000 words excel
This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.
Word count: 3000
You can even use Excel's flashcard mode or export to Anki.
This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later. While Excel is great for planning, Anki is
Conditional formatting provides immediate visual feedback on your learning journey. It highlights your weak spots and celebrates your milestones. Color-Coding Your Mastery Status Select your column.
: Create a dashboard tab that shows a percentage breakdown of how many "S1" vs "W1" words you have mastered. Why this matters To build an efficient learning system, your Excel