Kanji database manual

You can use this interactive online Kanji database containing 2136 characters in 4 main ways:

Selecting all Kanji characters from the database that match specified properties.
Looking up the specified properties of a given Kanji character, or group of characters.
Looking up the properties of compound words consisting of two Kanji (= Jukugo) or find Jukugo that contain a specified Kanji character.
Run a SQL query on the database(s).

For your convenience: do not use the <= back button of your browser, use only the menu and the buttons on the pages. By doing so previous choices are preserved from page to page.

If certain data columns are not displayed correctly when importing a CSV file directly in Excel (leading zeros disappear or similar problems): save the file as .txt file instead of .csv. Now import the file manually in Excel, specifying the data format of each column as "Text" in the import wizard to prevent automatic conversion by Excel. In the wizard you can also specify the characters to be used to separate decimals and thousands. In the original data only a decimal point is used.

Select Kanji from database

Proceed as follows:

Click "Show all properties".
Check the properties you are interested in.
Click "Show only selected properties".
If you wish you can specify range(s) for numerical values. Ranges (maximum and minimum values) are shown. If you want an exact match instead of a range, fill in the same number twice. For numbers: use a decimal point, not a comma.
If you wish you can specify search terms for textual properties, case insensitive. Search terms menu:
- Contains: select the Kanji that contain the given searchterm in this property.
- Does not contain: select the Kanji that do not contain te given searchterm in this property.
- Starts with: select the Kanji that contain the given searchterm at the start of a word in this property.
- Matches: select the Kanji that contain exactly this word in this property.
If you check or uncheck properties after filling in ranges and/or searchterms, they will be reset, so always do the checking first!
Feature, not bug: If you specify a range or fill in a search term for a property that is not checked it will be checked automatically when performing the query! If you do not want to include the property, uncheck it and remove the range(s) and/or search term.
Choose by which of the chosen properties the results should be ordered.
Feature, not bug: If you specify a property to order the results by that was not checked, it will be checked automatically when performing the query.
Choose ascending or descending ordering.
Click "Select Kanji", the query will be executed.
The Kanji characters in the database that match your specifications will be shown in a new page. Only the checked properties will be shown, id number and the Kanji character itself are always shown. The performed query is shown in text.
For every Kanji character there is a link provided to look for compound words (Jukugo) that contain the Kanji on a separate page.
If you check the box in the "Jukugo" column, the Jukugo related to the Kanji character are shown on the same page. If you uncheck the box the Jukugo are hidden again.
You can download the results as CSV file by clicking the corresponding button. If your spreadsheet or database program does not correctly import the output, try one of the other value delimiters.
You can also download the results as an XML file. Modern spreadsheet and database programs will normally be able to import it.
Normally it's best to send a BOM (Byte Order Mark) ahead of the CSV or XML file, but you can switch it off by unchecking the option.
If you want to change or refine your query, go back to the first page by clicking the menu button "Select Kanji from database". Do not use the back button of your browser or the backspace key for this purpose because among others the above mentioned automatic checking feature will not work properly.

Utility buttons:

Check all: check all properties at once.
Uncheck all: remove checks from all properties at once.
Reset input: reset ranges, searchterm menus and searchterms to the ones used in your last query. Checks are not reset. However if a range or searchterm is specified, the property will be automatically checked when performing a query.
Erase search terms: remove all ranges and/or search terms at once.

Look up Kanji

Proceed as follows:

Click "Show all properties".
Check the properties you are interested in.
Click "Show only selected properties".
Fill in the Kanji in the text field. You can even past a complete text, the Kanji characters will be filtered out automatically.
Click "Look up", the query will be executed, all non-Kanji characters will be filtered out.
The checked properties of the given Kanji will be shown at the bottom of the page, in the order of appearance in the text field. Doubles will be left out. Only the checked properties will be shown, id number and the Kanji character itself are always shown. The performed query is shown in text.
If you want to display the doubles, check "Show duplicates" and click on the "Look up" button.
For every Kanji character there is a link provided to look for compound words (Jukugo) that contain the Kanji on a separate page.
If you check the box in the "Jukugo" column, the Jukugo related to the Kanji character are shown on the same page. If you uncheck the box the Jukugo are hidden again.
You can download (export) the results as a CSV file by clicking the corresponding button. If your spreadsheet or database program does not correctly import the output, try one of the other value delimiters and export again.
You can also download the results as an XML file. Modern spreadsheet and database programs will normally be able to import it.
Normally it's best to send a BOM (Byte Order Mark) ahead of the CSV or XML file, but you can switch it off by unchecking the option.

