## Download impacted assets in Microsoft Excel

URL: https://docs.atlan.com/product/integrations/collaboration/spreadsheets/how-tos/download-impacted-assets-in-microsoft-excel

> Once you've [connected Atlan with Microsoft Excel](/product/integrations/collaboration/spreadsheets/how-tos/integrate-atlan-with-microsoft-excel), you can download impacted assets in Microsoft Excel. This can help you assess the downstream impact of any changes made to an upstream asset for [impact analysis](/product/capabilities/lineage/concepts/what-is-lineage#impact-analysis).

Once you've [connected Atlan with Microsoft Excel](https://docs.atlan.com/llms/governance/integrations/integrate-atlan-with-microsoft-excel/llms.txt), you can download impacted assets in Microsoft Excel. This can help you assess the downstream impact of any changes made to an upstream asset for [impact analysis](https://docs.atlan.com/llms/catalog/lineage/what-is-lineage/llms.txt).

:::warning
You need to be logged into your Atlan instance before you can download impacted assets from Atlan in Microsoft Excel. If you do not have the [permission](https://docs.atlan.com/llms/governance/access-control/delegate-administration/llms.txt) to update asset metadata, your changes will neither be pushed to Atlan nor will a request be created for approval - even if you receive a success message in Microsoft Excel. Ensure that you have the requisite permissions to update an asset before pushing your changes. Your user permissions are used to determine the bulk updates you can make to ensure that there is no adverse impact on assets beyond your scope of access.
:::

## Download impacted assets in Microsoft Excel

To import impacted assets in Microsoft Excel:

1. In the menu bar of your Microsoft Excel workbook, click **Atlan**.
2. From the _Atlan_ tab, click **Import Lineage** to open a list of your assets in a sidebar.
3. (Optional) To filter your assets by a specific asset type, in the Atlan sidebar, select the asset type.
4. 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.
5. To select the type of impacted assets you'd like to download, in the Atlan sidebar, from the _Direction_ dropdown:
 - To download downstream assets for [impact analysis](https://docs.atlan.com/llms/catalog/lineage/what-is-lineage/llms.txt), click **Downstream**.
 - To download upstream assets for [root cause analysis](https://docs.atlan.com/llms/catalog/lineage/what-is-lineage/llms.txt), click **Upstream**.
 - To download all impacted assets, click **Both**.
6. To download the impacted assets in Microsoft Excel:
 - Click **Import Lineage** to download all the impacted assets in one sheet. 
 - Click the **vertical three dots** and then click **Import to new sheet** to download the assets in separate sheet tabs.
7. (Optional) Once download is successful, click the asset links in your spreadsheet to view the assets in Atlan.

The impacted assets are now available in Microsoft Excel! 🎉

## Update column metadata for impacted assets

Once you've imported your impacted assets from Atlan, you can edit the column metadata for impacted assets in Microsoft Excel. You can make changes to the column metadata once all the columns have been imported successfully.

You can only make changes to the metadata in the following columns:

- [_Description_](https://docs.atlan.com/llms/catalog/discovery/add-descriptions/llms.txt)
- [_Owner Users_](https://docs.atlan.com/llms/catalog/discovery/add-owners/llms.txt)
- [_Owner Groups_](https://docs.atlan.com/llms/catalog/discovery/add-owners/llms.txt)
- [_Certification Status_](https://docs.atlan.com/llms/catalog/discovery/add-certificates/llms.txt)
- _Certification Message_
- [_Announcement Type_](https://docs.atlan.com/llms/governance/integrations/create-announcements/llms.txt)
- _Announcement Title_
- _Announcement Message_
- _[Tags](https://docs.atlan.com/llms/governance/tags/attach-a-tag/llms.txt)_

You **cannot** make the following changes:

- Edit headers for any of the columns
- Edit the metadata in the following columns:
 - _Source Asset_
 - _Source Asset Connector_
 - _Source Asset Type_
 - _Impacted Asset_
 - _Impacted Asset Connector_
 - _Impacted Asset Type_
 - _Direction_
 - _Terms_
 - _Propagated Tags_
 - _Source URL_
 - _Qualified Name_
 - _Source Asset GUID_
 - _Impacted Asset GUID_
 - _Immediate Upstream_ and _Immediate Downstream_
- Delete any columns or rows

Any of these changes will not be pushed to Atlan and you'll receive an error message.

:::info **Did you know?** 
 When adding tags or owners for impacted assets in Microsoft Excel, the tag or user name for the owner user or group must already exist in Atlan; name match is case-sensitive, format the value exactly as it exists in Atlan; and you can add multiple tags or owners as comma-separated values.

:::

## Push changes to Atlan

Once you've made changes to the column metadata, to push your changes:

1. In the menu bar of your Microsoft Excel workbook, click the **Atlan** tab.
2. From the top left of the _Atlan_ tab, click **Atlan** and then click **Sync to Atlan**.
3. A dialog box will appear once the changes have synced

---