How to Extract Words from Kindle’s Vocabulary Builder to PC

What to know

• Kindle’s Vocabulary Builder is a built-in instrument on Kindle units that saves the phrases that you simply’ve regarded up whereas studying. 
• Extracting the phrases from Kindle’s Vocabulary Builder would require you to retrieve the vocab.db file in your Kindle by plugging it into your PC and looking for vocab.db. 
• The vocab.db file can then be used to extract the phrases using both SQLite command line instrument and database browser, or the Anki FluentCards web site. Refer to the information beneath for step-by-step directions. 

Kindle’s Vocabulary Builder is a superb built-in instrument that routinely saves all of the tough phrases you’ve regarded up whereas studying. But if you wish to extract this record of phrases, Kindle will solely disappoint. There’s no official method so that you can view these phrases outdoors of your Kindle e-reader device. However, there are a number of workarounds by which you’ll extract the thesaurus from Kindle’s Vocabulary Builder on a PC. Here’s all the pieces it’s essential learn about them.

Kindle shops all the info from its Vocabulary Builder in an SQLite3 database. So, so long as you possibly can entry this database, you’ll be capable of use the next strategies and instruments to extract the phrases from it. Here’s how to take action:

Pre-requisite: Copy the vocab.db file from Kindle

Before we start, you’ll first have to repeat the vocab.db file out of your Kindle to your PC. Here’s how to go about it:

1. Connect your Kindle to your PC. 
2. Open the Kindle listing and go to System > vocab.db. However, since this ‘System’ folder is mostly hidden, click on within the search area.
   
3. And sort vocab.db.
   
4. Once the vocab.db file is discovered, copy it.
   
5. Now paste it in a handy location in your PC, such because the desktop. 
   

Now you’re prepared to make use of the strategies given beneath to extract the phrases using the vocab.db file. 

Method 1: Export phrases to Excel using Anki FluentCards  

This is among the easiest technique of extracting phrases and exporting them as an Excel file. However, with this methodology, you possibly can solely extract phrases from one e-book at a time. Here’s how to go about it:

1. Click and navigate to fluentcards.com. On the webpage, click on on Kindle to Anki.
   
2. Then drag the vocab.db file copied earlier and drop it on the web page.
   
3. Your phrases will routinely be extracted from the vocab.db file and categorized by books from which you regarded them up. 
4. Click on a e-book to view the phrases inside it.
   
5. Here, you’ll discover the Words in addition to the Context. But the ‘Definition’ column will probably be clean. To get definitions as properly, click on on Fetch definitions.
   
6. Once the definitions seem for all phrases, click on on Plain CSV to obtain the record within the CSV format.
   
7. Click on Download your deck.
   
8. Choose a location and click on Save.
   
9. The file will probably be downloaded within the TSV format. 
10. Open Excel and open a Blank workbook.
    
11. Under the ‘Data’ tab, click on on Get Data > From File > From Text/CSV.
    
12. Change the file format to All Files.
    
13. Select the TSV file and click on Import.
    
14. In Excel’s pop up window, click on Load.
    
15. Your thesaurus will now be out there within the Excel sheet alongside its utilization and definition.
    
16. Repeat steps 4-15 for all of the books to get an inventory of all of the phrases out of your vocabulary database file. 

Method 2: Export phrases to Excel using DB Browser for SQLite

Kindle’s vocab.db file can be opened using the DB Browser for SQLite. 

1. Use the hyperlink above to obtain and set up the DB Browser for SQLite. 
   
2. Once put in, right-click the vocab.db file and choose Open with > Choose one other app.
   
3. Select Choose an app in your PC.
   
4. Open the DB Browser for SQLite folder.
   
5. And choose DB Browser for SQLite.exe
   
6. Once the database opens within the app, click on on the Execute SQL tab.
   
7. Click on the primary line to pick out it.
   
8. Here, copy and paste the next SQL code:
   SELECT
w.word
,group_concat(l.utilization || '(' || b.title || ')
' ) as utilization
,rely(l.utilization) as count_usage
,l.timestamp as final

   FROM
WORDS w

   LEFT JOIN LOOKUPS l
on l.word_key=w.id
LEFT JOIN BOOK_INFO b
on b.guid=l.book_key

   GROUP BY
w.word

   ORDER BY count_usage DESC, l.timestamp DESC

9. Now execute the SQL by clicking on the ‘Play’ icon.
   
10. You will get an inventory of the ‘Words’ in addition to its ‘Usage’ because it seems in Vocabulary Builder. 
    
11. You can choose the phrases within the ‘word’ column by holding down the Shift key, then right-clicking and selecting ‘Copy’. 
    
12. And paste it wherever you want, reminiscent of a textual content file, a spreadsheet, and so forth.
    
13. Alternatively, you possibly can export the tables as a CSV file. To achieve this, click on on the Save the outcomes view choice below the ‘Execute SQL’ tab.
    
14. Then choose Export to CSV.
    
15. Click Save.
    
16. And select a vacation spot. 
    
17. The CSV file can now be opened in a spreadsheet app, like Excel. You could make any modifications that you simply like right here.
    

And similar to that, you’ve got extracted the phrases from Kindle’s Vocabulary Builder.

Method 3: Export phrases as a textual content file using SQLite3 command line shell

Similar to the earlier methodology, should you favor using the SQLite command line instrument, you should utilize it to export phrases to a textual content file instantly. Here’s how to take action:

1. Use the hyperlink given above to obtain SQLite3 zip file.
   
2. Right-click on the zip file and Extract it.
   
3. Paste the vocab.db file in the identical folder.
   
4. Now double-click and launch sqlite3.exe.
   
5. If prompted, click on More data > Run anyway.
   
6. Type the next and press Enter:
   .open vocab.db
   
7. Now copy and paste the next:
   .output vocab.txt
choose word from phrases;
.exit
8. If warned, click on on Paste anyway.
   
9. Press Enter.
   
10. The command line will probably be executed and also you’ll have a brand new vocab.txt file in your SQLite3 folder. 
    
11. Open it to seek out all of your Vocabulary Builder phrases in it.
    

We hope you had been capable of extract the phrases from the Vocabulary Builder record in your Kindle device. Until next time!