Difference between revisions of "Language/Multiple-languages/Culture/How-to-make-a-TSV-file"
(Created page with "You may have visited Language/Multiple-languages/Culture/Internet-Dictionaries and want to utilise some downloadable stuff, create flashcards on Anki or Mnemosyne. But it...") |
|||
| Line 1: | Line 1: | ||
(under construction) | |||
You may have visited [[Language/Multiple-languages/Culture/Internet-Dictionaries]] and want to utilise some downloadable stuff, create flashcards on Anki or Mnemosyne. But it requires a lot of efforts if you copy-paste entry by entry. If we can use a spreadsheet, things will be much easier. Can we do that? | You may have visited [[Language/Multiple-languages/Culture/Internet-Dictionaries]] and want to utilise some downloadable stuff, create flashcards on Anki or Mnemosyne. But it requires a lot of efforts if you copy-paste entry by entry. If we can use a spreadsheet, things will be much easier. Can we do that? | ||
| Line 11: | Line 13: | ||
No, but its sibling: TSV, is supported. What is it? | No, but its sibling: TSV, is supported. What is it? | ||
“TSV” means “Tab-separated values”. It is similar with | |||
Revision as of 16:30, 26 June 2020
(under construction)
You may have visited Language/Multiple-languages/Culture/Internet-Dictionaries and want to utilise some downloadable stuff, create flashcards on Anki or Mnemosyne. But it requires a lot of efforts if you copy-paste entry by entry. If we can use a spreadsheet, things will be much easier. Can we do that?
You may have noticed that both programs have “File -> Import...” option. But they don't support XLS or XLSX files. What should you do?
If you have opened a spreadsheet program (e.g. LibreOffice Calc, Apache OpenOffice Calc, ONLYOFFICE Spreadsheet Editor, Microsoft Office Excel), and click on “File -> Save As...”, you can see some other formats to choose from, one of which is “CSV”.
“CSV” means “Comma-separated values”. It uses commas to separate columns. If you have a comma in the text, then it uses quotation marks to quote your text, so the comma won't be counted as a column separator. If you have quotation marks in your text, then another pair of quotation marks will be used. This is a CSV file. An example is here: https://github.com/skywind3000/ECDICT/blob/master/ecdict.mini.csv.
You may have realised that such a CSV file doesn't store any styling data. If you save as a CSV file, all the information about fonts, colours, hyperlinks, etc. will be lost. CSV files are lightweight, so when you just need pure data, this format is ideal. Do Anki and Mnemosyne support it?
No, but its sibling: TSV, is supported. What is it?
“TSV” means “Tab-separated values”. It is similar with