Pull Bible verses into Microsoft Excel

Page 1 of 1 (5 items)
This post has 4 Replies | 3 Followers

Posts 15
Torrey Lewis | Forum Activity | Posted: Mon, Jan 12 2015 8:11 AM

I would like to automate Bible verse lookup in Microsoft Excel.  

The user would input the Bible verse reference into cell A1 and then a VBA function would put the ESV Bible verse cell B1.

My first thought was to pull the verse from a Bible website, using a technique shown here: 


However, I thought there might be an easier way than parsing the downloaded .html.  The .html from biblegateway.com wasn't obvious to me.

Any ideas or suggestions?



Posts 1246
David Mitchell | Forum Activity | Replied: Mon, Jan 12 2015 11:43 AM

The Biblia API will allow you to retrieve individual verses in a variety of formats, and it's likely that at least one of them will be suitable for your needs. More details (and examples) are available in the documentation at api.biblia.com.

David Mitchell
Development Lead

Posts 15
Torrey Lewis | Forum Activity | Replied: Mon, Jan 12 2015 11:58 AM

Thanks David.  

I found an example here that is almost perfect:

However, the example is for the LEB Bible, whereas I need ESV.  The end application is for Bible memorization, thus version is important.  Other resources for the Bible memorization use ESV, so I need this application to match.

The issue I see is that ESV is not listed in the available Bibles:

Any suggestions?  I am hoping I am reading something wrong... :)

Posts 1246
David Mitchell | Forum Activity | Replied: Tue, Jan 13 2015 3:32 PM

You can see our list of available Bibles for the Biblia API here: http://api.biblia.com/docs/Available_Bibles

Typically, if we do not have a Bible, it is because our publisher prohibits the distribution of their content in this format. (in the particular case of the ESV, they have their own API)

Depending on how comfortable you are with text manipulation, you might also consider creating a Passage List in our desktop app and exporting it to a text file.

David Mitchell
Development Lead

Posts 1
jack dooley | Forum Activity | Replied: Mon, Dec 21 2020 2:46 PM


Did you ever figure this out? I am trying to do the exact same thing and have been struggling with how to do it. If you made any headway, I would love to hear from you, it would be a huge huge help to me. 


Page 1 of 1 (5 items) | RSS