If you’re ready to learn what Google sheets can do for SLPs, check this out!
For the past three years, I’ve relied on Google Sheets for much of my caseload management. Recently, I’ve expanded to using it for more and more including data collection, lesson planning, IEP dates, evaluation timelines and more!
I’m going to share with you how I use it and why I love it! For the most visual example of how I use it, check out the video below.

Click on the link below.
{ACCESS THE GOOGLE SHEETS TEMPLATES HERE}
—-You will need to click “Make a Copy” to add the file to your own Google Drive. Then, you can fully edit it for your own use.—-
Not a video person? Check out the pictures below. I’ll quickly explain how I use each and if you want more information, feel free to check out the video at any time!
Scroll down a bit to see an example of one of the forms printed and filled out. Years later and I’m still using this system daily!

1) Student Information Sheet
Google sheets are perfect for SLPs looking to manage their caseload. This is how I keep track of who is on my caseload. Write the students’ names, their teacher/grade, special education teacher, weekly minutes, and important dates. The important dates section has conditional formatting so it automatically changes the color of the box based on several variables.

The IEP Due column changes to yellow when the IEP is due in the next 3 months.
The Previous Evaluation box turns red when the evaluation is due this school year.
The birthday box turns green when the birthday is in the next 15 days.
I got some of these numbers wrong in the video but the text above is accurate. Sorry about that! 🙂

2) Schedule
You can also use Google sheets for SLPs schedules! This doesn’t need any explanation. Just a simple schedule but it is how I keep track of my schedule with the changes that naturally happen each week 🙂
3) Daily Plans/Data
This is my most recent addition to my Google Sheets for SLPs lineup. I use this sheet to plan session and take data. It does take a bit of set up initially but it’s been lifesaving. I make a sheet for each day of the week, Monday through Friday. To set these sheets up, I make a copy of it for each day of the week. Then I write the time in the leftmost column, then the students that I see next to that. In the goals column I write a brief description of their goals. Each week, I print the sheets for each day and keep them in my binder. As I plan what we are going to do, I can write it in the “Plan” column. I also take data in that same box. Why do I love this system? It helps me stay on track with my students goals (they are right there) and it also makes billing easier. After I’ve billed for a student, I cross their name off. Once all of the names are crossed off, I move the sheet to my “SLP Data Binder” that stays on my desk. This binder is just used for old data sheets. This means if I’m carrying the sheet around with me each day, it needs to be billed. I try to bill after school every day so that I don’t get behind. Watch the video on this if you have any questions! Or, check out the picture below for an example of a printed and filled out sheet!


4) Evaluations
This is a very simple form. Just add in student names and check off when you’re finished with each component of an evaluation. I know many of you follow a different protocol for evaluation so edit this sheet as needed.

5) Data Sheet
This is a pretty self-explanatory sheet that I used to use. Now I’ve replaced it with the daily data/planning sheets, but for those that like to keep individual student data on their own sheet. I love pairing this with my SLP Reference Sheet freebie so that I can quickly calculate percentages and identify what supports I provided.
Are you interested in using these templates for yourself?
Click on the link below.
{ACCESS THE GOOGLE SHEETS TEMPLATES HERE}
—-You will need to click “Make a Copy” to add the file to your own Google Drive. Then, you can fully edit it for your own use.—-
{thanks for reading}

