Tiny Classroom

  • Full Screen
  • Wide Screen
  • Narrow Screen
  • Increase font size
  • Default font size
  • Decrease font size

Import File Formats

Tiny Classroom supports both CSV (comma separated) and TXT (tab delimited) file formats. If you are having trouble importing a file then please email the file to us at This e-mail address is being protected from spambots. You need JavaScript enabled to view it and we will assist.

Simple Format

The simple format is word 'A' followed by a comma or tab, followed by word 'B'. CSV files should use a comma between the words and TXT files should use a tab character between the words. If your word list contains non-latin characters such as Korean Hangeul or Cantonese then be sure to save your file as "Unicode Text".

To define words in the simple format use the following pattern (for tab delimited TXT files replace the comma with a tab):

Language1,Language2

This is the common format used by most mobile and online flash card applications.

An example file in the simple format is shown below.

Red,Rot
Blue,Blau
Green,Grün
Brown,Braun
Silver,Silber

Advanced Format

The advanced format allows for some extra columns to define more information about the word.

To define words in the advanced format use the following pattern (for tab delimited TXT files replace the comma with a tab):

Language1,Language2,Alternate2,IPA,Usage,Definition

"Language1" and "Language2" are the native and foreign language words in the same positions as the simple format.

"Alternate2" is where you can place alternative answers for use in the writing mode.

"IPA", "Usage" and "Definition" can contain whatever additional text your choose.

Groups and Lists

You can configure groups and lists directly in your CSV or TXT files.

To define groups and lists use the following pattern (for tab delimited TXT files replace the comma with a tab).

WordGroup,Name,Description

WordList,Name,Description

"WordGroup" and "WordList" are defined keywords and must appear in the first position exactly as shown.

"Name" and "Description" will contain the name and description of the group or list.

An example CSV file in the advanced format is shown below:

WordGroup,Tutorial,Tiny Classroom tutorial
WordList,Spanish numbers,Sample list of Spanish numbers
One,Uno,,,,
Two,Dos,,,,
Three,Tres,,,,
WordList,German colors,Sample list of German colors
Red,Rot,,,der rote wagen,
Blue,Blau,,,ein blaues auge,
Green,Grün,Grun,,der grüne hut,
WordList,Korean numbers,Sample list of pure Korean numbers
One,하나,hana,hana,
사과 한개 좀 주세요,Please give me one apple.
Two,둘,dul,dul,사과 두개 좀 주세요,
Please give me two apples.
Three,셋,set,set,사과 세개 좀 주세요,Please give me three apples.

Microsoft Excel

Tip: Word lists stored in the CSV file format may not display correctly in Microsoft Excel.

Word lists stored in the tab delimited TXT format can be created or edited in a Microsoft Excel workbook. When using Excel place the words in separate columns as shown in the example below. Be sure to save the worksheet as type "Unicode Text" (this will create a tab delimited file).


A B C D E F
1
WordGroup Tutorial Tiny Classroom Tutorial
2 WordList Spanish numbers Sample list of Spanish numbers
3 One Uno
4 Two Dos
5 Three Tres
6 WordList German colors Sample list of German colors
7 Red Rot der rote wagen

8 Blue Blau ein blaues auge
9 Green Grün Grun der grüne hut
10 WordList Korean numbers Sample list of pure Korean numbers
11 One 하나 hana hana 사과 한개 좀 주세요
Please give me one apple.
12 Two dul dul 사과 두개 좀 주세요
Please give me two apples.
13 Three set set 사과 세개 좀 주세요 Please give me three apples.

Character Encoding

Character encoding is an advanced topic that deals with how computer systems store characters that are not found in the Latin alphabet. If you are working on Microsoft Windows and save your files as "Unicode Text" then you should not have any issues with character encoding. However, for advanced users Tiny Classroom supports the following encoding formats.

  • ANSI
  • UFT-8
  • UTF-16 little-endian
  • UTF-16 big-endian

Tiny Classroom uses a very basic method to attempt to determine the character encoding. This method is suited to importing files created under Microsoft Windows. Files created under other operating systems should still import correctly if saved with UTF-8 encoding. We are still working to improve our support for variations in character encoding so if you have any specific problems or requests then please contact us.

You are here: Word Lists Import File Formats