Sheetwell docs
1. Name layers after columns
Put # and a column name anywhere in a layer's name: #title, or Price #price. Matching ignores case, spaces and punctuation, so #home_state finds a column called "Home State". One layer can have several bindings: Badge #status.State #featured.visible.
| Binding | What it sets |
|---|---|
#col | Text layers: the text. Instances: the component property with the same name as the column. Shapes and frames: an image if the value is an image URL or file name, a fill color if it's a color. |
#col.image | Image fill (replaces the layer's image and keeps its crop mode, or adds the image on top of its fills) |
#col.fill, #col.stroke | Color: #FF6600, #F60, #FF660080, rgb(255,102,0), rgba(…) or a few names (white, black, red…) |
#col.visible, #col.hidden | Shows or hides the layer. Empty, 0, false, no, off and hidden count as no; anything else is yes. |
#col.opacity | 0.5, 50% or 50 |
#col.variant | The instance's variant (when it has one variant property) |
#col.Property | Any component property by name: variant (matched loosely, so "sold out" picks "Sold out"), boolean or text |
Columns from nested JSON have dotted names, like #author.name. Sheetwell tries the whole name as a column before reading the part after the last dot as a setting.
2. Load data
- Paste: select cells in Google Sheets, Excel or Numbers including the header row, copy, paste. CSV and JSON text work too.
- File: CSV, TSV or JSON.
- Google Sheets: the normal Share link of a sheet shared as "Anyone with the link can view". The tab in the link (
#gid=…) is the one read; values come as the sheet shows them, so dates and prices keep their formatting. "Publish to web" links don't work; use the Share link. - JSON link: raw.githubusercontent.com, gist.githubusercontent.com or api.npoint.io. A list of objects, a list of lists with a header row, or an object that wraps a list (
{"items": […]}).
3. Images
Image URLs load directly from images.unsplash.com, images.pexels.com, upload.wikimedia.org, res.cloudinary.com, i.imgur.com, avatars.githubusercontent.com, raw.githubusercontent.com and picsum.photos. Figma only lets a plugin contact the sites it lists, so for any other site, upload the image files in the plugin and put their file names (with or without the extension) in your data. A URL whose file name matches an uploaded file uses the upload. data:image/…;base64 values work too. Images must be PNG, JPG or GIF.
4. Fill
- One copy per row: select one frame. It takes row 1 and a copy is made for each other row, next to it on a grid (Per line, Gap), or after it inside an auto layout frame. Select the template or any copy to fill again: the same copies update, new rows get new copies, and copies you moved stay where you put them. Leftover copies are kept unless you tick "Delete copies left over from the last fill".
- Fill selected frames: the selected frames take rows in reading order, left to right and top to bottom.
- Start row and Rows choose a slice of the data (Rows 0 means all). One fill makes up to 500 copies.
- Empty cells clear text by default, or keep what's there. Empty cells never remove images or colors.
- Preview lists every change and problem without touching the file. Fill is one undo step.
Questions: hello@greatwork.company.