Editing Language/Multiple-languages/Culture/Licensed-Free-Databases

Jump to navigation Jump to search

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.

Latest revision Your text
Line 1: Line 1:
<div class="pg_page_title">Licensed-Free Databases Around Languages</div>
[[Category:Free-Resources]]
[[File:best-licensed-free-databases-polyglotclub.jpg|thumb]]
The listed are databases, not applications. That is to say, if you don't know programming, maybe they won't help you so much.
Hi polyglots! 😀
 
➡ On this page we have listed free databases related to languages.
 
* Those mentioned on [[Language/Multiple-languages/Culture/Internet-Dictionaries|Internet Dictionaries]] will not be mentioned again here.
 
* The listed items are data, so if you don't know programming, this page might not be of much help to you.


== Main ==
== Main ==


=== Multiple languages ===
=== Multiple languages ===
====https://www.ethnologue.com/codes/download-code-tables<nowiki/>====
LanguageCodes.tab lists the 7,400+ distinct language identifiers used in the current Ethnologue database.


==== https://dumps.wikimedia.org/ ====
==== https://dumps.wikimedia.org/ ====
Line 21: Line 12:


Wikimedia.
Wikimedia.
==== https://iate.europa.eu/download-iate/ ====
License: https://iate.europa.eu/download-iate/
Some of its users: https://iate.europa.eu/download-iate/
Terminology dictionary of the EU.


==== https://tatoeba.org/eng/downloads/ ====
==== https://tatoeba.org/eng/downloads/ ====
Line 49: Line 47:


Audio books.
Audio books.
==== https://freedict.org/downloads/ ====
License: https://freedict.org/about/
Some of its users: http://aarddict.org/
Dictionaries.


==== http://www.omegawiki.org/Help:Downloading_the_data ====
==== http://www.omegawiki.org/Help:Downloading_the_data ====
Line 56: Line 61:


Dictionaries.
Dictionaries.
==== http://www.xobdo.org/downloads/ ====
License: http://www.xobdo.org/downloads/
Some of its users: http://www.xobdo.org/
Dictionaries for South Asian languages and English.


==== https://ltrc.iiit.ac.in/onlineServices/Dictionaries/Dict_Frame.html ====
==== https://ltrc.iiit.ac.in/onlineServices/Dictionaries/Dict_Frame.html ====
Line 121: Line 133:
Archived Internet content.
Archived Internet content.


==== https://www.fandom.com/ ====
=== American Sign Language ===
License: https://www.fandom.com/licensing
 
==== http://www.asl-lex.org/ ====
License: http://www.asl-lex.org/
 
Lexicon.
 
=== Burmese ===
 
==== https://github.com/saturngod/ornagai-V2 ====
License: https://github.com/saturngod/ornagai-V2/blob/master/License
 
Some of its users: https://www.ornagai.com/#/
 
Dictionary.
 
=== Catalan ===


Fan-made wiki.
==== http://www.catalandictionary.org/en/search/ ====
License: http://www.catalandictionary.org/en/search/
 
Dictionary. Font of license is too small.


