Pull Bible verses into Microsoft Excel

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

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: 

http://www.youtube.com/watch?v=7sZRcaaAVbg

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?

Thanks,

Torrey

Posts 1234
LogosEmployee
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
Faithlife

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:
http://api.biblia.com/v1/bible/content/LEB.html?passage=John3&style=fullyFormatted&key=fd37d8f28e95d3be8cb4fbc37e15e18e

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:
http://api.biblia.com/v1/bible/find.xml?key=fd37d8f28e95d3be8cb4fbc37e15e18e

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

Posts 1234
LogosEmployee
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
Faithlife

Page 1 of 1 (4 items) | RSS
Copyright 1992-2015 Faithlife / Logos Bible Software.