Skip to main content

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 nodes share common attributes. For example, in the table below, the key corner-radius would return a value of 10.

KeyValue
corner-radius10

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#

tip

Example workflow:

  1. Create a Rectangle.
  2. Right click in the Assets Window and select Import Google Sheet...
  3. Paste in this url - https://docs.google.com/spreadsheets/d/1DB4Yv0W_sT1nIlKiQFUBeQyXZoz88tdQt8YvLzXYwbU/edit?usp=sharing
  4. Create a Spreadsheet Lookup.
  5. Drag the Google Sheet from the Assets Window to the File attribute on the Spreadsheet Lookup.
  6. Select the Key column for Lookup Column.
  7. Select the Value column for Value Column.
  8. Enter corner-radius in the Lookup Key.
  9. Connect spreadsheetLookup.id > rectangle.cornerRadius.
info

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.