Once you've connected Atlan with Microsoft Excel, you can import the column metadata for all your data assets in Atlan and make changes to them directly in Microsoft Excel.
Atlan currently supports importing and updating column metadata for the following asset types:
- Tables
- Views
- Materialized views
- Looker explores
- Microsoft Power BI tables
- Salesforce objects
- Tableau data sources
Import column metadata
You can import column metadata for your data assets directly into Microsoft Excel.
To import column metadata for your data assets to Microsoft Excel:
- In the menu bar of your Microsoft Excel workbook, click Atlan.
- From the Atlan tab, click Enrich metadata to view a list of your data assets in a sidebar.
- (Optional) To filter your assets by a specific asset type, in the Atlan sidebar, click the asset type — for example, Tableau Datasources.
- In the Atlan sidebar on your worksheet, you can either:
- Individually select the data asset(s) you want to import.
- To the left of the Import button, click the Select All checkbox to select all the assets that have loaded in the sidebar. (Optional) Scroll down and click Load more to load more assets in the sidebar.
- Click Import to import column metadata for your selected assets.
The column metadata for your selected assets are now available in Microsoft Excel! 🎉
Update column metadata
Once you've imported your data assets from Atlan, you can edit the metadata for your selected data asset in Microsoft Excel. You can make changes to the column metadata once all the columns have been successfully imported.
You can only make changes to the metadata in the following columns:
- Description
- Certification Status
- Certification Message
- Announcement Type
- Announcement Title
- Announcement Message
- Tags
You cannot make the following changes:
- Edit headers for any of the columns
- Edit the metadata in the Column Name, Data Type, Propagated Tags, and Qualified Name columns
- Delete any columns or rows
Any of these changes will not be pushed to Atlan and you'll receive an error message.
Bulk update tags for columns
Navigate to the Tags column to add tags to your column assets in Microsoft Excel:
When adding tags to columns:
- The tag must already exist in Atlan. If the tag does not exist in Atlan, updates will not sync and you will receive an error message.
- Tag match is case-sensitive, ensure that the tag is formatted exactly as it exists in Atlan. For example, if the tag in Atlan is formatted as
Marketing Analysis
, then columns tagged withmarketing analysis
will not sync. - You can add multiple tags in the Tags column — separate multiple tags with a comma
,
. - If you have added tags that exist in Atlan as well as ones that do not, only the existing tags will be synced. The unsupported tags will not sync and you will receive an error message.
- Tag propagation is disabled by default in Atlan, hence tags will not be propagated.
Push your changes to Atlan
Once you've made changes to the column metadata, to push your changes:
- In the menu bar of your Microsoft Excel workbook, click Atlan.
- From the Atlan tab, click Sync to Atlan.
- The Atlan sidebar will appear once the changes have synced.
- (Optional) Click Open in Atlan to verify the changes.
- In Atlan, an Updated using Microsoft Excel stamp will appear in the activity log for updated assets. (Optional) Click the Microsoft Excel link to view the source spreadsheet from Atlan.