Paste into ExcelUnreadable kanji finder

Search by shape when you do not know the reading

Excel users can find unreadable kanji and paste them into cells

Narrow the results by radical, total stroke count and character structure. Check an enlarged version of a character you found in a PDF or on paper before pasting it into Excel.

Check the character shape

Kanji finder preview
A screen for narrowing kanji results by radical or component and checking an enlarged character
Compare the details of the left and right components when choosing between similar characters.

How to paste into Excel

Select and copy a kanji from the results, then paste it into the destination cell in Excel. To insert it within existing text, enter cell editing mode before pasting.

Try handwriting input for shapes that are hard to describe

Open the handwriting feature in your computer's Japanese input method and draw the character with your mouse. Choose a character from the suggestions and enter it in Excel. How you open this feature depends on your operating system and Japanese input software.

Kanji matching your search

Results update as you change the inputs. Separate components with spaces, as in “木 白”, to find characters containing all of them. Japanese radical names such as “きへん” and “さんずい” are also supported.

Copy the selected kanji into Excel

What to check before using a character

Choosing a result updates the enlarged character at the top of the page and the note available to save. For product names on delivery notes, drawing annotations or names in a list, compare the details with the original before transcribing.

Character shapes depend on your device's fonts. Do not assume variants such as 高 and 髙, or custom characters, are the same character based on appearance alone. This index does not include every kanji or variant.

Your frequently used kanji notebook

Keep characters you have checked so you can select them again when entering the same product names or personal names.

    Exporting an empty notebook saves a template with 楷 as an example and space for your own entries. After exporting, copy characters from the text file and paste them into Excel.

    Search again from your history

    Searches that found results are kept with the newest first. Select a history entry to run that search again.

      Your notebook and history are saved in this browser. Clearing browser storage removes them, so save any characters you need as text. Take care when saving names or other personal information on a shared device.

      Search when you do not know the radical or stroke count

      Enter a shape you recognize, even if you do not know its radical name. For example, search for 榊 with “木 神” or 楷 with “木 白”. You can also enter the kanji itself in the component field to check whether it is included.

      The stroke count is for the whole character. Entering only the strokes in its left component may exclude the character you need. If a printed character is unclear, leave the stroke count blank and choose “Any structure” to search by components alone.

      How this index groups character structures

      “Left-right” covers characters such as 楷 and 請 with components side by side. “Top-bottom” covers characters such as 霜 and 筒 with components stacked vertically. “Enclosure” covers characters such as 閑 and 園 with an enclosing component. For characters such as 木 and 山 that do not fit these groups, choose “Any structure”.

      Where to paste a character in Excel

      1. Choose a kanji result and select “Copy the selected kanji”.
      2. To enter the kanji on its own, select an Excel cell and paste. Use Ctrl+V on Windows or Command+V on Mac.
      3. To add it to existing text, double-click the cell and place the cursor where you want the character before pasting.

      If your browser does not allow copying, select the character in the copy field and use your device's usual copy command. If the pasted character appears as a square, check whether the font used in Excel includes it.

      Finding a character with handwriting input

      On Windows, use the handwriting feature in the Japanese IME Pad. On Mac, use a handwriting-capable input method added to your input sources. Available features depend on your setup. On a smartphone, switch to handwriting input if your Japanese keyboard provides it.

      Included kanji and component index

      Searches cover only the kanji included on this page. Components are indexed as visual clues for finding characters, not as explanations of their origins. Some combinations of strokes and component names are not indexed and may return no results.

      View included characters and supported radical names

      Supported Japanese radical names: きへん, もんがまえ, ごんべん, さんずい, にんべん, てへん, いとへん, かねへん, くさかんむり, たけかんむり, あめかんむり, くにがまえ, しんにょう, りっしんべん, つちへん, おんなへん, ひへん, うまへん, さかなへん, しめすへん, ころもへん, おおがい, やまへん.