In this article:

• Understand JSON import mode
• Import JSON file to Grid
  • Import JSON to records
  • Import JSON to columns

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. For other import options, please view these articles:

• Import PO files
• Import CSV/XLSX files
• Import data from Google Sheets

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: 

1. 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. 
2. 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.

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.

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.
5. Name your Grid, select your project type, source language and target languages.
6. Click Create. 

Here’s the result:

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.

Here’s the result:

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.