=== Chinese ===
=== Chinese ===
==== https://resources.publicense.moe.edu.tw/index.html ====
License: https://resources.publicense.moe.edu.tw/index.html
Some of its users: https://resources.publicense.moe.edu.tw/index.html, https://www.moedict.tw/
Dictionaries of ROC Mandarin Chinese written in ROC Mandarin Chinese.
==== https://cc-cedict.org/editor/editor.php ====
License: https://cc-cedict.org/wiki/
Some of its users: https://www.mdbg.net/chinese/dictionary, https://www.pleco.com/
Mandarin-English dictionary.
==== https://chine.in/mandarin/dictionnaire/CFDICT/ ====
License: https://chine.in/mandarin/dictionnaire/CFDICT/
Some of its users: https://chine.in/, https://www.pleco.com/
Mandarin-French dictionary.
==== http://www.handedict.de/chinesisch_deutsch.php ====
License: http://www.handedict.de/chinesisch_deutsch.php?mode=dl&sid=51394be2b6d9cba75946e929b5477d55
Some of its users: http://www.handedict.de/, https://www.pleco.com/
Mandarin-German dictionary.
==== https://chdict.zydeo.net/en/download/ ====
License: https://chdict.zydeo.net/en/download/
Some of its users: https://chdict.zydeo.net/hu/
Mandarin-Hungarian dictionary.
==== http://cantonese.org/download.html ====
License: http://cantonese.org/download.html
Some of its users: http://cantonese.org/, https://www.pleco.com/
Cantonese-English dictionary.
==== https://twblg.dict.edu.tw/holodict_new/compile1_6_1.jsp ====
License: https://twblg.dict.edu.tw/holodict_new/compile1_6_1.jsp
Some of its users: https://twblg.dict.edu.tw/holodict_new/default.jsp, https://www.moedict.tw/
Taiwanese-Endlish dictionary. It can be requested through email.
==== http://www.taiwanesedictionary.org/ ====
License: http://www.taiwanesedictionary.org/
Taiwanese-English dictionary.


==== http://lingua.mtsu.edu/chinese-computing/ ====
==== http://lingua.mtsu.edu/chinese-computing/ ====
License: http://lingua.mtsu.edu/chinese-computing/copyright.html
License: http://lingua.mtsu.edu/chinese-computing/copyright.html


Character frequency lists.
Frequency lists.
 
==== https://github.com/gwinterstein/Cifu ====
License: https://github.com/gwinterstein/Cifu/blob/master/LICENSE
 
Word frequency list for Yue Chinese.


==== https://www.tanos.co.uk/hsk/ ====
==== https://www.tanos.co.uk/hsk/ ====
Line 148: Line 227:
HSK data.
HSK data.


==== https://zh.wikisource.org/wiki/%E9%80%9A%E7%94%A8%E8%A7%84%E8%8C%83%E6%B1%89%E5%AD%97%E8%A1%A8 ====
=== Esperanto ===
License: https://zh.wikisource.org/wiki/%E9%80%9A%E7%94%A8%E8%A7%84%E8%8C%83%E6%B1%89%E5%AD%97%E8%A1%A8


Frequent characters.
==== http://reta-vortaro.de/tgz/index.html ====
License: http://reta-vortaro.de/tgz/index.html


==== https://zh.wikisource.org/wiki/%E5%B8%B8%E7%94%A8%E5%9C%8B%E5%AD%97%E6%A8%99%E6%BA%96%E5%AD%97%E9%AB%94%E8%A1%A8 ====
Some of its users: http://reta-vortaro.de/, http://www.busydoingnothing.co.uk/prevo/
License: https://zh.wikisource.org/wiki/%E5%B8%B8%E7%94%A8%E5%9C%8B%E5%AD%97%E6%A8%99%E6%BA%96%E5%AD%97%E9%AB%94%E8%A1%A8


Frequent characters.
Dictionary in several languages.


==== http://input.foruto.com/ccc/gongbiu/index.htm ====
==== http://www.denisowski.org/Esperanto/ESPDIC/espdic_readme.html ====
License:  
License: http://www.denisowski.org/Esperanto/ESPDIC/espdic_readme.html


Frequent characters.
Some of its users: http://www.denisowski.org/Esperanto/ESPDIC/espdic_readme.html
 
Dictionary.
 
==== https://komputeko.net/elsxutejo-en.php ====
License: https://komputeko.net/index_en.php
 
Some of its users: https://komputeko.net/index_en.php
 
Computer terminology dictionary.
 
=== German Sign Language ===
 
==== https://signdict.org/ ====
License: https://signdict.org/about
 
Some of its users: https://signdict.org/
 
Dictionary.


=== English ===
=== English ===
Line 179: Line 275:
Dictionary about computing.
Dictionary about computing.


==== https://github.com/tony-mak/Eng-Chi-Dictionary/tree/master/app/src/main/assets/databases ====
==== https://github.com/skywind3000/ECDICT ====
License: https://github.com/tony-mak/Eng-Chi-Dictionary/blob/master/LICENSE
License: https://github.com/skywind3000/ECDICT/blob/master/LICENSE
 