Utility buttons:

Check all: check all properties at once.
Uncheck all: remove checks from all properties at once.
Reset input: reset Kanji input field to the characters used in your last query. Checks are not reset.
Erase Kanji: remove all Kanji characters from the input field at once.

Select Jukugo from database

Proceed as follows:

Click "Show all properties".
Check the properties you are interested in.
Click "Show only selected properties".
If you wish you can specify range(s) for numerical values. Ranges (maximum and minimum values) are shown. If you want an exact match instead of a range, fill in the same number twice. For numbers: use a decimal point, not a comma.
If you wish you can specify search terms for textual properties, case insensitive. Search terms menu:
- Contains: select the Jukugo that contain the given searchterm in this property.
- Does not contain: select the Jukugo that do not contain te given searchterm in this property.
- Starts with: select the Jukugo that contain the given searchterm at the start of a word in this property.
- Matches: select the Jukugo that contain exactly this word in this property.
If you check or uncheck properties after filling in ranges and/or searchterms, they will be reset, so always do the checking first!
Feature, not bug: If you specify a range or fill in a search term for a property that is not checked it will be checked automatically when performing the query! If you do not want to include the property, uncheck it and remove the range(s) and/or search term.
Choose by which of the chosen properties the results should be ordered.
Feature, not bug: If you specify a property to order the results by that was not checked, it will be checked automatically when performing the query.
Choose ascending or descending ordering.
Click "Select Jukugo", the query will be executed.
The Jukugo characters in the database that match your specifications will be shown in a new page. Only the checked properties will be shown, id number and the Jukugo character itself are always shown. The performed query is shown in text.
For every Jukugo character there is a link provided to look up the Kanji it consits of, on a separate page.
You can download the results as CSV file by clicking the corresponding button. If your spreadsheet or database program does not correctly import the output, try one of the other value delimiters.
You can also download the results as an XML file. Modern spreadsheet and database programs will normally be able to import it.
Normally it's best to send a BOM (Byte Order Mark) ahead of the CSV or XML file, but you can switch it off by unchecking the option.
If you want to change or refine your query, go back to the first page by clicking the menu button "Select Kanji from database". Do not use the back button of your browser or the backspace key for this purpose because among others the above mentioned automatic checking feature will not work properly.

Utility buttons:

Check all: check all properties at once.
Uncheck all: remove checks from all properties at once.
Reset input: reset ranges, searchterm menus and searchterms to the ones used in your last query. Checks are not reset. However if a range or searchterm is specified, the property will be automatically checked when performing a query.
Erase search terms: remove all ranges and/or search terms at once.

Look up Jukugo

Compound words, consisting of two kanji, are called Jukugo. There is a database of 27950 Jukugo attached to this site.

Fill in one or two kanji in the input field.
Click "Look up", the query will be executed.
The properties of the Jukugo (if it exists) will appear if you filled in 2 characters.
If you filled in only one kanji, the Jukugo containing that character as well as their properties will appear, first the Jukugo with the given Kanji as the first character, followed by the given Kanji as the second character.
For every Jukugo there is a link provided to find the properties of the Kanji characters it contains on a separate page.
You can download (export) the results as a CSV file by clicking the corresponding button. If your spreadsheet or database program does not correctly import the output, try one of the other value delimiters and export again.
You can also download the results as an XML file. Modern spreadsheet and database programs will normally be able to import it.
Normally it's best to send a BOM (Byte Order Mark) ahead of the CSV or XML file, but you can switch it off by unchecking the option.

SQL query

For the database specialists: run any SQL query you like using the Kanji and/or Jukugo databases. This is a very powerful tool. Table and column names can be entered by clicking, to prevent typing errors. Remember to always use backticks around `column names` and 'single' or "double quotes" around strings!

You can download (export) the results as a CSV file by clicking the corresponding button. If your spreadsheet or database program does not correctly import the output, try one of the other value delimiters and export again.
You can also download the results as an XML file. Modern spreadsheet and database programs will normally be able to import it.
Normally it's best to send a BOM (Byte Order Mark) ahead of the CSV or XML file, but you can switch it off by unchecking the option.
For safety reasons some actions are forbidden. For the same reason error reporting is only minimal.