If a column contains numeric data, YouTrack imports it into values of a float custom field. Here is the list of rules that YouTrack follows when importing custom fields: The header of the column is recognized as the field name. YouTrack processes each column as a custom field or an issue attribute.

YouTrack does not import comments or attachments from Google Sheets. For details on setting a column type, see Custom field types. YouTrack finds an existing user account or creates a new one for each user value.

Values in columns with the type set to user are processed as users. For more details on processing custom fields, see Importing Custom Fields. YouTrack creates an issue for each row in the spreadsheet.Ĭolumns are processed as custom fields and their values. We recommend using an account with a System Admin role or the Low-level Admin Write permission to run the import. The YouTrack user account you use to run the import should have enough permissions to create all imported entities. If the spreadsheet contains references to entities that do not yet exist in YouTrack, they are created. Import your CSV or XLSX file to a Google spreadsheet first, and then import your data to YouTrack. This option also lets you import data from a CSV or an XLSX file with a Google spreadsheet acting as an intermediary.

It prompts you to enter the link to the Google spreadsheet and the Google API key and lets you map projects in YouTrack to sheets in the Google spreadsheet.

The import from Google Sheets lets you migrate data from spreadsheets in Google to YouTrack.Ī setup wizard navigates you through the import configuration process.

Open csv with google sheets