Hi i want to export the vocabulary i learnt so far in an excel file to revise them. Is there any way to do this. I do not know how to code so kindly explain in details.
2 Likes
-
Use WKstats
-
Put in an API key to login. You can generate that in your WK settings
-
Go to WK items. Directly link here: wkstats
-
Filter to un-select kanji, radicals, and Lesson and Locked (unlearned) items
-
Highlight to copy
When I do this, it comes out as a comma-separated line. For my purposes that’s enough.
If you want them on separate lines, you can
:
- Use notepad++ (it’s an application you can download, just google it)
- Ctrl+H to go to the replace screen
- Search for ,
- To be clear the instruction above doesn’t have a typo. I’m saying to search for the comma.
- For replace write \r\n
- Make sure wrap around is selected in the options
- Make sure regular expressions in selected in the options (that’s what allow \r\n to make a new line)
- Click to Replace All
4 Likes
Or use the Item Inspector script.
3 Likes
I included ‘Locked’ to get the entire list of vocab, copied everything and dumped it into Excel and Notepad, but there are no ‘commas’ that one can search and replace. See below:
I’m guessing that even i pasted it into Notepad++ there would still be no commas. So, how would we get the commas inserted between words at the correct location?
Ooops, upon rereading your post, what do you mean by a ‘comma-separated line’? In my case, all the vocab for each level are separated, but each individual vocab in each level is just one continuous set of characters which would be too burdensome to separate each vocab manually!
It just comes out naturally comma separated for me.
I don’t have access to my computer right now to retest. I normally export upon level up because I add them to JPDB so I typically only do one level at a time, without the English labels.
Edit: just tested on my phone and did 2 levels together and it came out like this:
Level 1 (37 of 80 shown)
Vocabulary (37 of 37 shown)
ふじ山,一,一つ,一人,七,七つ,三,三つ,三人,上,上げる,下,下げる,下さい,九,九つ,二,二つ,二人,人,人口,人工,入り口,入る,八,八つ,力,力いっぱい,十,口,大きい,大きさ,大した,大人,女,山,川
Level 2 (80 of 148 shown)
Vocabulary (80 of 80 shown)
〜円,〜才,おはよう,ホテル,一千,一日,一月,七日,三日,上る,上手,下手,中,中々,丸,丸い,九日,二日,二月,五,五つ,五十,五日,五月,人々,入力,八日,六,六つ,六日,六月,出る,出口,刀,十六,十日,十月,千,千円,右,四,四月,土,夕べ,天,天才,女の子,女子,女王,子,子犬,小さい,左,左右,手,文,日,日本,月,木,本,正しい,正す,水,水中,火,火山,犬,玉,玉ねぎ,王,王女,王子,田,田んぼ,白,白人,目,目玉,立つ
Maybe try a different browser?
1 Like
WOW!!! 
Changed from Brave to Google and got the following! Do you know why only Radicals include the definitions?
Radicals (25 of 25 shown)
亅barb,大big,工construction,十cross,丶drop,入enter,ハfins,一ground,𠂉gun,亠lid,山mountain,口mouth,九nine,人person,力power,勹prison,川river,七seven,丿slide,丨stick,日sun,トtoe,木tree,二two,女woman
Kanji (18 of 18 shown)
一,七,三,上,下,九,二,人,入,八,力,十,口,大,女,山,川,工
Vocabulary (37 of 37 shown)
ふじ山,一,一つ,一人,七,七つ,三,三つ,三人,上,上げる,下,下げる,下さい,九,九つ,二,二つ,二人,人,人口,人工,入り口,入る,八,八つ,力,力いっぱい,十,口,大きい,大きさ,大した,大人,女,山,川
Level 2 (148 of 148 shown)
Radicals (33 of 33 shown)
本book,弓bow,子child,牛cow,土dirt,犬dog,夕evening,目eye,火fire,五five,尸flag,彡hair,手hand,冂head,天heaven,王king,丆leaf,儿legs,中middle,月moon,ナnarwhal,ムprivate,田rice-paddy,小small,立stand,止stop,丁street,刀sword,千thousand,メtreasure,水water,白white,文writing
Kanji (35 of 35 shown)
々,丁,中,丸,五,六,円,出,刀,千,右,四,土,夕,天,子,小,左,手,才,文,日,月,木,本,正,水,火,犬,玉,王,田,白,目,立
Vocabulary (80 of 80 shown)
〜円,〜才,おはよう,ホテル,一千,一日,一月,七日,三日,上る,上手,下手,中,中々,丸,丸い,九日,二日,二月,五,五つ,五十,五日,五月,人々,入力,八日,六,六つ,六日,六月,出る,出口,刀,十六,十日,十月,千,千円,右,四,四月,土,夕べ,天,天才,女の子,女子,女王,子,子犬,小さい,左,左右,手,文,日,日本,月,木,本,正しい,正す,水,水中,火,火山,犬,玉,玉ねぎ,王,王女,王子,田,田んぼ,白,白人,目,目玉,立つ
1 Like
Thank you very much
Thank you very much. I Installed it but is it working?
It may require a little tuning to get it working. Did you look at the posts in the Item Inspector forum thread?
Yes i looked at them