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?
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
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... :)
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.