This is a tool that takes Japanese words and auto-fills the definition, spelling and difficulty on Google Sheets. The tool obtains information from www.jisho.org.
- Python 3.6 or higher
- Packages:
- oauth2client
- bs4
- gspread
- requests
- Enable Google API interaction on a GSuite account
- Download client_secret.json and place it in the project directory
- Fill the spreadsheet on col 3 with romaji of the words that you wish to be autofilled
- Specify the column range (e.g. start = 0, end = 100) that you want to fill
- Run the following files for different purposes:
- bankfill.py: fills the kanji spelling and definition of the word (first result on jisho.org)
- banktag.py: fills the JLPT rating of the word, and whether or not it has the common word tag
- bankdupe.py: removes duplicated entries in your dictionary