Converting Lexile Levels to Approximate Fountas & Pinnell Guided Reading Levels Made Easy

Our district has just adopted i-Ready, an online diagnostic and instructional program. For all its great features, it current has teachers go to each individual student’s report to find the student’s Lexile Level. Now I may not be in the classroom this year, but I do know how ridiculous it is to ask teachers to click through so much to find a Lexile Level and then make them find a correlation chart to find out what approximate Fountas & Pinnell Guided Reading Level the student is reading.

So, after a few days of learning about the amazingness of Google Spreadsheets from none other than Alice Keeler, I thought I’d make my own spreadsheet to help teachers out a little, given that I can’t make the i-Ready people create the batch reports we need. I learned a lot about nested if statements and basically was told by Alice and Roni Habib that I need to learn about vLookup, since I used way too many nested if statements. Wanna see?

Nested if statement

Yikes, right? Anyway, I had a lot of fun creating this, and since it might be useful for more people than just the teachers in our district, I thought I’d share it with the world.

Convert your Lexile Levels to Approximate Guided Reading Levels

Please, log in with your Google account and make your own copy, so you can manipulate and save the data. Remember that it’s only an approximate level, but share this with anyone you’d like!

This entry was posted in Reading Workshop and tagged , . Bookmark the permalink.

14 Responses to Converting Lexile Levels to Approximate Fountas & Pinnell Guided Reading Levels Made Easy

  1. Jenna says:

    Do you have a spreadsheet made for RIT scores that will convert to Gudied Reading levels?

  2. Carolyn says:

    Do you have one for below H in F & P levels? This is a great tool.

    • Robert P. says:

      Hi Carolyn,
      Late I know, but no I don’t. For two reasons.. Lexile generally doesn’t go that far down and if they are that low, it’s really important to do a running record to accurately know how to support them.
      Hope that helps,

  3. Looks very useful to share with staff, thanks. Could you reverse engineer this, to generate approx Lexile if my staff know F&P?

  4. Pingback: Daily 07/20/2013 | READINGPOWER

  5. says:

    Hey Community:

    My fiance asked me to make just such a spreadsheet. I used the scale version shared in the above version with a few improvements.

    1. Included an average GR and Lexile score for your entire roster of students.
    2. Included the number of students at each level.
    3. For you formula junkies, I’ve simplified the long conditional formula.

    You can copy and paste this link into your browser navigator to create a copy:



  6. Pingback: My (@pronovost’s) Top 5 Viewed Posts in 2014 #endofyearreview | attempts at using tech effectively in our classrooms

  7. Sarah Addison says:

    It’s worth knowing that Fountas and Pinnell levels do not always match up with the predicted Lexile Level, given the chart and any given text. In other words, two texts that both are listed as level N on F&P levels can have very different Lexile scores. My best-guess-accounting for this discrepancy is that Fountas and Pinnell take into account qualitative measures, while Lexile is not designed to do that. It only counts things that can be quantified, such as sentence length and number of words and word frequency (though I suspect there may be some room for error in that last, since a word can have more than one meaning for a given spelling, and some meanings are more common than others, such as bat (the baseball equipment)/ bat (the animal)/ bat (the verb meaning to take one’s turn at the plate in baseball)/ bat (the more general verb meaning to lightly hit at something, such as “the cat batted the toy off the table”). So there’s that.

  8. kindnessP says:

    Hi can i know your source of the lexile range to the approximate F&P level?

  9. Rachel Koch says:

    Thank you so much for this!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s