Spreadsheet Lookup
Lookup values in spreadsheets based on keys.
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.
UI
File - connect a .csv or Google Sheet Asset.
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
Example workflow:
Create a Rectangle.
Right click in the Assets Window and select Import Google Sheet...
Create a Spreadsheet Lookup.
Drag the Google Sheet from the Assets Window 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.Connect spreadsheetLookup.id > rectangle.cornerRadius.
If you change the data in your spreadsheet you'll need to right click on the spreadsheet Asset in the Asset Window and select Reload.
Last updated