top of page
Writer's pictureHan

How to change Shared Parameter in Excel or Google Sheets

In general, it is not recommended to change the shared parameter file. However, sometimes, we want to challenge Autodesk how far we can do it. Once a shared parameter is created, there is no way to modify it unless you edit it in the text file. That's why I would like to share how to amend shared parameters in Excel or Google Sheets. The shared parameter file is saved as a text file and if you open it, you can see lots of data there. At first, you can see the parameter groups in the shared parameter, and it has the number assigned to each group. After the groups, there are parameters displayed with GUID, name, group, etc. The data is separated by 'Tab' so you need to remember when you open in excel how to separate the data.

Remember!


Shared parameter structure in Revit

  • Data Separator - Tab

  • Understand the Data Structure


PARAM - Parameter GUID - Unique Parameter ID NAME - Parameter Name DATACATEGORY - Parameter Category (Length, Text, Image, etc) GROUP - Parameter Group shown above VISIBLE - Parameter Visibility in Revit DESCRIPTION - Parameter Description USERMODIFIABLE - Whether the parameter can be modified. Built-in vs User parameter (project and shared)

  • 0 is False, 1 is True

  • Try not to edit in the text editor as the structure can be broken

 

How to change the parameter in Excel?


How to change the parameter in Excel

Before opening the *txt file in Excel, file type must be All Files to see the text file. Otherwise, you will not see the text file.


How to change the parameter in Excel

Choose Delimited as the shared parameter files have taps as a delimiter


How to change the parameter in Excel

Select the Tap in the Delimiters and Next (you can see the parameters in data preview)

How to change the parameter in Excel

Leave it as General and Click Finish

How to change the parameter in Excel

Edit the parameters

How to change the parameter in Excel

Once finished editing, Save the file as Text (Tab Delimited) and load the shared parameter to see the changes.


 

How to change the parameter in Google Sheets?


How to change the parameter in Google Sheets

Import the txt file in Google Sheets (Make sure the file is uploaded)


How to change the parameter in Google Sheets

Navigate the text file in My Drive. It will appear in My Drive if the file is uploaded. Select the file and click ‘Select’


How to change the parameter in Google Sheets

Change the Separator type to Tab, and click Import Data


How to change the parameter in Google Sheets

Edit the shared parameter as needed


How to change the parameter in Google Sheets

Once finished editing, Download the file as TSV (Tap Delimited)


How to change the parameter in Google Sheets

Open the TSV file in Notepad and the data structure is same


How to change the parameter in Google Sheets

Save as Text Document and Load the shared parameter to see the changes Be cautious!

  • Do not mess up with the default structure.

  • GUID is a unique ID assigned to each Parameter when it is created. As long as GUID is maintained, Revit will recognise the parameter as the same.

  • If the shared parameters are already added to the project, they won't be affected although the name is changed.

  • Don't change Data Category if it is already added to the family or project.


To Sum up

I would still recommend not to use this unless it is absolutely necessary. I normally use this method to match the existing parameter to the new one. I could replace the GUID in the shared parameter file. For instance, I already have a parameter for tagging, but the client wants to have another parameter for tagging elements. In that case, I would simply change the GUID in my shared parameter so that the tag will recognise mine as the same parameter. Make sure that it should be project-specific.

留言


bottom of page