Skip to content

Instantly share code, notes, and snippets.

@omikun
Last active March 28, 2018 18:48
Show Gist options
  • Save omikun/d903d93503324fb3a0763aa1ac707655 to your computer and use it in GitHub Desktop.
Save omikun/d903d93503324fb3a0763aa1ac707655 to your computer and use it in GitHub Desktop.
Export csv to Anki flash cards
Open csv in Excel, save as Unicode Text
THEN format into CSV (use vi or something) by converting all tabs to comma
DO NOT save as CSV from excel, as this will turn korean characters into ??
Also DO NOT try saving as CSV directly from VS Code, it won't survive conversion to utf8
Make sure csv is indeed using commas as delimiters and not tabs or anything else
Convert file to utf8:
In powershell: Get-Content .\test.txt | Set-Content -Encoding utf8 test-utf8.txt
Add deck or make sure desired deck is selected in Anki, then import file and you're done!!
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment