With Gridly, you can easily import multiple file formats, including CSV files. For other import options, please view these articles:

• Import data from Google Sheets
• Import Excel files
• Import JSON files
• Import PO files 

CMS module

Add a CSV file

1. On the project page, click + Add Grid.
2. Select Import file from the dropdown menu.
3. Open the CSV file you want to import. 

Customize your columns

Select the import mode by toggling Set up translation.

• If you are importing a localization file which contains language columns (English, French, etc). You can continue to set up.
• If you are uploading a non-translate file, which does not contain language columns, like an asset management file, toggle off Set up translation.

Translation Grid: contains language columns

1. Select the project type:
   • Single-step: if you’re translating from a single source language to one or multiple target language(s).
   • Multi-step: if you’re translating from an initial source language to a pivot language and then to target languages. For example: Chinese -> English -> Global languages.
2. Map the columns with the appropriate column types. Gridly will automatically map the columns for you depending on the column name. You can further customize your Grid with these options:
   • Use first row as header.
   • Manually adjust column types.
   • Allow non-unique record IDs, global unique record IDs.
3. Click Create and the Grid is now in your selected database.

Non-translation Grid: does not contain language columns

Similarly, Gridly will automatically map the columns for you depending on the column name. If you need to customize the data, you’ll be able to:

• Use first row as header.
• Manually adjust column types.
• Allow non-unique record IDs, global unique record IDs.

Then, click Create and the Grid is now in your selected database.

TMS module

You can create a Job in the TMS module by importing a CSV file. If you are unfamiliar with the TMS module, refer to this getting started with TMS guide.

1. Open the TMS module and go to the Category in which you want to create the Job.
2. Inside a Category, click Upload file.
3. Select the CSV file you want to upload.
4. Fill in Job details:
   • Job name: Set as file name by default
   • Description
   • Assignee
   • Due date
   • Priority
   • Target languages: Category's target languages will be selected by default
   • CSV - File import settings:
     • Skip headers: Toggle this on to ignore the header row in your CSV file
     • Delimiter
     • Encoding
     • Source language columns: Select an option
       • Import all columns
       • Import specific columns
     • Record data columns: Select this to create Record data columns to offer translation contexts.
     • Rows to import: Select an option
       • Import all row
       • Import specific rows only: Row index starts at 0. You can enter a specific row (e.g. 3) or a range of rows (e.g. 4-8).
5. Job workflow: Select a Job workflow from the list. This workflow will determine the steps and status changes for the Tasks under this Job.
6. Click Next to preview the Grid before importing.
7. Click Complete.
8. Wait for the process to finish. Click Manage job to see the newly created Job.