Softwiro
Free Excel template

Arabic grammar summary sheet: rules, i'rab and a self-test with examples

A free Excel sheet that summarizes school-level Arabic grammar (nahw, النحو العربي) in one file: parts of speech, declinable and indeclinable words, the main and secondary case signs, subject and predicate (mubtada and khabar), kana and inna and their sisters, the doer, the passive subject and the objects, the circumstantial adverb (hal) and specification (tamyiz), the adjective, conjunction and idafa (genitive construction), i'rab of the present-tense verb in the subjunctive and jussive, and the rules for numbers. Each rule has its ruling, an example, the i'rab (grammatical parsing) of the key word and a note. A table brings together word type, case and sign, and the self-test marks itself. The examples are in Arabic, as in the sheet, with the explanations in English here.

Excel file (.xlsx) · 43 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.
القاعدةالقسمالحكم أو العلامةمثالإعراب كلمة الشاهد
أقسام الكلمةالكلمة والبناءالكلمة ثلاثة أقسام: اسم وفعل وحرف.ذهبَ الطالبُ إلى المدرسةِذهبَ: فعل ماضٍ مبني على الفتح
الاسم وعلاماتهالكلمة والبناءالاسم يدل على إنسان أو حيوان أو نبات أو جماد أو مكان أو فكرة دون زمن. يُعرف بقبوله «أل» أو التنوين أو حرف الجر أو النداء.الكتابُ مفيدٌالكتابُ: مبتدأ مرفوع وعلامة رفعه الضمة الظاهرة
الفعل وأنواعهالكلمة والبناءالفعل يدل على حدث مقترن بزمن: ماضٍ (كتبَ) ومضارع (يكتبُ) وأمر (اكتبْ). يُعرف بقبوله «قد» أو السين أو سوف أو تاء الفاعل أو تاء التأنيث الساكنة.كتبتُ الدرسَكتبتُ: فعل ماضٍ مبني على السكون لاتصاله بتاء الفاعل، والتاء ضمير متصل مبني على الضم في محل رفع فاعل
الحرفالكلمة والبناءكلمة لا يظهر معناها كاملًا إلا مع غيرها، ولا تقبل علامات الاسم ولا علامات الفعل، كحروف الجر والعطف.الكتابُ في الحقيبةِفي: حرف جر مبني على السكون
المعرب والمبنيالكلمة والبناءالمعرب ما تتغير علامة آخره بتغير موقعه في الجملة، كأغلب الأسماء والمضارع الذي لم تتصل به نون النسوة ولا نون التوكيد. المبني ما يلزم حالة واحدة، كالحروف والماضي والأمر والضمائر وأسماء الإشارة والأسماء الموصولة.هذا الكتابُ ليهذا: اسم إشارة مبني على السكون في محل رفع مبتدأ
بناء الفعل الماضيالكلمة والبناءيُبنى على الفتح (كتبَ)، وعلى الضم إذا اتصلت به واو الجماعة (كتبوا)، وعلى السكون إذا اتصلت به ضمائر الرفع المتحركة (كتبتُ، كتبنا، كتبنَ).كتبوا الدرسَكتبوا: فعل ماضٍ مبني على الضم لاتصاله بواو الجماعة، والواو ضمير متصل مبني في محل رفع فاعل
بناء فعل الأمرالكلمة والبناءيُبنى على ما يُجزم به مضارعه: السكون (اكتبْ)، أو حذف حرف العلة (ادعُ)، أو حذف النون (اكتبوا، اكتبي).اكتبْ درسَكَاكتبْ: فعل أمر مبني على السكون
الأسماء المبنيةالكلمة والبناءالضمائر وأسماء الإشارة والأسماء الموصولة وأسماء الاستفهام والشرط تلزم في الغالب حالة واحدة.الذي اجتهدَ نجحَالذي: اسم موصول مبني على السكون في محل رفع مبتدأ

Example from the “قواعد النحو” tab (Arabic), with the numbers and formulas that are in the file.

