Create Vocabulary with Google Spreadsheets

Create Vocabulary with Google Spreadsheets How to Load in App Method 1) Load as CSV File Method 2) Import using Google Spreadsheets

Create Vocabulary with Google Spreadsheets

💡

When you want to register many words at once, you can create a CSV file of the words on your PC and send it to the app.

Click on the link to access Google Spreadsheets.

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

Enter the field name in the first row. Then, just enter the value corresponding to the field.

🐱

Please be sure to specify the field in the first line, as the app will not recognize it if you do not.

The order of fields & case does not matter.

Optional items can be omitted other than the required items Word(W) & Meaning(M)

🐱

Please check the example in the link.

Required

Words (W) / Single Input
Meaning (M) / Multiple Input

Optional (Can be omitted)

Part-Of-Speech (POS) / Multiple Input
Pronunciation (P) / Multiple Input
Synonym (S) / Multiple Input
Antonym (A) / Multiple Input
Description (D) / Multiple Input
Mark (B) / Multiple Input / -1(unfamiliar), 0(unmarked), 1 (familiar)
Image(I) / Multiple Input / Format URL

‣

Calendar Date (C) / Single Input / Format yyyy.MM.dd hh:mm:ss


=TEXT(NOW() + (ROW(A1)-1)/86400 + (YOUR_TIME_ZONE_DIFFERENCE/24), "yyyy.MM.dd hh:mm:ss")

Copying down will increase by 1 second from the current time. For (YOUR_TIME_ZONE_DIFFERENCE/24), you can input your time zone difference. For example, Korea has a 9-hour time difference, so you can input 9/24.

🐱

For Multiple input items, comma(,) is used as a separator between input values by default, but other symbols can be used.

How to Load in App

Method 1) Load as CSV File

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

Please refer to the link below for information on how to load CSV files into the app.

CSV Export & Import

Create your own vocabulary book with VoCat, share it with your friends, and memorize words.

https://vocat.devstory.co.kr/csv-export-import

Method 2) Import using Google Spreadsheets

💡

This is a feature supported in versions 4.1.0 and above.

Vocabulary Management → Load Vocabulary → Select Import from Google Spreadsheet

After logging in with your Google account, please allow Google Drive and Google Sheets permissions. (Permission is required to load Google Sheets files and content.)

The first permission is related to Google data synchronization and has nothing to do with Google Spreadsheet access permission.

You can create a vocabulary book by selecting a spreadsheet file.

💡

It can only be loaded if the spreadsheet file format is correct.