Matthias Müller has already given us the Koine Greek audio Bible. Now he's produced another brilliant resource for those interested in biblical languages. It’s an Excel spread sheet of the entire Strong’s concordance.
What’s the point, you might ask, since so many free Bible programs include Strong’s?
The spreadsheet has the following possibilities. You can:
- Sort the entire Greek and Hebrew vocab of the Bible by different criteria
- See at a glance, which words come from which root
- Find out what the Greek equivalent is for a Hebrew word and vice versa
- Sort the vocab by frequency and so easily create your own vocabulary lists for language learning
- See where a word is used the first time
In the future, Matthias hopes to add columns and fill them in - e.g. columns for every biblical book. The whole project could take years but updates will come as Matthias works on it. Keep the link and download it a few times a year to see what has been added. But if you would like to help, fill in the blanks or add functionality just email christisinn which is a gmail address.
Strong's Concordance Download (Dropbox)
UPDATE 25/07/13 Frequency of Hebrew words up to Strong’s #H5000 completed alongside first occurrence.
Also completed “part of speech” columns for all words in both Greek and Hebrew.
Now you can also separate Aramaic words from Hebrew words with the first column.
UPDATE 05/08/13 Now the rest of the Strong’s concordance is updated on frequency and first occurance – both for Greek and Hebrew. Have fun creating vocab lists or doing some analysis of which NT author in the Bible introduces the most new vocabulary.
Make sure to use the filter options in the gloss column: click the little arrow in the cell of the header, then “text filters”, then “contains…” and enter any strong’s number you want to filter out. To get rid of the filter, click the arrow again and then “clear filter from “gloss”"… enjoy
8 thoughts on “Strong’s Goes Excel”
update: frequency of Hebrew words up to Strong's #H5000 completed alongside first occurrence. also completed "part of speech" columns for all words in both Greek and Hebrew. Now you can also separate Aramaic words from Hebrew words with the first column.
Thanks, ever so useful
Great resource, thank you!
I noticed that H7225 appears to be missing the first part (re') in the pronunciation. Is this a problem?
I wonder if you can help me. I am looking for an excel file containing the full list of strong numbers per bible book.
I can copy it number my number- but it takes ages.
If you can help , I will most appreciate
Very nice! Massive amount of work. Thx, brother.
May I have an explanation of each of the columns in the Strong's spreadsheet?
I'm not sure how to read or apply the values in the F column, for example.
Pingback: ¿Dónde puedo encontrar un archivo .csv del Léxico Griego de Strong? - biblia