# Modify Families in Excel

Smart Browser allows modification of parameter values via Excel. This can help with entering product codes, prices, and any other data by copying it from databases into Excel or by using native Excel functionality to fill in the values quickly.

### Process

To modify any families via Excel, create a modification task for the necessary families ([**Modification task creation**](https://helpdesk.agacad.com/a/solutions/articles/44002407160))**.** In the modification window, add the parameters that need to be modified to the table with the '**Select Parameters**' button:

![](/files/QfZI9ToD0RsUaM2cl5XU)![](/files/I8yu242p9mt8a4TJZAFo)

Once the necessary list is ready, click the 'Export to Excel' button and follow the regular file-saving process. When creating the Excel file, Smart Browser will ask whether you want to open it.

{% hint style="info" %}
*After exporting the Excel file, you may close Smart Browser or Revit altogether. It is not required to keep either of them open.*
{% endhint %}

![](/files/PHOYzYgJJjZ96vmV2rDb)![](/files/rWNQIsIwdrUVe82mlS5V)

![](/files/c7aGqSGqK693PX73LAAA)

In Excel, you can modify only the parameter values of types: Text, Number, Integer, and Yes/No. All the non-modifiable cells will be locked by default. You can use the general Excel functionality to enter data into the unlocked cells. Excel may be sent to multiple people for modifications.

{% hint style="info" %}
Any data entered into previously locked cells will be ignored during the import.

When unprotecting (unlocking) the sheet, errors might occur that will prevent the information from loading back into the Smart Browser.
{% endhint %}

### Color-Coding in Excel

There are 6 colors used in Excel:

<table data-header-hidden><thead><tr><th width="175"></th><th></th></tr></thead><tbody><tr><td><img src="/files/RtCCOg7VMIZ8bjOTxWTy" alt="" data-size="original">  </td><td>Grouping parameter. <mark style="color:red;">Non-editable</mark></td></tr><tr><td><img src="/files/2EKD0eARPaWqGxYRy8IS" alt="" data-size="original"></td><td>Instance parameter. <mark style="color:green;">Editable</mark></td></tr><tr><td><img src="/files/M8fXV0zBIcZS2FS13kMr" alt="" data-size="original"></td><td>Type parameter. <mark style="color:green;">Editable</mark></td></tr><tr><td><img src="/files/FilMylwIzGSSK5xIivmi" alt="" data-size="original"></td><td>Shared parameter. <mark style="color:green;">Editable</mark></td></tr><tr><td><img src="/files/OoOHr0Kf9vkipjEn1ifq" alt="" data-size="original"></td><td>Formula-based parameter. <mark style="color:red;">Non-editable</mark></td></tr><tr><td><img src="/files/UM9IrXjSdySQ6SdIwP4k" alt="" data-size="original"></td><td>Missing parameter. <mark style="color:red;">Non-editable</mark></td></tr></tbody></table>

![](/files/c6AIJl6YYNZvk0Rqdm2E)

After entering the required data, save the modified Excel file. Head back to Revit and open the same 'Modify Families' file from which the Excel was exported. Click 'Import Excel' in the bottom menu, and choose the modified Excel file.

![](/files/Bwxgw5bUsHdw0W1bFJzx)

That will load all the new values to the Modify Families window, and the modification file can be saved, closed, and applied (see [**Run Modifications**](/design-data-management-and-exchange/smart-browser/run-modifications.md))

![](/files/F7lJ033hQWZBDkIqbWt0)

![](/files/rqBcfhwpV9zyzlv6yWJn)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.besmart.software/design-data-management-and-exchange/smart-browser/modify-families-in-excel.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.