Create Vocabulary with Google Spreadsheets

Create Vocabulary with 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.
  1. Click on the link to access Google Spreadsheets.
  1. (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.
    1. notion image
      notion image
  1. Enter the field name in the first row. Then, just enter the value corresponding to the field.
    1. 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
      • Enter English alphabet letters only (e.g. W, M)
      • Optional items can be omitted other than the required items Word(W) & Meaning(M)
      • (Coming soon) In v4.5.8 and later, the app will also recognize the letter in parentheses at the end, like Word(W).
      For Multiple input items, comma(,) is used as a separator between input values by default, but other symbols can be used.
       
      notion image
      • Required
        • Words (W) / Single Input
        • Meaning (M) / Multiple Input
      • Optional (Can be omitted)
        • Gender (G) / Multiple Input (v4.5.7+)
        • Pronunciation (P) / Multiple Input
        • Part-Of-Speech (POS) / Multiple Input
        • Example Sentence (E) / Multiple Input (v4.5.4+)
          • How to use the Example Sentence field
            Each example consists of two sentences: the Original and the Translation.
            notion image
            • Original : By default, it is read in the language set in the Word input field.
            • Translation : By default, it is read in the language set in the Meaning input field.
            • When using a comma (,) as a separator, odd-numbered inputs are treated as the Original, and even-numbered inputs are treated as the Translation, as shown below:
              • Input : Nice to see you,만나서 반가워요,Hello,,반갑습니다
              • Output
                • notion image
            • If you want to enter only the Original, add an empty comma as shown below:
              • Input : Nice to see you,,You look very nice,,
              • Output
                • notion image
        • Derivative (DER) / Multiple Input (v4.5.7+)
        • Similar (SIM) / Multiple Input (v4.5.7+)
        • 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
          • Increase by 1 second from now
            =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.

How to Load in App

Method 1) Load as CSV File

  1. When you're done editing, choose File → Downloads → Comma-separated values (.csv, current sheet) to save as CSV.
    1. notion image
  1. Please refer to the link below for information on how to load CSV files into the app.

Method 2) Import using Google Spreadsheets

💡
This is a feature supported in versions 4.1.0 and above.
  1. Vocabulary Management → Load Vocabulary → Select Import from Google Spreadsheet
    1. notion image
  1. After logging in with your Google account, please allow Google Drive and Google Sheets permissions.
    1. Why Google Drive Access Permission Is Required


      To load a vocabulary list created in Google Sheets and stored in Google Drive, the app requires access permission.
      notion image
       
  1. You can create a vocabulary book by selecting a spreadsheet file.
    1. It can only be loaded if the spreadsheet file format is correct.
      It can only be loaded if the spreadsheet file format is correct.