Softwiro
Free Excel template

English grammar rules sheet in Excel: tenses and structures with examples

A free Excel sheet that summarizes English grammar in one file, with explanations in Arabic for Arabic-speaking learners. It covers the 12 tenses (form, use, keywords, and affirmative, negative and question examples), the passive voice for every tense, conditionals, reported speech, modal verbs, comparatives, articles, prepositions, relative pronouns and question tags. Alongside them are a table of 120 irregular verbs with a lookup and a self-test that marks itself.

Excel file (.xlsx) · 50 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.
Tenseالزمن بالعربيالتركيبالاستعمالجملة مثبتة
Present Simpleالمضارع البسيطS + V1 (s/es مع he/she/it)العادات والحقائق والجداول الثابتةShe plays tennis every Sunday.
Present Continuousالمضارع المستمرam/is/are + V-ingعمل يحدث الآن، أو عمل مؤقت، أو خطة قريبة مرتبةThey are watching a film now.
Present Perfectالمضارع التامhave/has + V3عمل في الماضي له أثر في الحاضر، أو خبرة، أو زمن لم ينتهِI have finished my homework.
Present Perfect Continuousالمضارع التام المستمرhave/has been + V-ingعمل بدأ في الماضي ويستمر حتى الآن، أو انتهى حديثًا وأثره ظاهرShe has been studying for two hours.
Past Simpleالماضي البسيطV2 / did + V1عمل انتهى في وقت محدد في الماضيWe visited Alexandria last summer.
Past Continuousالماضي المستمرwas/were + V-ingعمل كان جاريًا في لحظة في الماضي، أو عمل قطعه عمل آخرI was reading when the phone rang.
Past Perfectالماضي التامhad + V3عمل وقع قبل عمل آخر في الماضيThe film had started before we arrived.
Past Perfect Continuousالماضي التام المستمرhad been + V-ingمدة عمل استمر حتى لحظة في الماضيHe had been waiting for an hour when the bus arrived.

Example from the “الأزمنة” tab (Arabic), with the numbers and formulas that are in the file.

What is inside

  • "الأزمنة" (Tenses): 12 tenses. Each has its form, its use explained in Arabic, keywords, an affirmative sentence, a negative sentence, a question and a note.
  • "القواعد" (Rules): 79 rules in 10 sections: passive voice for every tense, conditionals, reported speech, modal verbs, comparatives, articles, prepositions of time and place, relative pronouns, question tags and other structures. Each rule has a form, an explanation, an example and a note.
  • "الأفعال الشاذة" (Irregular verbs): 120 verbs in alphabetical order: base form, past, past participle, the Arabic meaning, and the pattern of change (AAA, ABA, ABB and ABC).
  • "بحث" (Lookup): Pick a tense, an irregular verb or a rule from the list and all its details appear at once.
  • "اختبار ذاتي" (Self-test): 36 questions on irregular verbs, tenses, the passive and other structures. Type or choose your answer and a tick or a cross appears, with your score at the top. The answer key sits in hidden columns.
  • "المتابعة" (Tracking): Enter the topic, the date you reviewed it and your score. The sheet works out the next review date, highlights topics that are due, and charts your scores.
  • "الملخص" (Summary): The number of rules in each section, the irregular verbs by pattern, and your score in each part, with four charts.

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

What makes it different

The sheet explains in Arabic and gives examples in English. Every tense has three sentences (affirmative, negative and question) that show the full structure, and every rule has a natural, correct example. It also includes the irregular verb table every student needs, with a quick lookup, a self-test that marks itself, and a tracking sheet that tells you when to return to each topic. You move from reading a rule to using it and remembering it.

How to use it

  1. Open the "الأزمنة" (Tenses) sheet and review each tense: its form, its use in Arabic, its keywords and three examples (affirmative, negative and question).
  2. Open the "القواعد" (Rules) sheet and filter the "القسم" (Section) column to review one section at a time: passive voice, conditionals, reported speech, modal verbs and more.
  3. In the "الأفعال الشاذة" (Irregular verbs) sheet, find the verb in the table (base form, past, past participle and meaning), or pick it in the "بحث" (Lookup) sheet to see its forms.
  4. In the "بحث" (Lookup) sheet, choose a tense, a rule or a verb from the list and all its details appear at once.
  5. Test yourself in the "اختبار ذاتي" (Self-test) sheet, 36 questions: type your answer or choose it from the list, and a tick or a cross appears with your score at the top.
  6. In the "المتابعة" (Tracking) sheet, record the topic, the review date and your score. The sheet sets the next review date. Open "الملخص" (Summary) to see your progress.

Before you start:

  • This is a general summary, not an official curriculum for any particular grade, so check your textbook. The order and names of the tenses may differ slightly between books and schools.
  • The English examples use English that is common to British and American usage. In the irregular verbs table we give the more common form of each verb, and a second form may exist in some varieties (such as gotten in American English).
  • In the self-test, type the English answer in English letters. Capitalization does not matter. For multiple-choice questions, choose your answer from the drop-down list.
  • The verb read is spelled the same in all three forms, but its past and past participle are pronounced red.
  • Capacity: 12 tenses, 79 rules, 120 irregular verbs, 36 test questions and 20 tracking topics.

Excel file (.xlsx) · 50 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 grammar rules (1/3)Cheat sheet: English grammar rules (2/3)Cheat sheet: English grammar rules (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. Tense names and their order can differ between books, so follow what your teacher asks for.

Are all irregular verbs included?

The table has 120 verbs, among those most used in schools, not every irregular verb in the language. Some verbs have a second form in use (such as gotten in American English), and the table gives the more common form.

How do I type my answer in the self-test?

Type the English answer in English letters. Capitalization does not matter. Or pick it from the drop-down list. The sheet compares the text after removing extra spaces.

Can I add my own rules and questions?

You can edit the text of any rule. The tables have room for what they hold: the self-test takes 36 questions and the tracking sheet takes 20 topics. A large question bank needs dedicated software.

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