What is inside

  • قواعد النحو (Grammar rules): 49 rules in 7 sections. Each rule has its ruling or sign, an example, the i'rab of the key (witness) word and a note, and you can filter the table by section.
  • علامات الإعراب (Case signs): A table of 12 word types (singular, dual, sound masculine and feminine plurals, the five nouns, diptotes, words ending in a long vowel, defective nouns, the present-tense verb and its kinds) across four cases: nominative (raf'), accusative (nasb), genitive (jarr) and jussive (jazm), with an example for the three noun cases.
  • الأدوات والقوائم (Particles and lists): 11 lists to memorize: prepositions, subjunctive particles, jussive particles, conditional particles, the sisters of kana, the sisters of inna, conjunctions, pronouns and demonstratives, with what each list does and an example.
  • بحث (Lookup): Three tools: pick a rule name and its details appear; pick a word type and a case and the sign and a full example appear; or pick a list of particles.
  • اختبار ذاتي (Self-test): 36 questions on case signs, i'rab of positions, particles and numbers. You choose the answer from a list, a tick or cross appears, your score shows at the top, and the answer key is in hidden columns.
  • المتابعة (Review tracker): Enter the topic, review date and your score. The sheet calculates the next review date from the score and highlights topics that are due, with a chart of your scores.
  • الملخص (Summary): The number of rules per section, your test score per branch, and the average of your review scores, with three charts.

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

What makes it different

The sheet does more than state each rule. Every rule has an example with vowel marks (tashkeel) at the key word, the i'rab of that word in the usual school format, and a note that warns about the common mistake. Beside them is a sign table that answers in seconds a question such as "what marks the accusative of a sound feminine plural?", plus a self-marking test and a tracker that tells you when to return to each topic. You move from reading to practice and recall, which is what the exam needs.

How to use it

  1. Open «قواعد النحو» (Grammar rules) and review each rule with its ruling, example, i'rab of the key word and note. Filter the table by the «القسم» (Section) column to study one section.
  2. In «علامات الإعراب» (Case signs) review the table that combines word type and case (nominative, accusative, genitive, jussive) and the sign for each.
  3. In «بحث» (Lookup) pick a rule name, or pick a word type and a case to see the sign and a full example, or pick a list of particles such as prepositions, subjunctive or jussive particles.
  4. Review «الأدوات والقوائم» (Particles and lists) to memorize the members of each list (sisters of kana and inna, prepositions, subjunctive and jussive particles) and what they do.
  5. Test yourself in «اختبار ذاتي» (Self-test), 36 questions: choose the answer from the list or type it, and a tick or cross appears with your score at the top.
  6. In «المتابعة» (Review tracker) record the topic, review date and your score, and the sheet sets the next review date. Open «الملخص» (Summary) to see your progress.

Before you start:

  • A general summary, not the official curriculum of a particular grade; check your textbook. Schools differ in wording and in the order of chapters, and disputed topics are not included in this summary.
  • The i'rab statements are written in the usual school format, and your teacher may ask for a longer or shorter one; what matters is that you know the position, the sign and the reason.
  • Examples carry vowel marks (tashkeel) at the key word to show the sign. The test does not require vowel marks, so choose your answer from the list.
  • In the test, multiple-choice answers are chosen from the drop-down list, numeric answers are typed as numbers, and text is compared after removing extra spaces.
  • The fixed reference tables hold 49 rules, 12 word types and 11 lists of particles. The test holds 36 questions and the tracker holds 20 topics.

Excel file (.xlsx) · 43 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: Arabic grammar (1/3)Cheat sheet: Arabic grammar (2/3)Cheat sheet: Arabic grammar (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 match my grade's curriculum?

It is a general summary, not the official curriculum of a particular grade; check your textbook. Schools differ in wording and in the order of chapters, and disputed topics are left out, so follow what your teacher asks for.

Is the i'rab wording the format my teacher expects?

It is the usual school format (the word, then its position, then the sign and the reason for it). Your teacher may ask for a longer or shorter format, but the content is the same: the position, the sign and why.

How do I enter my answer in the test?

Choose your answer from the drop-down list in the white cell so it matches the key. Numeric questions are typed as numbers. The sheet compares the text after removing extra spaces.

Can I add my own rules and questions?

Yes. The reference tables hold what is in them and you can edit the text of any rule. The test holds a fixed 36 questions, and the tracker holds 20 topics.

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