Skip to main content
Help Center

Import CSV/XLSX files

Gridly Product Team
  • Updated

In this article:

With Gridly, you can easily import multiple file formats, including CSV and XLSX (Excel workbook) files. For other import options, please view these articles

Add a CSV/XLSX file

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

Customize your columns

  1. Select the import mode by toggle on/off 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.

image5.gif

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. 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.
  3. Click Create and the Grid is now in your selected database. image6.gif

Note: You need to have at least one source language column in your Translation Grid in order to be able to create it, so make sure you set a column as source language column. For example: image4.gif

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.  image3.png

 

Tips: For a simplified view, you can select the list view icon on the right-hand side.

image1.gif

Related articles