Chinese language dictionary for learners with lots of useful information like frequency ranks and percentile (Junda, Giga), Unihan metadata (stroke count), difficulty level (HSK), and suggested learning order based on supported methodologies (Yan, Heisig, and Loach - highly recommended).
Formatted both for casual browsing (or pivoting) and for import to Pleco, the most popular Chinese learning and dictionary app.
Loach, whose method uses a topographic sort on a hierarchy of Chinese radicals -> characters -> words with weights based on frequency (common usage), stroke count, and radicals/chars required to compose the char/word. , download the XLS and export any of the fields or tables you want to TSV, then upload to Pleco as a user dictionary.
To use, download big-table.xlsx and start pivoting!
- To get it into Pleco's dictionary, export the fields you're interested in to a text (.txt) file in TSV format (each word on a new line, each line "[]\t\t" without the quotes and angle brackets.
- Save the text file somewhere that can be accessed by mobile device. iCloud for iPhone or Google Cloud for Android is easiest.
- Go to Pleco and create a new user dictionary.
- Import the text file. (Search for "pleco import user dictionary" for a more detailed guide.)
- Sort the table by the preferred ranking/ordering and apply any interesting filters (e.g. stroke count, HSK level, etc.). Or create a weight score based on all of the rankings/orderings/metadata and sort by that. Alternatively, go to the sheet in the Excel for the specific ordering desired.
- Copy only the words column into a text editing tool like Notepad++.
- Every n lines, create a new line, where n is the preferred number of cards per flashcard set.
- For every set, add a heading in the format "//" without the quotes and angle brackets. Search "Pleco flashcards import" for more information on flashcard format.
- Save this to a text (.txt) file.
- Go to Pleco and manage flashcards.
- Import the text file.