French Mastery Hub: All-in-One Study Tool, Vocabulary & Verb Tracker (Google Sheets Template)
Learn French with one organized, interactive Google Sheet
The French Mastery Hub is a study system that holds your vocabulary, verb conjugations, grammar rules and practice tools in one place. Set a status on each item, and the dashboard shows your progress by itself.
What's inside
- 1,378 vocabulary words with pronunciation, gender, plurals, example sentences and English translations (99 categories)
- 432 verbs with 6 tenses each: présent, passé composé, imparfait, futur simple, conditionnel, subjonctif (15,500+ conjugated forms)
- 190 expressions and idioms
- 138 grammar rules, plus tense usage rules and AVOIR & ÊTRE tables
- 325 practice questions, 39 connectors and transitions, 432 verb + preposition patterns
- Numbers, dates & time, accents, seasons, directions, countries and more
Study tools built in
- Status dropdown on every row: Not Started, In Progress, Mastered, Needs Review
- Rows change color as you progress
- Dashboard with progress cards, charts, an overall mastery score, a word of the day and a random verb generator
- Review Queue that collects everything marked Needs Review
- Flashcards and a conjugation drill with answers you can hide
- 30-day habit tracker with a streak counter
- Study by Category: pick any category and see only those words
- Listen links that open each word in Google Translate so you can hear it
- Filters on every data tab
How it works
1. Download your files after purchase.
2. Open the Start Here PDF and click your personal link.
3. Click "Make a copy". The sheet is saved to your own Google Drive.
4. Run the one-time setup from the "French Mastery" menu and start studying.
What you receive
- Link to the Google Sheet template (you make your own private copy)
- Start Here PDF
- Printable 30-day habit tracker (US Letter and A4)
Good to know
- A free Google account is required.
- Works best on a computer. On phones and tablets use the free Google Sheets app. Dropdowns and checkboxes work there; the custom "French Mastery" menu appears on computers only.
- This is a digital product. Nothing is shipped.
- Personal-use license: for your own study. Please don't share, resell or redistribute the file.
FAQ
- Do I need Excel? - No. It is made for Google Sheets.
- Will my progress be private? - Yes. You work in your own copy in your own Drive.
- Can I add my own words? - Yes. Insert a row and copy the status and listen cells from the row above.
- Does it teach pronunciation? - Each word has a written pronunciation guide and a link that opens Google Translate, where you can hear it. It is not a recording library.
- Is this for beginners? - It works for beginners through advanced learners. It is a reference and tracker, not a video course.