How to connect a card template to an Excel file

What you'll learn

Connect an Excel workbook (.xlsx) to a card template with the Database Wizard, link its columns and photos to card objects, and show the records in Operating mode.

Download the sample files

ZIP, 1.7 MBPhotos/ELF-01.jpg, Photos/ELF-02.jpg, Photos/ELF-03.jpg, Photos/ELF-04.jpg, Photos/ELF-05.jpg, Photos/ELF-06.jpg, Photos/ELF-07.jpg, Photos/ELF-08.jpg, Photos/ELF-09.jpg, Photos/ELF-10.jpg, README.txt, Santa's Workshop Elf Pass.eccs, Santa's Workshop Elf Pass_database.xlsx

Before you start

  • A card template. A template opens in Operating mode; you switch it to Design mode to connect a database. This example uses Santa's Workshop Elf Pass.eccs, a CR80 staff pass that is not yet connected to a database, front and back. On the front, Photo is a picture object and ElfID, FirstName, LastName, Role and Workshop are text objects with a database field source. On the back, QRCode is a QR Code object.

  • An Excel workbook with a header row: column names in row 1, one record per row. This example uses Santa's Workshop Elf Pass_database.xlsx: sheet Records, 10 rows, columns Id, ElfID, FirstName, LastName, Role, Workshop, Photo, QRCode.

  • For photos: a Photos folder next to the template, used as the pictures folder. Each cell of the Photo column holds a file name from that folder: ELF-01.jpg to ELF-10.jpg.

  • Keep the template, the workbook and the Photos folder in the same folder. The data is fictitious.

  • The template, the workbook and the Photos folder are in the sample files ZIP, with a README.txt. Unzip it to keep this layout.

  • Close the workbook in Excel. eMedia Cards needs exclusive access to the file.

  • Starter Edition uses only the first 50 rows of an Excel file. Standard Edition uses all rows.

Elf pass template in Design mode before linking, with the Photo picture object and the FirstName, LastName, Role, Workshop and ElfID field placeholders on the front side, and the objects listed under Layers
The Records sheet of Santa's Workshop Elf Pass_database.xlsx in Excel with the header row Id, ElfID, FirstName, LastName, Role, Workshop, Photo, QRCode and 10 elf records

How to connect an Excel file to a template

  1. Unzip the sample files and open Santa's Workshop Elf Pass.eccs. The template opens in Operating mode, not in Design mode.

    Download the sample files

    ZIP, 1.7 MBPhotos/ELF-01.jpg, Photos/ELF-02.jpg, Photos/ELF-03.jpg, Photos/ELF-04.jpg, Photos/ELF-05.jpg, Photos/ELF-06.jpg, Photos/ELF-07.jpg, Photos/ELF-08.jpg, Photos/ELF-09.jpg, Photos/ELF-10.jpg, README.txt, Santa's Workshop Elf Pass.eccs, Santa's Workshop Elf Pass_database.xlsx

  2. Click View > Design mode. The card layout opens for editing.

  3. Click Tools > Connect to database.... The Database Wizard opens on step 1, Connection.

  4. Under Select a database connection type:, click Excel / CSV.

  5. Click Next. Step 2, Configure Columns, opens.

Database Wizard, Connection step, with Excel / CSV selected under Select a database connection type:
  1. Under Select an Excel / CSV file:, click Browse… and open Santa's Workshop Elf Pass_database.xlsx.

  2. Leave Excel engine: on Auto (ACE then OpenXML).

  3. In Sheet / range:, choose Records. The list shows every sheet of the workbook: pick the one that holds the records. A workbook with one sheet selects it automatically.

  4. Check the Preview (first rows) table. It shows the column names from row 1 and the first rows of the sheet.

  5. In Key column:, choose a column with a unique value in every row (key column). Here: Id.

  6. Click Next. Step 3, Operator Fields, opens.

Configure Columns step with Santa's Workshop Elf Pass_database.xlsx selected, Excel engine: Auto (ACE then OpenXML), Sheet / range: Records, Key column: Id, and the Preview (first rows) table showing the elf records
  1. Operator Fields opens. It sets which fields the operator sees and can change, with an Operator permissions row (Add records, Modify records, Delete records) on by default.