Dictionary.


==== https://github.com/linuxkathirvel/eng2tamildictionary/blob/master/dictionary.json ====
Some of its users: https://github.com/program-in-chinese/webextension_english_chinese_dictionary
License: https://github.com/linuxkathirvel/eng2tamildictionary/blob/master/License.txt


Dictionary.
Dictionary.


==== https://github.com/derekchuank/high-frequency-vocabulary ====
=== German ===
License: https://github.com/derekchuank/high-frequency-vocabulary/blob/master/LICENSE


Dictionary.
==== https://www.openthesaurus.de/about/download/ ====
License: https://www.openthesaurus.de/about/download/


==== https://github.com/kujirahand/EJDict/tree/master/src ====
Some of its users: https://www.openthesaurus.de/about/download/
License: https://github.com/kujirahand/EJDict/blob/master/LICENSE


Dictionary.
Thesaurus.


=== Hindi ===
=== Hindi ===
Line 212: Line 304:
==== https://www.ling.upenn.edu/~kurisuto/germanic/oi_cleasbyvigfusson_about.html ====
==== https://www.ling.upenn.edu/~kurisuto/germanic/oi_cleasbyvigfusson_about.html ====
License: http://lexicon.ff.cuni.cz/txt/oi_cleasbyvigfusson.txt
License: http://lexicon.ff.cuni.cz/txt/oi_cleasbyvigfusson.txt
Dictionary.
=== Interlingua ===
==== http://www.denisowski.org/Interlingua/IEDICT/iedict_readme.html ====
License: http://www.denisowski.org/Interlingua/IEDICT/iedict_readme.html
Some of its users: http://www.denisowski.org/Interlingua/IEDICT/iedict_readme.html


Dictionary.
Dictionary.
Line 221: Line 322:


Spell checker with dictionary.
Spell checker with dictionary.
=== Iranian Persian ===
==== https://github.com/amirshnll/English-Persian-Word-Database ====
License: https://github.com/amirshnll/English-Persian-Word-Database/blob/master/LICENSE
Dictionary.


=== Japanese ===
=== Japanese ===
==== http://www.edrdg.org/wiki/index.php/Main_Page ====
License: https://www.edrdg.org/edrdg/licence.html
Some of its users: https://jisho.org/, https://www.tagaini.net/
Japanese dictionaries.
==== https://www.wadoku.de/wiki/display/WAD/Downloads+und+Links ====
License: https://www.wadoku.de/wiki/pages/viewpage.action?pageId=357
Some of its users: https://www.wadoku.de/
Japanese-German dictionary.


==== https://github.com/KanjiVG/kanjivg/releases/ ====
==== https://github.com/KanjiVG/kanjivg/releases/ ====
Line 230: Line 352:


