How to bulk upload terms in the glossary

You can upload multiple terms into a glossary using the bulk upload option:

Download the template

You can access the template online through Google Sheets. An example term is also included in the online template:

• View the template in Google Sheets. (To download the template from within Google Sheets: go to File and then Download and choose your preferred format.)
• Make a copy of the template in Google Sheets. (This requires logging in with a Google account.)

Or to download the glossary bulk terms template from within Atlan:

1. From the left menu, click Glossary.
2. Under All Glossaries, click the glossary you would like to add terms to. (Terms can only be added to an existing Glossary.)
3. To the right of the glossary's name, click the three dot menu, and then click Bulk Upload Terms.
4. In the New Bulk Upload dialog, click Download sample template here.

A file named Glossary Atlan Bulk Terms Template.xlsx downloads. You can edit this file with your existing terms and definitions in Excel or Google.

Populate the template

Populate the downloaded template following the template field structure. You can find the same details below in the comments embedded in the Glossary Atlan Bulk Terms Template.xlsx file.

Column explanations

Term Name

Enter the name of the term under the Term Name column.

• This field is required.
• If a term with the same name already exists in the glossary, it will be updated rather than created.
• If this column is blank, the entire row will be ignored.

Description

Enter the definition of the term in the Description column.

Categories

Enter the categories to which to add the term in the Categories column.

• The categories must already exist in Atlan.
• Separate multiple categories by a comma.
• Use the @ symbol as a separator between parent and child categories, to specify a subcategory.
• If this column is blank, the term will be added directly to the glossary without being placed in any category.

User Owners

Enter the usernames of owners in the User Owners column.

• The user(s) must already exist in Atlan.
• Be sure to omit the @ symbol when adding the username.
• Separate multiple usernames by a comma.

Group Owners

Enter the group names of owners in the Group Owners column.

• The group(s) must already exist in Atlan.
• Separate multiple group names by a comma.

Certification

Enter the certification status in the Certification column.

• The value must be one of Verified, Draft, Deprecated, or No certificate.
• Setting the value to No certificate will remove the certificate status.

Certification Message

Enter any additional information related to the certification in the Certification Message column.

Classifications

Enter any classifications to apply to the term in the Classifications column.

• The classification(s) must already exist in Atlan.
• Separate multiple classifications by a comma.

Example

Following is a simple example of a filled in template, pivoted for readability:

Save as CSV file

Upload the CSV file

To upload your CSV file to Atlan:

1. From the left menu, click Glossary.
2. Under All Glossaries, click the glossary you would like to add terms to. (Terms can only be added to an existing Glossary.)
3. To the right of the glossary's name, click the three dot menu, and then click Bulk Upload Terms.
4. Click Select a CSV file to upload or drag and drop the file into the dialog.
5. Click Start Upload.

Monitor the upload

To track the status of your upload, from the glossary:

1. Open the Upload History tab.
2. If there are errors in your file, you will see a message indicating the upload Needs Attention.
   1. Click the Results CSV to download a copy of the file with notations on what the errors are.
   2. Update your file, save your changes, and upload the edited file following the steps above.
3. If your upload is successful, you will see a message indicating Success.

That's it, your terms are now available in Atlan! 🎉