Operator Fields step as it opens, with the Sort, Field, Display and Edit columns for the elf columns and the default settings
  1. Click Next. Step 4, Link & Summary, opens.

Link & Summary step with Total columns: 8, Linked objects: 7, the Photo column linked to the Photo picture object and Id on (none)
  1. Check Connection:, Total columns: and Linked objects:. A column whose name matches a card object is linked automatically: here ElfID, FirstName, LastName, Role, Workshop, Photo and QRCode.

  2. Check that Photo is linked to the Photo picture object. The Linked to list of a photo column shows picture objects only.

  3. Leave Id on (none). A column on (none) is not shown on the card.

  4. Click Connect Data Source.

Show the photos from the Photo column

  1. In Design mode with nothing selected, the Card properties panel is already open on the right.

  2. Under Database pictures folder, in Location, choose Subfolder of this template.

  3. In Subfolder, type Photos. Looks in: shows the folder eMedia Cards uses.

  4. Click File > Save... to save the template with the link and the pictures folder.

Card properties panel with Database pictures folder, Location: Subfolder of this template, Subfolder: Photos and the Looks in: line

eMedia Cards looks for the file named in the Photo cell in this order: the path in the cell, then the Database pictures folder (here Photos), then the pictures folder in Tools > Options, then the template's own folder. A cell can also hold a public https link to a picture.

Show the records

  1. Click View > Operating mode. Connecting does not switch the mode. The card shows the first record of the sheet.

Operating mode with the elf pass of the first record, its photo on the front, the records grid with the 10 elves and Record 1 of 10
Back side of the elf pass in Operating mode with the QR Code built from the QRCode column of the same record

Tips

  • The Excel file stays the live database. Adding, changing or deleting a record in Operating mode writes to the workbook.

  • Keep the template, the workbook and the Photos folder together when you move or copy them. Then the photos and the link still work on another computer.

  • For better portability, use File > Export > As full backup.... It saves the template, the database and the pictures in one portable file. See How to back up a template with Export > As full backup.

Common errors

Symptom Cause Fix
Please select a worksheet. No sheet is chosen in Sheet / range:. Choose the sheet with the records in Sheet / range:.
The Preview (first rows) table shows other columns, or Linked objects: is 0. The wrong sheet is selected. In Sheet / range:, choose Records.
The column names in the preview are data, for example ELF-0001 and Pip. The sheet has no header row. eMedia Cards reads row 1 as the column names. Insert a row 1 with the column names in Excel. Save, close Excel, then click Browse… and select the file again.
The Excel file "Santa's Workshop Elf Pass_database.xlsx" is open in another program, so eMedia Cards can't read it. Close the file in that program, then click Browse… and select it again. The workbook is open in Excel. eMedia Cards needs exclusive access. Close the file in Excel. Click Browse… and select the file again.
The Excel file "Santa's Workshop Elf Pass_database.xlsx" is open in another program or is still syncing, so eMedia Cards can't read its records right now. Close the file in that program, or wait for the sync to finish, then choose Requery. The workbook was opened in Excel after connecting, or a cloud sync is still running. Close the file in Excel or wait for the sync. Click Requery.
The photo frame stays empty in Operating mode. The Photos folder is not next to the template, Database pictures folder points elsewhere, or the file name in the Photo cell does not match a file. Put the Photos folder next to the template. Set Location to Subfolder of this template and Subfolder to Photos. Check the file name and extension in the cell.
The Excel columns linked in this card template no longer match the datasheet. A column header was renamed or removed in Excel after the template was saved. Restore the column name in Excel, or open Tools > Connect to database..., update the link, and save the template.
eMedia Cards cannot find the Excel file linked to this card template. The workbook was moved, renamed or deleted. Put the workbook back next to the template, or open Tools > Connect to database..., choose the file, and save the template.
This database appears to have been created by another tool and may not update reliably through Excel's standard engine. The workbook was saved by another program, not by Excel. Open it in Microsoft Excel, choose Save As (.xlsx), and link it again.

Last reviewed: 2026-11-16