A well-formatted Longman 3000 Excel sheet should include:
| Word | Part of Speech | Spoken Level (S1-3) | Written Level (W1-3) | Frequency Rank | |------|----------------|----------------------|----------------------|----------------| | the | determiner | S1 | W1 | 1 | | be | verb | S1 | W1 | 2 | | to | particle | S1 | W1 | 3 | | of | preposition | S2 | W1 | 4 | | and | conjunction | S1 | W1 | 5 | Longman Communication 3000 Words In Excel
With this structure, you can instantly filter for all S1 words (the most frequent spoken words like hello, goodbye, okay, please) and master those first. A well-formatted Longman 3000 Excel sheet should include:
A learner can sort the list by S-band to prioritize the 1,000 most common spoken words if their goal is conversation. Alternatively, a student preparing for academic writing can filter for W1 verbs and adjectives. Using Excel's conditional formatting, they can color-code words they have mastered, are learning, or have not yet encountered. They can even create custom quizzes by exporting a subset of words into flashcards. Open the back of a used Longman dictionary
If you want to remember the words forever, type them yourself. Open the back of a used Longman dictionary (cheap on eBay) and manually type the 3,000 words into Excel. This takes 10 hours, but you will remember 50% of them just from the physical act of typing.