Spreadsheet Lookup
Lookup values in spreadsheets based on keys.
Last updated
Was this helpful?
Lookup values in spreadsheets based on keys.
Last updated
Was this helpful?
Lookup values in spreadsheet data based on related text strings (keys). This could be useful, among other things, for creating design systems where many elements share common attributes. For example, in the table below, the key corner-radius
would return a value of 10
.
Key
Value
corner-radius
10
The advantage of using a lookup is that the row can be moved for organisational purposes without losing the link to the value.
File - connect a .csv or Google Sheet .
Lookup Column - select the column in your data to search for a key.
Lookup Key - specify the key (text) to find within the Lookup Column.
Value Column - select the column to match against the Lookup Key.
Example workflow:
Create a Rectangle.
Right click in the and select Import Google Sheet...
Paste in this url -
Create a Spreadsheet Lookup.
Drag the Google Sheet from the to the File attribute on the Spreadsheet Lookup.
Select the Key
column for Lookup Column.
Select the Value
column for Value Column.
Enter corner-radius
in the Lookup Key.
spreadsheetLookup.id > rectangle.cornerRadius.
If you change the data in your spreadsheet you'll need to right click on the spreadsheet Asset in the and select Reload.