<aside> ⚠️ This page has been transferred to the link below. This page is not updated, so please go to the link below.

CSV Export & Import

</aside>

# What is CSV?

• A file that can be used in Excel or Google Spreadsheet, whose name ends in .csv.
• You can create a vocabulary in CSV and send and receive it in the app and on the desktop.

# How to export in-app vocabulary to CSV

1. Press Settings → CSV Export & Import → Export to CSV button in the app.
2. Select the vocabulary you want to export. Vocabulary list are exported in the selected order.
3. If you click the Change Export Settings button, you can make detailed settings for the export method.
4. Click the Export to CSV button to display the system sharing popup.
5. You can select a file or e-mail and send it to yourself or share it with a friend.

# How to create a CSV

Editing in Google Sheets (docs.google.com/spreadsheets), not Excel, will avoid encoding issues.

1. Access Google Sheets(docs.google.com/spreadsheets).

2. (If you do not have a CSV file, go to step 5.) If you have a CSV file, click File → Open → Upload → Choose file from device to upload the file as shown in the image below.

   

   

3. The file will open as shown below.

   

4. In the first row, fill in the fields and enter data corresponding to each column.

   

   • Words (W) / Required
   • Meaning (M) / Required / Multiple Input
   • Part-Of-Speech (POS) / Optional / Multiple Input
   • Pronunciation (P) / Optional / Multiple Input
   • Synonym (S) / Optional / Multiple Input
   • Antonym (A) / Optional / Multiple Input
   • Description (D) / Optional / Multiple Input
   • Mark (B) / Optional / Multiple Input / -1(unfamiliar), 0(unmarked), 1 (familiar)
   • Image(I) / Optional / Multiple Input (Available in v3.1.3 or later)
   • Creation date (C) / Optional / Multiple Input / Format yyyy.MM.dd hh:mm:ss

   <aside> 🐱 If you do not specify fields in the first row as shown below, the app will not recognize it. The order in which the fields are placed and the case of the fields are irrelevant.

   </aside>

   <aside> 🐱 For multiple input items, comma(,) is used as a separator between input values by default, but other symbols can be used.

   </aside>

5. When you're done editing, choose File → Downloads → Comma-separated values (.csv, current sheet) to save as CSV.

   

# How to import CSV into app

1. Please transfer the CSV file to your mobile phone through various methods such as mail, usb, AirDrop, etc.
2. Press Settings → CSV Export & Import → Import CSV button in the app.