Softwiro
Free Excel template

English vocabulary and expressions sheet in Excel: words by topic and spaced review

A free Excel sheet that gathers 340 common English words and expressions in 12 topics, with Arabic meanings for Arabic-speaking learners: daily life, study, travel, work, shopping, health, feelings, phrasal verbs, collocations, common expressions, linking words and easily confused words. Each entry has its part of speech, its Arabic meaning, a natural example and a note. Alongside the word bank are a lookup by English or Arabic, a spaced-review table using Leitner boxes that works out the next review date and highlights what is due today, a self-test that marks itself, a study log and a summary with charts.

Excel file (.xlsx) · 92 KB · 9 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “بنك الكلمات” tab (Arabic), with the numbers and formulas that are in the file.
الموضوعالكلمة أو التعبيرالنوعالمعنى بالعربيمثال
الحياة اليوميةneighbournounجارOur neighbour waters the plants when we travel.
الحياة اليوميةchorenounعمل منزلي روتينيWashing the dishes is my least favourite chore.
الحياة اليوميةroutinenounروتينMy morning routine takes about thirty minutes.
الحياة اليوميةalarm clocknounمنبّهI set my alarm clock for six o'clock.
الحياة اليوميةnapnounقيلولةHe takes a short nap after lunch.
الحياة اليوميةshowernounدُش، استحمامI take a shower every morning.
الحياة اليوميةlaundrynounالغسيل (ملابس للغسل)I do the laundry on Fridays.
الحياة اليوميةgroceriesnounمشتريات البقالةWe buy our groceries from the market on Saturdays.
الحياة اليوميةerrandnounمشوار قصير لقضاء حاجةI have a few errands to run this afternoon.
الحياة اليوميةrecipenounوصفة طعامThis recipe needs only four ingredients.

Example from the “بنك الكلمات” tab (Arabic), with the numbers and formulas that are in the file.

What is inside

  • "الإعدادات" (Settings): Today's date and the number of days between reviews for each box from 1 to 5 (1, 3, 7, 14 and 30 days as a general suggestion you can change).
  • "بنك الكلمات" (Word bank): 340 words and expressions in 12 topics, each with its part of speech, Arabic meaning, example and note, plus empty rows where you can add your own words up to 400.
  • "بحث" (Lookup): Type an English word, or a full or partial Arabic meaning, and the sheet shows its details, its review box and its next review date.
  • "المراجعة" (Review): Pick the word and enter the date of your last review and the box number from 1 to 5. The sheet works out the next review and the status (overdue, due today, later, mastered or new).
  • "اختبار" (Test): 38 questions. In the meaning questions you type the word, and in the gap-fill questions you choose the answer from a list. A tick or a cross appears with your score at the top, and the key is in a hidden column.
  • "التقدم" (Progress): The number of words in each topic, how many have entered review, how many you have mastered and how many are due, plus a daily log of new words, reviewed words and study minutes.
  • "الملخص" (Summary): Words in the bank, in review, due, overdue and mastered, and your test score, with four charts: words per topic, words per box, review status and daily review.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

What makes it different

The sheet is more than a word list. It gives you natural, correct examples to copy, and notes that stop you mixing up similar words such as affect and effect. Then it tells you each day what you need to review so you do not forget what you have learned. You move from reading words to using them and remembering them.

How to use it

  1. In the "الإعدادات" (Settings) sheet, enter today's date and check the number of days between reviews for each box from 1 to 5, changing them if you wish.
  2. Browse the "بنك الكلمات" (Word bank) and filter the "الموضوع" (Topic) column to take one topic: each word has its part of speech, Arabic meaning, an example and a note.
  3. Type any English or Arabic word in the "بحث" (Lookup) sheet and all its details appear, with its review box.
  4. In the "المراجعة" (Review) sheet, pick a word you have started learning and enter the date of your last review and the box number (1 is new or difficult, 5 is mastered). The sheet works out the next review date and highlights what is due today.
  5. After each review: if you remembered the word, move it to the next box. If you forgot it, send it back to box 1. Enter today's date.
  6. Answer the "اختبار" (Test) sheet (38 questions), then log your daily study in "التقدم" (Progress). Open "الملخص" (Summary) to see the words in each topic and each box.

Before you start:

  • This is a general summary, not an official curriculum for any particular grade, so check your textbook. The words are common in everyday and study use. It is not a complete dictionary, and meanings can vary with context.
  • The word bank has 340 words and expressions in 12 topics and holds up to 400. Add your own words in the empty rows below it and they appear in the lookup and the review list. Each word is written only once in the bank.
  • Spaced review is a method for remembering words: each time you recall a word it moves to a higher box and its reviews are spaced further apart. The default days (1, 3, 7, 14 and 30) are a general suggestion, not a fixed rule, so change them in the settings sheet to suit you.
  • Next review date = last review date + the number of days for the box. A word counts as due when its date is today or earlier, based on the date written in the settings sheet.
  • In the "بحث" (Lookup) sheet you can type part of the Arabic meaning (such as «يستعير», to borrow). If the part appears in more than one word, the first matching word in the bank is shown.
  • Capacity: 400 words in the bank, 400 words in review, 50 test questions and 60 days in the study log. Examples use simple, common English, and American and British usage are mentioned in the notes where they differ.

Excel file (.xlsx) · 92 KB · 9 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

Cheat sheet: English vocabulary and expressions (1/3)Cheat sheet: English vocabulary and expressions (2/3)Cheat sheet: English vocabulary and expressions (3/3)
0 downloads · 3 pages

Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

In this sheetIn Custom Software from Softwiro
One file that one person edits at a time, and copies reach you on WhatsApp.A program with a login for each user and permissions you define, and everyone sees the same data.
You type everything and check the numbers by hand.We design the screens around your work steps, so each person records only what concerns them.
Columns and formulas are fixed as the sheet was designed.We build what you need: reports, alerts and screens your way.
Backups and security are your own responsibility.The program runs on a secured server with regular backups.

See Custom Software from Softwiro · Ask for a demo

Frequently asked questions

Does the sheet follow a school curriculum?

It is a general summary, not an official curriculum for any particular grade, so check your textbook. The words are common in everyday and study use and are not from one particular book. Meanings can vary with context.

What is the box system and how do I use it?

It is a well-known spaced-review method (the Leitner system). A new word, or one you forgot, starts in box 1. Each time you remember it at review, it moves up a box, so its reviews are spaced further apart. The default days (1, 3, 7, 14 and 30) are a general suggestion, not a fixed rule, so change them in the settings sheet.

Can I add my own words?

Yes. Type them in the empty rows under the word bank, which holds up to 400 words. They then appear in the lookup and in the review selection list. Write each word only once. The review sheet holds 400 words and the test holds 50 questions.

How do I search in Arabic?

Type the meaning in full as it appears in the bank, such as «تذكار» (souvenir), or a part of it, such as «ضمان» (guarantee). The first match in the bank appears. If the part appears in many words, type a longer phrase or search in English.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

All the templates in this group: Free study summaries: rules, formulas and self-tests

More free templates for: Study summaries

More free templates

All templates · Free tools