Sheet Source Data

Board Game Builder uses a spreadsheet as the data source for your card templates. Each row in the sheet becomes one card (or data record), and column headers in the first row become available as data bindings in your template.

Supported data sources

• Google Sheets — a specific sheet inside a Google Spreadsheet.
• CSV files — a CSV file hosted in Google Drive.

Connecting a Google Sheet

1. Open your project and navigate to the Settings (gear icon)
2. Set the SheetFile property to your Google Sheet ID or Drive file
3. Set the SheetId to the specific sheet tab (0 = first tab)
4. The column headers from row 1 are automatically available as data bindings

Connecting a CSV file

1. Open your project and navigate to the Settings (gear icon)
2. For CsvFile, select the CSV file in Google Drive.
3. Optionally set the CsvSeparator if your file uses another separator than comma (,)
4. The column headers from line 1 are automatically available as data bindings

Data binding syntax

With a data source connected you can now reference column data in the card template using the {{ColumnName}} syntax:

Source: "{{CardName}}"

Column names are case-sensitive and must match the header row exactly.

Related

• References
• Templates
• Text element