Video Tutorial: Sync merge tags in Figma text layers from a spreadsheet

Merge tag Syntax

CopyDoc uses a simple merge tag syntax: #{columnName}. You can insert these merge tags anywhere in your text layers, and they'll be replaced with values from your spreadsheet.

Example Usage

Figma text layer: Hello #{firstName} #{lastName}, Your order #{orderId} is ready for pickup!

Spreadsheet columns:

firstName	lastName	orderId
John	Smith	12345
Sarah	Johnson	67890

Result after sync:

• "Hello John Smith, Your order 12345 is ready for pickup!"
• "Hello Sarah Johnson, Your order 67890 is ready for pickup!"

Key Benefits

• Preserve formatting: Text styles, fonts, and colors remain intact
• Multiple merge tags: Use as many merge tags as needed in one layer
• Flexible column naming: Works with various column header formats
• Smart fallback: If no matching column is found, the merge tag text is preserved

Column Header Flexibility

CopyDoc is smart about matching column headers. All of these formats work:

• Standard: firstName matches #{firstName}
• With # prefix: #firstName matches #{firstName}
• Full merge tag: #{firstName} matches #{firstName}

Renaming Layers

Along with updating text content, the Sync Spreadsheet Content feature also supports automatically renaming non-text layers. For example, if you have 6 Figma frames all named #My Frame, you can use this as a column name in your spreadsheet and rename them in bulk.

Common Use Cases

• Email templates: Personalize recipient names and details
• Business cards: Generate multiple variations with different contact info
• Marketing materials: Create localized versions with different content
• Data visualizations: Update labels and titles dynamically
• Product catalogs: Batch update product names, prices, and descriptions

Tips

• Add quotes around values with commas in your CSV: "42,580"
• Test with a few layers first before applying to your entire design
• Use meaningful column names to make your spreadsheet easy to understand