Help with CSV and UTF-8

To create your own flashcard-set you have to create a new Spreadsheet in a Spreadsheet-Application. We recommend to use Google Drive (formerly known as Google Docs) because it’s free, easy and saves your file automatically in UTF-8.

Create your CSV-Set in 3 easy steps:

1: Login or Register to Google Drive and create a new Spreadsheet File.

2: Write your questions in the first column and the answers in the second column. Use a new row for each question/answer-pair.

3: Download your Spreadsheet as CSV-File from Google Drive(File->Download As->Comma Separated Values). Import then the downloaded file into the app.

In the gallery below we made an easy to understand screenshot of each step:

[nggallery id=3]


Question: Can I use an other program as Google Drive to create the CSV-Files?

Answer: Yes, you can do that if your program supports saving spreadsheets as CSV-Files with UTF-8 Encoding. We do not recommend to use Microsoft Excel because you can’t save CSV-Files in UTF-8. Altough it works as long as you don’t have any special chars in your spreadsheet.


Question: Why do I have to save my file with UTF-8 Encoding?

Answer: Microsoft Windows Store Apps can only open files which are encoded in UTF-8.