Kanji strokes.
Kanji strokes.
==== https://joyokanji.info/ ====
License: http://www.bunka.go.jp/bunkacho_homepage/index.html, http://www.mext.go.jp/b_menu/about_link.htm, http://www.moj.go.jp/term.html
Some of its users: https://joyokanji.info/
[http://www.bunka.go.jp/seisaku/bunkashingikai/kokugo/kokugo/kokugo_45/pdf/jouyoukanjihyou_h22.pdf Jōyō Kanji], [http://www.moj.go.jp/content/001131003.pdf Jinmeiyō Kanji], [http://www.mext.go.jp/a_menu/shotou/new-cs/youryou/syo/koku/001.htm Kyōiku Kanji] in a easy-to-copy form.
==== http://dico.fj.free.fr/dico.php ====
License: http://dico.fj.free.fr/copyright.php
Some of its users: http://dico.fj.free.fr/traduction/index.php
Japanese-French dictionary.


==== https://github.com/mifunetoshiro/kanjium ====
==== https://github.com/mifunetoshiro/kanjium ====
Line 241: Line 377:
JLPT data.
JLPT data.


==== https://ja.wiktionary.org/wiki/%E4%BB%98%E9%8C%B2:%E5%B8%B8%E7%94%A8%E6%BC%A2%E5%AD%97%E3%81%AE%E4%B8%80%E8%A6%A7 ====
=== Jeju ===
License: http://www.bunka.go.jp/bunkacho_homepage/index.html
 
==== https://jeju.go.kr/culture/dialect/dictionary.htm ====
License: https://jeju.go.kr/help/policy/copyright.htm
 
Some of its users: https://jeju.go.kr/culture/dialect/dictionary.htm


Frequent characters.
Dictionary.


==== https://ja.wiktionary.org/wiki/Wiktionary:%E4%BA%BA%E5%90%8D%E7%94%A8%E6%BC%A2%E5%AD%97%E3%81%AE%E4%B8%80%E8%A6%A7 ====
=== Klingon ===
License: http://www.moj.go.jp/term.html


Frequent characters for names.
==== http://klingonska.org/dict/dict.zdb ====
License: http://klingonska.org/dict/


==== https://ja.wikipedia.org/wiki/%E5%AD%A6%E5%B9%B4%E5%88%A5%E6%BC%A2%E5%AD%97%E9%85%8D%E5%BD%93%E8%A1%A8 ====
Some of its users: http://klingonska.org/dict/
License: http://www.mext.go.jp/b_menu/about_link.htm


Frequent characters according to school grades.
Dictionary.


=== Korean ===
=== Korean ===
==== https://krdict.korean.go.kr/mainAction ====
License: https://krdict.korean.go.kr/kboardPolicy/copyRightTermsInfo
Some of its users: https://krdict.korean.go.kr/mainAction
Dictionary. Download link is unknown.
==== https://opendict.korean.go.kr/main ====
License: https://opendict.korean.go.kr/service/copyrightPolicy
Some of its users: https://opendict.korean.go.kr/main
Dictionary. Download link is unknown.
==== https://stdict.korean.go.kr/main/main.do ====
License: https://stdict.korean.go.kr/join/copyrightPolicy.do
Some of its users: https://stdict.korean.go.kr/main/main.do
Dictionary. Download link is unknown.
==== https://github.com/garfieldnate/kengdic ====
License: https://github.com/garfieldnate/kengdic
Some if its users: http://www.toktogi.com/
Dictionary.


==== https://github.com/libhangul/libhangul/blob/master/data/hanja/hanja.txt ====
==== https://github.com/libhangul/libhangul/blob/master/data/hanja/hanja.txt ====
Line 269: Line 436:


http://www.suneung.re.kr/boardCnts/fileDown.do?fileSeq=59692112e521efa80d2af27916704082 in a easy-to-copy form.
http://www.suneung.re.kr/boardCnts/fileDown.do?fileSeq=59692112e521efa80d2af27916704082 in a easy-to-copy form.
==== https://www.topik.go.kr/usr/cmm/subLocation.do?menuSeq=2110503&boardSeq=64217 ====
License: https://www.topik.go.kr/usr/cmm/subLocation.do?menuSeq=2110702
Word list of TOPIK.


=== Lithuanian ===
=== Lithuanian ===
Line 282: Line 444:
Spell checker with dictionary.
Spell checker with dictionary.


=== Sanskrit ===
=== Russian ===


==== https://github.com/hemanth/sanskrit-dict/blob/master/dict.js ====
==== https://en.openrussian.org/dictionary ====
License: https://github.com/hemanth/sanskrit-dict/blob/master/license
License: https://en.openrussian.org/dictionary
 
Some of its users: https://en.openrussian.org/


Dictionary.
Dictionary.
Line 297: Line 461:


=== Vietnamese ===
=== Vietnamese ===
==== http://www.informatik.uni-leipzig.de/~duc/Dict/install.html ====
License: http://www.informatik.uni-leipzig.de/~duc/Dict/install.html
Some of its users: https://www.informatik.uni-leipzig.de/~duc/Dict/
Dictionaries in several languages.
There is a page of introduction: https://vi.wiktionary.org/wiki/Wiktionary:Ngu%E1%BB%93n_g%E1%BB%91c/FVDP
==== http://www.denisowski.org/Vietnamese/vnedict_readme.htm ====
License: http://www.denisowski.org/Vietnamese/vnedict_readme.htm
Some of its users: http://www.denisowski.org/Vietnamese/vnedict_readme.htm
Dictionary.


==== https://github.com/duyetdev/vietnamese-wordlist ====
==== https://github.com/duyetdev/vietnamese-wordlist ====
Line 353: Line 533:
National anthems.
National anthems.


== Formats ==
== Sheet formats ==
 
=== Sheet ===
{| class="wikitable"
{| class="wikitable"
!database name with link
!database name
!file name
!file name
!field separator
!field separator
!
!
!field 1
!1<sup>st</sup> field
!field 2
!2<sup>nd</sup> field
!field 3
!3<sup>rd</sup> field
!field 4
!4<sup>th</sup> field
!field 5
!5<sup>th</sup> field
!field 6
!6<sup>th</sup> field
!field 7
!7<sup>th</sup> field
!field 8
!8<sup>th</sup> field
!field 9
!9<sup>th</sup> field
!field 10
!10<sup>th</sup> field
!field 11
!11<sup>th</sup> field
!field 12
!12<sup>th</sup> field
!field 13
|-
! colspan="15" |dictionary
!
!
!
!note
|-
|-
|[https://github.com/tomcumming/tocfl-word-list An ordered and extended TOCFL word-list]
|CC-CEDICT
|tocfl.tsv
|<tab>
|
|Word
|Pinyin
|OtherPinyin
|Level
|First Translation
|Other Translation
|
|
|
|
|
|
|
|-
|[https://cantonese.org/download.html CC-Canto]
|cccanto-webdist.txt
|<space>
|
|Traditional
|Simplified
|[pin1 yin1]
|{jyut6 ping3}
|/English equivalent 1/equivalent 2/
|
|
|
|
|
|
|
|
|-
|[https://cc-cedict.org/editor/editor.php?handler=Download CC-CEDICT]
|cedict_ts.u8
|cedict_ts.u8
|<space>
|<space>
|
!
|Traditional
|word in Traditional Chinese
|Simplified
|word in Simplified Chinese
|[pin1 yin1]
|[pinyin]
|/English equivalent 1/equivalent 2/
|/English meanings/
|
|
|
|
|
|
|
|
|
|-
|[https://chine.in/mandarin/dictionnaire/CFDICT/ CFDICT]
|CFDICT.u8
|<space>
|
|Traditionnel
|Simplifié
|[pin1 yin1]
|/traduction 1/traduction2/
|
|
|
|
Line 449: Line 570:
|
|
|
|
!
|
|
|-
|-
|[https://chdict.zydeo.net/en/download/ CHDICT]
|ESPDIC
|CHDICT.u8
|<space>
|
|
|Tradicionális
|Egyszerűsített
|[pin1 yin1]
|/magyar egyenérték 1/ egyenérték 2
|
|
|
|
|
|
|
|
|
|-
|[https://github.com/skywind3000/ECDICT ECDICT]
|ecdict.csv
|,
|
|word
|phonetic
|definition
|translation
|pos
|collins
|oxford
|tag
|bnc
|frq
|exchange
|detail
|audio
|-
|[https://github.com/amirshnll/English-Persian-Word-Database English Persian Word Database]
|EnglishPersianWordDatabase.xlsx
|
|
|EnglishWord
|PersianWord
|
|
|
|
|
|
|
|
|
|
|
|-
|[http://www.denisowski.org/Esperanto/ESPDIC/espdic_readme.html ESPDIC]
|espdict.txt
| :  
| :  
|
!
|Esperanto
|Esperanto
|English
|English
Line 521: Line 589:
|
|
|
|
!
|
|
|-
|-
|[http://www.handedict.de/chinesisch_deutsch.php?mode=dl&sid=d80e36eefdb05750bd130ae1f322ca09 HanDeDict]
|kengdic
|handedict.u8
|<space>
|
|Traditionel
|Vereinfacht
|[pin1 yin1]
|/deutsche Entsprechung 1 /Entsprechung 2/
|
|
|
|
|
|
|
|
|
|-
|[https://github.com/libhangul/libhangul/tree/master/data/hanja libhangul]
|hanja.txt
|<nowiki>:</nowiki>
|
|Hangul
|Hanja
|note
|
|
|
|
|
|
|
|
|
|
|-
|[http://www.denisowski.org/Interlingua/IEDICT/iedict_readme.html IEDICT]
|iedict.txt
| :
|
|Interlingua
|English
|
|
|
|
|
|
|
|
|
|
|
|-
|[https://www.eki.ee/litsents/vaba/dl.cgi?D=ies Inglise-eesti sõnaraamat]
|eestiinglise.txt
|<tab>
|
|eeste
|inglise
|
|
|
|
|
|
|
|
|
|
|
|-
|[https://www.tanos.co.uk/jlpt/skills/vocab/ JLPT Vocabulary]
|VocabList.N1.doc
VocabList.N2.doc
 
VocabList.N3.doc
 
VocabList.N4.doc
 
VocabList.N5.doc
|
|
|Kanji
|Hiragana
|English
|
|
|
|
|
|
|
|
|
|
|-
|[https://github.com/garfieldnate/kengdic kengdic]
|kengdic_2011.tsv
|kengdic_2011.tsv
|<tab>
|<tab>
|
!
|wordid
|wordid
|word
|word
Line 636: Line 608:
|?
|?
|?
|?
!
|
|
|-
|-
|[http://www.taiwanesedictionary.org/ The Maryknoll Taiwanese-English Dictionary & English-Taiwanese Dictionary 2013 edition]
|ISO 639-3
|Mkdictionary.xls
|iso-639-3_20200130.tab
|<tab>
!
|id
|print name
|inverted name
|
|
|
|Sort
|Taiwanese
|Chinese
|English
|
|
|
|
Line 654: Line 627:
|
|
|
|
!
|
|
|-
|-
|[http://www.denisowski.org/Vietnamese/vnedict_readme.htm VNEDICT]
|libhangul
|vnedict.txt
|hanja.txt
| :  
|<nowiki>:</nowiki>
|
!
|Vietnamese
|Hangul
|English
|Hanja
|
|note
|
|
|
|
Line 672: Line 646:
|
|
|
|
!
|
|
|-
|-
! colspan="15" |word list
|IEDICT
|iedict.txt
| :
!
|Interlingua
|English
|
|
|
|
|-
|[https://www.topik.go.kr/usr/cmm/subLocation.do?menuSeq=2110503&boardSeq=64217 한국어능력시험 어휘목록]
|토픽 어휘 목록_공개 목록.xlsx
|
|
|수준
|어휘
|길잡이말
|품사
|
|
|
|
Line 694: Line 665:
|
|
|
|
!
|
|
|-
|-
|[https://lingua.mtsu.edu/chinese-computing/statistics/index.html 古汉语单字字频: Character frequency list of Classical Chinese]
|VNEDICT
|CharFreq-Classical.xls
|vnedict.txt
|
| :
|
!
|Serial number; 序号
|Vietnamese
|Character; 汉字
|English
|
|
|
|
Line 712: Line 684:
|
|
|
|
!
|
|
|-
|-
|[https://lingua.mtsu.edu/chinese-computing/statistics/index.html 现代汉语单字字频: Character frequency list of Modern Chinese]
|新汉语水平考试（HSK）词汇（2012年修订版）
|CharFreq.txt
|<tab>
|
|Serial number; 序号
|Character; 汉字
|Individual raw frequency; 频率
|Cumulative frequency in percentile; 累计频率
|Pinyin; 拼音
|English translation; 英文翻译
|
|
|
|
|
|
|
|-
|[https://zh.wikisource.org/wiki/%E9%80%9A%E7%94%A8%E8%A7%84%E8%8C%83%E6%B1%89%E5%AD%97%E8%A1%A8 通用规范汉字表]
|
|
|
|编号
|字形
|
|
|
|
|
|
|
|
|
|
|
|-
|[https://zh.wikisource.org/wiki/%E5%B8%B8%E7%94%A8%E5%9C%8B%E5%AD%97%E6%A8%99%E6%BA%96%E5%AD%97%E9%AB%94%E8%A1%A8 常用國字標準字體表]
|
|
|
|流水序
|教育部字號
|Unicode
|常用字
|
|
|
|
|
|
|
|
|
|-
|[http://www.chinesetest.cn/godownload.do 新汉语水平考试（HSK）词汇（2012年修订版）]
|HSK-2012.xls
|HSK-2012.xls
|
|
!
|word（level）
|
|
|单词（等级）
|
|
|
|
Line 783: Line 703:
|
|
|
|
|
!
|
|need to manually divide words according to levels and delete level info
|}
 
==== Manually convert to TSV ====
{| class="wikitable"
!file name
!process (on Linux)
|-
|cccanto-webdist.txt
|
# [https://stackoverflow.com/questions/8206280/delete-all-lines-beginning-with-a-from-a-file Delete lines starting with '#'];
# [https://stackoverflow.com/questions/47010412/replace-first-space-on-each-line-by-a-tab Replace the first ' ' in each line with '\t'];
# Replace the first ' [' in each line with '\t';
# Replace '] {' with '\t';
# Replace '} /' with '\t';
# Replace ' # adapted from cc-cedict' with <nowiki>''</nowiki>;
# Replace '/\n' with '\n';
# Add 'Traditional\tSimplified\tpin1 yin1\tjyut6 ping3\tEnglish equivalent 1/equivalent 2\n' at the beginning;
|-
|cedict_ts.u8
|
# Delete lines starting with '#';
# Replace the first ' ' in each line with '\t';
# Replace the first ' [' in each line with '\t';
# Replace '] /' with '\t';
# Replace '/\n' with '\n';
# Add 'Traditional\tSimplified\tpin1 yin1\tEnglish equivalent 1/equivalent 2\n' at the beginning;
|-
|CharFreq.txt
|
# Delete lines starting with '/';
# [https://stackoverflow.com/questions/15361632/delete-a-column-with-awk-or-sed Delete fields 3, 4];
# Add '序列号\t汉字\t拼音\t英文翻译' at the beginning;
|-
|CharFreq-Classical.xls
|
# Delete the first row;
# Delete fields 3, 4;
# Save as TSV file or save as CSV file and select '<tab>' as field separator;
|-
|CHDICT.u8
|
# Delete lines starting with '#';
# Replace '\n\n' with '\n';
# Replace the first ' ' in each line with '\t';
# Replace the first ' [' in each line with '\t';
# Replace '] /' with '\t';
# Replace '/\n' with '\n';
# Add 'Tradicionális\tEgyszerűsített\tpin1 yin1\tmagyar egyenérték 1/ egyenérték 2\n' at the beginning;
|-
|ecdict.csv
|
# Open with a spreadsheet program;
# Save as TSV file or save as CSV file and select '<tab>' as field separator;
|-
|eestiinglise.txt
|
# Add 'eeste\tinglise\n' at the beginning;
|-
|EnglishPersianWordDatabase.xlsx
|
# Open with a spreadsheet program;
# Save as TSV file or save as CSV file and select '<tab>' as field separator;
|-
|espdict.txt
|
# Delete the line starting with '#';
# Replace ' : ' with '\t';
# Add 'Esperanto\tEnglish\n' at the beginning;
|-
|handedict.u8
|
# Delete lines starting with '#';
# Replace '\n\n' with '\n';
# Replace the first ' ' in each line with '\t';
# Replace the first ' [' in each line with '\t';
# Replace '] /' with '\t';
# Replace '/\n' with '\n';
# Add 'Traditionel\tVereinfacht\tpin1 yin1\tdeutsche Entsprechung 1/Entsprechung 2\n' at the beginning;
|-
|hanja.txt
|
# Delete lines starting with ' #';
# Replace '<nowiki>:</nowiki>' with '\t';
# Add 'Hangul\tHanja\tnote' at the beginning;
|-
|HSK-2012.xls
|
# Open with a spreadsheet program;
# Save as TSV file or save as CSV file and select '<tab>' as field separator;
# Open the new file;
# Replace '（' with '\t';
# Replace '）' with <nowiki>''</nowiki>;
# Add '单词\t等级\n' at the beginning;
|-
|iedict.txt
|
# Delete the line starting with ' #';
# Replace ' : ' with '\t';
# Add 'Interlingua\tEnglish\n' at the beginning;
|-
|kengdic_2011.tsv
|
# Delete fields 1, 3, 5, 6, 7, 8, 9, 11, 12;
# Add 'word\tdef\hanja\n' at the beginning;
|-
|Mkdictionary.xls
|
# Open with a spreadsheet program;
# Save as TSV file or save as CSV file and select '<tab>' as field separator;
|-
|tocfl.tsv
|
# Replace '"\t"' with '\t';
# Replace '"\n"' with '\n';
# Replace the first '"' with <nowiki>''</nowiki>;
# Replace the last '"' with <nowiki>''</nowiki>;
|-
|vnedict.txt
|
# Delete the line starting with '#';
# Replace ' : ' with '\t';
# Add 'Vietnamese\tEnglish\n' at the beginning;
|-
|토픽 어휘 목록_공개 목록.xlsx
|
# Open with a spreadssheet program;
# Save as TSV file or save as CSV file and select '<tab>' as field separator;
# Click on the other tab of sheet;
# Save as TSV file or save as CSV file and select '<tab>' as field separator;
|}
 
=== Others ===
{| class="wikitable"
!database name with link
!format
|-
|[https://freedict.org/downloads/ FreeDict]
|slob
|-
|[http://www.informatik.uni-leipzig.de/~duc/Dict/install.html Free Vietnamese Dictionary Project]
|dict.dz
|-
|[http://www.xobdo.org/downloads/ XOBDO.ORG]
|db
|}
|}
Database format files are to be added later.


[[Category:Free-Resources]]
Open-source programs for viewing databases: https://sqlitebrowser.org/, https://sqlitestudio.pl/, ...
[[Category:Computer-Knowledge]]


==Other Lessons==
Open-source programs for editing databases: https://dbeaver.io/, https://www.pgadmin.org/, http://www.squirrelsql.org/, ...
* [[Language/Multiple-languages/Culture/Wiki-Notice-Board|Wiki Notice Board]]
* [[Language/Multiple-languages/Culture/Cultural-differences-by-country|Cultural differences by country]]
* [[Language/Multiple-languages/Culture/Most-Famous-Non–Contemporary-Artists|Most Famous Non–Contemporary Artists]]
* [[Language/Multiple-languages/Culture/IRFP-in-brief|IRFP in brief]]
* [[Language/Multiple-languages/Culture/Introduction-to-Sci–Tech-Index|Introduction to Sci–Tech Index]]
* [[Language/Multiple-languages/Culture/Online-Specialized-Dictionaries|Online Specialized Dictionaries]]
* [[Language/Multiple-languages/Culture/How-to-contribute-to-wiki-lessons-(FAQ)|How to contribute to wiki lessons (FAQ)]]
* [[Language/Multiple-languages/Culture/Cities-with-the-best-quality-of-life|Cities with the best quality of life]]
* [[Language/Multiple-languages/Culture/Techniques-for-learning-languages|Techniques for learning languages]]
* [[Language/Multiple-languages/Culture/Countries-and-Flag-Emoji-by-Languages|Countries and Flag Emoji by Languages]]
<span links></span>

Please note that all contributions to Polyglot Club WIKI may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see PolyglotClub-WIKI:Copyrights for details). Do not submit copyrighted work without permission!

Cancel Editing help (opens in new window)
Retrieved from "https://polyglotclub.com/wiki/Language/Multiple-languages/Culture/Licensed-Free-Databases"