Knowable Word

Helping ordinary people learn to study the Bible

  • Home
  • About
    • About this Blog
    • Why Should You Read This Blog?
    • This Blog’s Assumptions
    • Guest Posts
    • Privacy Policy
    • Cookie Policy
  • OIA Method
    • Summary
    • Details
    • Examples
      • Context Matters
      • Interpretive Book Overviews
      • Who is Yahweh: Exodus
      • Wise Up: Proverbs 1-9
      • Feeding of 5,000
      • Resurrection of Jesus
  • Small Groups
    • Leading
      • How to Lead a Bible Study
      • How to Train a Bible Study Apprentice
    • Attending
  • Children
  • Resources
  • Contact

Copyright © 2012–2026 DiscipleMakers, except guest articles (copyright author). Used by permission.

You are here: Home / Check it Out / OT Quotes in NT: Excel Version Available

OT Quotes in NT: Excel Version Available

May 27, 2026 By Peter Krol

Years back, I posted a spreadsheet listing every instance where the New Testament directly quotes the Old Testament. I included only direct quotes of OT texts, not allusions or echos of OT language, nor references to OT characters or events.

You can find my analysis of the information here, along with a series of posts highlighting the most quoted books, verses, etc.

This document has always lived as a Google Sheet, available to anyone who finds it on our Resources page. One such person, the keen and studious Matt Kauffenstein, wasn’t happy with Google Sheets. So he took matters into his own hands to convert it into an Excel spreadsheet, which you can now find here.

In addition, Matt improved the sheet with a search feature, so instead of scrolling or using Ctrl-F (Cmd-F on a Mac) to find a particular passage, you can now simply enter the text you want into the search box, and the sheet shows you all the matching results. You can search in this way for an OT text or a NT text.

You can find that improved document here. Both documents will settle down and build themselves a nice little cabin on our Resources page with all the other goodies there.

Thank you very much, Matt, for creating this for us and making it available to our readers!

Print Friendly, PDF & Email
Share or follow:
fb-share-icon
Tweet
Don't Be Embarrassed by the Cursing Psalms

Related Posts

  • What To Do When the NT Quotes the OT

    Mike Leake has some great advice for what we should do when we're reading the…

  • The New Testament Uses the Old Testament

    The apostle Paul provoked an uproar up and down the Roman empire with a simple,…

  • Top 10 OT Books Quoted in NT

    I recently finished a read-through of the Bible, during which I kept track of every…

Filed Under: Check it Out Tagged With: Bible Study, New Testament, Old Testament, Quotes

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Find it here

Have It Delivered

Get new posts by email:

Connect

RSS
Follow by Email
Facebook
Twitter
Follow Me

Learn to Study the Bible

Learn to Lead Bible Studies

Popular Posts

  • Method
    Summary of the OIA Method

    I've argued that everyone has a Bible study method, whether conscious or un...

  • Sample Bible Studies
    Why Elihu is So Mysterious

    At a recent pastor's conference on the book of Job, a leader asked the atte...

  • Proverbs
    Fool #1: The Savior

    Proverbs 6:1-19 describes three kinds of fool. The first fool is the Savior...

  • Sample Bible Studies
    Context Matters: The Parable of the Talents

    Perhaps you've heard that your talents are a gift from God, and that he wan...

  • Proverbs
    Why “Proverbs Aren’t Promises” is Misleading

    Pick up a book with Bible-reading advice, and you'll barely get your nose i...

  • Sample Bible Studies
    Top 10 Titles of Jesus in the Gospels

    What are the most common ways for the Gospel authors to refer to Jesus?

  • Exodus
    What Should We Make of the Massive Repetition of Tabernacle Details in Exodus?

    I used to lead a small group Bible study in my home. And when I proposed we...

  • Sample Bible Studies
    Context Matters: The Ten Commandments

    The Ten Commandments are not rules from a cold and distant judge. They are...

  • Method
    Cómo interpretar: Hacer preguntas

    This is a Spanish translation of a post from our archive. For the original...

  • Sample Bible Studies
    New and Old Garments

    There are parts of the Bible I've read so many times that I'm prone to mist...

Categories

  • About Us (3)
  • Announcements (68)
  • Check it Out (721)
  • Children (16)
  • Exodus (51)
  • Feeding of 5,000 (7)
  • How'd You Do That? (11)
  • Leading (120)
  • Method (318)
  • Proverbs (121)
  • Psalms (78)
  • Resurrection of Jesus (6)
  • Reviews (77)
  • Sample Bible Studies (244)
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are as essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
SAVE & ACCEPT