Tuesday, June 25, 2024
How-tos

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


What to know

  • Kindle’s Vocabulary Builder is a built-in tool on Kindle devices that saves the words that you’ve looked up while reading. 
  • Extracting the words from Kindle’s Vocabulary Builder will require you to retrieve the vocab.db file on your Kindle by plugging it into your PC and searching for vocab.db. 
  • The vocab.db file can then be used to extract the words using either SQLite command line tool and database browser, or the Anki FluentCards website. Refer to the guide below for step-by-step instructions. 

Kindle’s Vocabulary Builder is a great built-in tool that automatically saves all the difficult words you’ve looked up while reading. But if you want to extract this list of words, Kindle will only disappoint. There’s no official way for you to view these words outside of your Kindle e-reader device. However, there are a few workarounds by which you can extract the word list from Kindle’s Vocabulary Builder on a PC. Here’s everything you need to know about them.

Kindle stores all the data from its Vocabulary Builder in an SQLite3 database. So, as long as you can access this database, you’ll be able to use the following methods and tools to extract the words from it. Here’s how to do so:

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

Before we begin, you’ll first have to copy the vocab.db file from your Kindle to your PC. Here’s how to go about it:

  1. Connect your Kindle to your PC. 
  2. Open the Kindle directory and go to System > vocab.db. However, since this ‘System’ folder is generally hidden, click in the search field.
  3. And type vocab.db.
  4. Once the vocab.db file is found, copy it.
  5. Now paste it in a convenient location on your PC, such as the desktop. 

Now you’re ready to use the methods given below to extract the words using the vocab.db file. 

Method 1: Export words to Excel using Anki FluentCards  

This is one of the simplest means of extracting words and exporting them as an Excel file. However, with this method, you can only extract words from one book at a time. Here’s how to go about it:

  1. Click and navigate to fluentcards.com. On the webpage, click on Kindle to Anki.
  2. Then drag the vocab.db file copied earlier and drop it on the page.
  3. Your words will automatically be extracted from the vocab.db file and categorized by books from which you looked them up. 
  4. Click on a book to view the words within it.
  5. Here, you’ll find the Words as well as the Context. But the ‘Definition’ column will be blank. To get definitions as well, click on Fetch definitions.
  6. Once the definitions appear for all words, click on Plain CSV to download the list in the CSV format.
  7. Click on Download your deck.
  8. Choose a location and click Save.
  9. The file will be downloaded in the TSV format. 
  10. Open Excel and open a Blank workbook.
  11. Under the ‘Data’ tab, click on Get Data > From File > From Text/CSV.
  12. Change the file format to All Files.
  13. Select the TSV file and click Import.
  14. In Excel’s pop up window, click Load.
  15. Your word list will now be available in the Excel sheet alongside its usage and definition.
  16. Repeat steps 4-15 for all the books to get a list of all the words from your vocabulary database file. 

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

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

  1. Use the link above to download and install the DB Browser for SQLite. 
  2. Once installed, right-click the vocab.db file and select Open with > Choose another app.
  3. Select Choose an app on your PC.
  4. Open the DB Browser for SQLite folder.
  5. And select DB Browser for SQLite.exe
  6. Once the database opens in the app, click on the Execute SQL tab.
  7. Click on the first line to select it.
  8. Here, copy and paste the following SQL code:
    SELECT
    w.word
    ,group_concat(l.usage || '(' || b.title || ')
    ' ) as usage
    ,count(l.usage) as count_usage
    ,l.timestamp as last

    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 a list of the ‘Words’ as well as its ‘Usage’ as it appears in Vocabulary Builder. 
  11. You can select the words in the ‘word’ column by holding down the Shift key, then right-clicking and choosing ‘Copy’. 
  12. And paste it wherever you like, such as a text file, a spreadsheet, etc.
  13. Alternatively, you can export the tables as a CSV file. To do so, click on the Save the results view option under the ‘Execute SQL’ tab.
  14. Then select Export to CSV.
  15. Click Save.
  16. And choose a destination. 
  17. The CSV file can now be opened in a spreadsheet app, like Excel. You can make any changes that you like here.

And just like that, you have extracted the words from Kindle’s Vocabulary Builder.

Method 3: Export words as a text file using SQLite3 command line shell

Similar to the previous method, if you prefer using the SQLite command line tool, you can use it to export words to a text file directly. Here’s how to do so:

  1. Use the link given above to download SQLite3 zip file.
  2. Right-click on the zip file and Extract it.
  3. Paste the vocab.db file in the same folder.
  4. Now double-click and launch sqlite3.exe.
  5. If prompted, click More info > Run anyway.
  6. Type the following and press Enter:
    .open vocab.db
  7. Now copy and paste the following:
    .output vocab.txt
    select word from words;
    .exit
  8. If warned, click on Paste anyway.
  9. Press Enter.
  10. The command line will be executed and you’ll have a new vocab.txt file in your SQLite3 folder. 
  11. Open it to find all your Vocabulary Builder words in it.

We hope you were able to extract the words from the Vocabulary Builder list on your Kindle device. Until next time!



READ SOURCE

This website uses cookies. By continuing to use this site, you accept our use of cookies.