Want great speech therapy ideas and resources delivered right to your inbox? Join my email newsletter! You can sign up below:
This is great! Thank you for sharing. I just recently switched to the schools after working with adults for two years. For your data plans/data template do you use it to add information for 4-5 students? Most of my groups are 4-5. I love that template but feel like there would be A LOT of information in there
Yes I do! It is quite full but I really shorten goal areas for groups of 4-5. I might even write things as succinct as “vocabulary, comprehension, describing” or something. I try to write as much as I can in as small of a font as I can if possible! Hope that helps 🙂
This is incredible! I am not tech savvy and haven’t used spreadsheets AND then they were sent from heaven!! Thank you Shannon. I use this every day and every time I look at it I send my appreciation your way!!
Love your ideas and will use in a workshop with full credit given to you. Thanks for sharing.
Hi there! I am a new SLP almost finished up my CF in a school. I have tried a bunch of different data collection methods this year, and this seems like it might really work for me! Do you have any tips for progress monitoring? I tried taking data for groups in the beginning of the year, then when it came to be progress note time I noticed that it was really difficult to follow my data. I was flipping through pages and pages of attendance and session notes. Thank you for sharing these documents!
Glad they look helpful for you!! I use slptoolkit.com for all of my progress monitoring. It really makes things easy for me! Hope it helps you!
Hi Shannon, I like your idea for the main “student information” form. I see that they are already formatted on the downloaded form but could you explain how you did this and what formula you used and why you used it. Thanks.
Hi Mary! Glad it’s useful for you! I’m a bit confused as to what you’re asking. I added some example information to the forms to show you how to use them, however when you copy the file to you own Drive, you can edit anything as needed. As far as the formulas go, I’d recommend Googling different Google Drive formulas to see all of your options there! In the blog post above, I explain what formulas I included (e.g., The IEP Due column changes to yellow when the IEP is due in the next 3 months), but all of those are just what works for me! You can change anything you need! Hope that helps! 🙂
Thanks so much for sharing!!!!
Thank you so very much for sharing these templates and for being so thorough! Your hard work is greatly appreciated!
Hi Shannon, I just entered all of my information into the template and am experimenting with dates. I am not having any luck with colors changing. Any idea what I could have done wrong? UGH (I’m know it’s me).
Sorry! The conditional formatting I used can be a bit complicated. Below are two links that might be helpful:
https://support.google.com/docs/answer/78413?co=GENIE.Platform%3DDesktop&hl=en
https://thejournal.com/articles/2014/03/26/formatting-cells-based-on-date-ranges-in-google-sheets.aspx
Hi, Shannon! I don’t usually ever comment on blogs, but after using this Google Sheets template for about a month, I felt compelled (for the first time ever!) to do so. 🙂
I’m currently in my CF in the middle school setting (love this age, even though I may be in the minority there..ha). I’m the only SLP in the building, and have a caseload of about 60 students. Pretty overwhelming for a new clinician, but let me tell you: these caseload management sheets you’ve created have been a LIFESAVER!! I’ve modified/added quite a few extra tabs to suit my needs (e.g., tabs for planning activities for each day of the week, progress report/report card and Medicaid checklists, as well as a tab devoted solely to student data). And it’s all in the “cloud,” so I don’t have to stress about my computer crashing one day and losing it all.
Anyway, I could go on and on (but I won’t!). The conditional formatting is an amazing help, and I just want to extend a huge “thank you” for helping to make my adjustment to independent clinician a little bit easier!
Kristen… you absolutely made my day! Thank you! I’m SO glad the templates were useful for you. They’ve saved me as well 🙂 So smart to add all of those tabs – that’s been on my to-do list but I’ve been totally swamped! Good luck this school year! You’ll rock it!
I am using my summer brain to re-read this post. LOVE caseload form. Will try come August.
I am an OT but am very excited to tweak these to fit my needs. Thank you for sharing. I have noticed that under the IEP due date the shaded box is not changing, regardless if the date exceeds the 3 month mark. I am not tech savvy, do you happen to have any pointers?
I’ll try to look into that sometime but for now, I’d recommend Googling for “conditional formatting Google Sheets” and see if anything is helpful!
This is great! Thank you for sharing. I just recently switched to the schools after working with adults for two years. For your data plans/data template do you use it to add information for 4-5 students? Most of my groups are 4-5. I love that template but feel like there would be A LOT of information in there
If you wanted to, it would be really easy to expand it to two pages. I use this format with larger groups of 4-5 but I abbreviate the goals and ton and tend to write in the margins! Hope that helps!
I used this last year and have already gotten the upcoming year all set up! All your tips and tricks are SO helpful! I’ve been an SLP-A the past two years, while going to grad school, and I am DONE August 2nd, 2019 (only a 2 weeks and 1 day left!!). You have truly helped me during this process, from your products on tpt to your blog posts. Thank you from Texas!
I know this post is a few years old, but I just discovered it from a recent email you sent out and this is AMAZING. Seriously, I cannot thank you enough for sharing those templates. I’m about to start my CF and have just been anxious about figuring out a good system for organization, and after copying your templates to my Drive I feel so much more at ease about getting started! Please know you make a serious difference in the lives of other SLPs. Thank you so much!
Thank you so much! This is awesome!
It’s been another school year…. are you still using this set up? Are there things you might change/have changed to suit you or do more? I love this…
I’m debating slptoolkit combined with this(plus google calendar and a project management software like asana to keep things rolling with my SLPA)…. is it cumbersome having multiple places to keep things? I’m wondering about “upkeep” of various systems.
I used slptoolkit for the first time this past year and it was pretty great. I don’t love spending the $$, but it really worked for me.
I have a coworker who made Google forms to track all the data and then made QR codes to scan for each student. It seemed like a cool idea.
I use Asana for collaborative projects that involve more than one person and it was great.
I try to streamline how many places I keep things, but find that there isn’t anything that does everything well. Anything is a little hard at first, but once it becomes routine, you’ll love the efficiency.
Hi Shannon! Thanks so much for all of your hard work in creating these templates! I am very excited to try them out this year, however when I try to make a copy in Google Drive, I get an error message saying it’s no longer available. Am I doing something wrong?
Hi! I’m sorry about that. I replaced the link with an updated one. Could you try again? Feel free to reach out at help @ speechymusings.com if it doesn’t work again for you!