MobileRead Forums - View Single Post

morts81 · 09-02-2015, 10:10 AM

Hi everyone, here is my very non-techy solution to exporting Kindle vocab data:

1. Plug in Kindle
2. Go to "[Kindle directory]\system\vocabulary" (e.g. D:\system\vocabulary - copy/paste this into Explorer bar) (normally you only see the "documents" directory, the system directory is invisible)
3. Copy paste vocab.db file
4. Open in Sqlitebrowser (Can download Sqlitebrowser at https://github.com/sqlitebrowser/sqlitebrowser)
5. Export “WORDS” and “LOOKUPS” as a csv
6. Open Excel
7. Import the data from both CSV files using Data-->Get External Data --> From Text
8. In the import wizard change the File_Origin to "65001 : Unicode UTF-8"
9. Change the Delimiter to comma
10. Select where to import to and Finish
11. Manipulate data as required.

09-02-2015, 10:10 AM	#24
morts81 Junior Member Posts: 2 Karma: 10 Join Date: Sep 2015 Device: Kindle Paperwhite	Hi everyone, here is my very non-techy solution to exporting Kindle vocab data: 1. Plug in Kindle 2. Go to "[Kindle directory]\system\vocabulary" (e.g. D:\system\vocabulary - copy/paste this into Explorer bar) (normally you only see the "documents" directory, the system directory is invisible) 3. Copy paste vocab.db file 4. Open in Sqlitebrowser (Can download Sqlitebrowser at https://github.com/sqlitebrowser/sqlitebrowser) 5. Export “WORDS” and “LOOKUPS” as a csv 6. Open Excel 7. Import the data from both CSV files using Data-->Get External Data --> From Text 8. In the import wizard change the File_Origin to "65001 : Unicode UTF-8" 9. Change the Delimiter to comma 10. Select where to import to and Finish 11. Manipulate data as required.