Editing Language/Multiple-languages/Culture/How-to-make-a-TSV-file
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 4: | Line 4: | ||
The tab-separated values (TSV) file is a simple format for storing data in a tabular structure. | The tab-separated values (TSV) file is a simple format for storing data in a tabular structure. | ||
You may have visited [[Language/Multiple-languages/Culture/Internet-Dictionaries]] as well as [https://tatoeba.org/en/downloads Tatoeba's download page] and want to utilise some downloadable stuff by creating flashcards on [https://apps.ankiweb.net/ Anki] or [https:// | You may have visited [[Language/Multiple-languages/Culture/Internet-Dictionaries]] as well as [https://tatoeba.org/en/downloads Tatoeba's download page] and want to utilise some downloadable stuff by creating flashcards on [https://apps.ankiweb.net/ Anki] or [https://mnemosyne-proj.org/ Mnemosyne]. But it requires too much effort 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? | You may have noticed that both programs have “File -> Import...” option. But they don't support XLS or XLSX files. What should you do? | ||
<span link>Finish this lesson and explore these related pages:</span> [[Language/Multiple-languages/Culture/Unrealistic-War-Films-and-TV-Series|Unrealistic War Films and TV Series]] & [[Language/Multiple-languages/Culture/Elements-of-Traditional-Architectures:-Eastern-Asia|Elements of Traditional Architectures: Eastern Asia]]. | |||
== What is TSV == | == What is TSV == | ||
If you have opened a spreadsheet program (e.g. [https://www.libreoffice.org/ LibreOffice] Calc, [https://www.openoffice.org/ Apache OpenOffice] Calc, [https://www.onlyoffice.com/ ONLYOFFICE] Spreadsheet Editor, [https://www.office.com/ Microsoft Office] Excel) and click on “File -> Save As...”, you can see some other formats to choose from, one of which is “CSV”. | If you have opened a spreadsheet program (e.g. [https://www.libreoffice.org/ LibreOffice] Calc, [https://www.openoffice.org/ Apache OpenOffice] Calc, [https://www.onlyoffice.com/ ONLYOFFICE] Spreadsheet Editor, [https://www.office.com/ Microsoft Office] Excel) and click on “File -> Save As...”, you can see some other formats to choose from, one of which is “CSV”. |