Help center

    Start for free    Sign in search

      Get Started Add Content Billing FAQs

      Import JSON files

      Thy Nguyen

      Updated on March 19th, 2024

      Table of Contents

      One of the advantages that Gridly has is the ability to work with JSON files. You can import and export JSON files to Gridly, and start translating JSON files with ease.

      Understand JSON import mode

      In Gridly, you can select the JSON import mode depending on the structure of your JSON file. There are 2 import modes: 

      JSON to records

      Map JSON properties to records in Grid. Select this mode when you have a JSON file that contains only strings that need to be translated and other additional information such as record ID, character limit, etc.  

       

      Note

      In Other information (optional) section, the keys are available only if the objects are nested inside an array. For example: 

      {
        "main": [
          {
            "id": "accept",
            "name": "Accept",
            "character limit": "5",
            "note": "title"
          }
        ]
      }
       

      JSON to columns

      Map JSON properties to columns in Grid. Select this mode when you want to import a JSON file with multiple properties such as Source language, Target languages, etc. 

      Supported JSON structures

      Flat JSON

      JSON import mode: JSON to records

       {
        "main.apply": "Apply",
        "main.accept": "Accept"
      }

      Nested JSON

      JSON import mode: JSON to records

      {
        "main": {
          "apply": "Apply",
          "accept": "Accept",
          "app": "Gridly"
        }
      }

      Structured JSON 

      JSON import mode: JSON to columns

      {
          "main_homepage": {
              "translation": "Homepage",
              "notes": "Title for main menu",
              "tags": [ "main", "important" ]
          },
          "main_about": {
              "translation": "About us",
              "notes": "Title for main menu",
              "limit": 20
          },
          "main_testkey": {
              "translation": "First level key"
      }

      Import JSON file to Grid

      1. On the project page, click +Add Grid
      2. Select Import data from the dropdown menu.
      3. Add the JSON file you want to import to Gridly 
      4. Select import mode: you can select JSON to records or JSON to columns. image5.png

      Import JSON to records

      1. JSON import mode: Select JSON to records.
      2. Strings to be translated: Select the strings that you want to import to Gridly. All keys are selected by default. Uncheck to deselect the strings you do not wish to import. 
      3. Other information (optional): select key that match the following columns: 
        • Object ID: Map the object ID with the Record ID column in Gridly. By mapping, you’ll be able to re-import the JSON file with updated strings.
        • Additional information: Select key that contains note, context, etc.
        • Character limit. 
      4. Click Next. image2.png
      5. Name your Grid, select your project type, source language and target languages.
      6. Click Create.  image1.png

      Here’s the result:

      image4.png

      Import JSON to columns

      1. JSON import mode: Select JSON to columns. 
      2. Strings to be translated: Select the strings that you want to import to Gridly. All keys are selected by default. Uncheck to deselect the strings you do not wish to import. 
      3. Mapping column: Set up the proper column types for your columns.
      4. Click Create. image7.png

      Here’s the result:

      image6.png

      Now you've successfully import JSON data to Gridly. To learn how to work with JSON files in Gridly, please refer to this article: Working with JSON files in Gridly.

      Was this article helpful?


      3 out of 3 found this helpful

      Still need some help?

      Contact Support