ID Card Template

ID Card Template for Mail Merge

A professional ID card template designed for employee badges, student identification, event credentials, and membership cards. Whether you are issuing 50 new hire badges for a growing startup, producing 5,000 student IDs for a university, or printing 10,000 conference credentials for a trade show, this template handles bulk generation with pixel-perfect precision. Each card is personalized with the individual’s photo, name, ID number, department, and a unique QR code or barcode for verification.

When to Use This Template

This template is built for any scenario where you need to produce a large number of ID cards that share a consistent layout but contain unique personal data. Common use cases include:

• Employee ID badges — Generate company ID cards with photos, job titles, department names, and employee numbers for onboarding batches or annual reissues
• Student ID cards — Produce school or university identification cards with student photos, grade levels, student numbers, and academic year validity dates
• Event credentials — Create access badges for conferences, trade shows, and festivals with attendee-specific QR codes for entry verification
• Conference badges — Print personalized attendee badges with names, organizations, roles (speaker, VIP, staff), and scannable codes for session tracking
• Visitor passes — Issue temporary visitor badges with host name, visit date, access level, and an expiration time for security checkpoints
• Membership cards — Generate gym, club, or organization membership cards with member photos, membership IDs, and renewal dates

If you currently design ID cards one at a time in Photoshop or Canva and manually swap out names and photos, this template eliminates that repetitive work entirely.

Template Fields

Card Sizes

Choose the right dimensions for your use case. Set your PDF page size to match the target card before uploading to Mergram.

Field Mapping Guide

Connecting your spreadsheet data to the ID card template is straightforward. Follow these steps for the best results:

1. Prepare your spreadsheet — Each row represents one ID card. Include columns for all ten fields: full_name, employee_id, title_or_role, department, organization, photo, qr_code, issue_date, expiry_date, and barcode_id. Leave optional columns blank for cards that do not need them.
2. Upload your ID card PDF — Design the card layout in Canva, Illustrator, or any design tool and export as PDF. The design should include all static elements: company logo, background graphics, decorative borders, and any fixed text like “EMPLOYEE ID” or “STUDENT IDENTIFICATION.”
3. Place dynamic fields on the canvas — Drag each field from the sidebar onto the PDF at the exact position where the data should appear. Position the photo prominently in the top-left or top-center. Place the full name as the largest text element. Put the employee_id and barcode_id near the bottom edge for easy scanning.
4. Choose the correct render type for each field — Use text for full_name, title_or_role, department, organization, issue_date, and expiry_date. Use the image type for the photo field. Use the QR code type for qr_code and the barcode type for barcode_id.
5. Size the photo field carefully — Create a square or portrait bounding box for the photo. The image fills the width of the bounding box and maintains its aspect ratio, aligned to the top-left corner. For uniform-looking cards, crop all headshots to the same aspect ratio before uploading.
6. Preview before merging — Generate previews with several different rows to verify that photos align correctly, QR codes are scannable, long names fit within the layout, and dates are formatted as expected.

Customization Tips

The visual design of your ID cards is entirely controlled by the PDF template you upload. Mergram overlays dynamic data onto the PDF without altering the underlying design:

• Upload your logo — Embed your company, school, or event logo directly in the PDF template. Place it in the top-left or top-center for maximum visibility
• Custom fonts — Upload .ttf, .otf, or .woff2 fonts to match your brand guidelines. Apply them to the full_name, organization, and department fields for a polished, professional look
• Department-specific color coding — Design different colored borders, stripes, or background panels in the PDF for each department. Create separate templates or use conditional fields to switch colors based on the department column
• QR codes for verification — Map a column with unique URLs (e.g., https://verify.company.com/EMP-0472) or encoded data (vCard, JSON payload) to the QR code field. Security staff scan the code to instantly verify the cardholder’s identity
• Barcodes for legacy systems — If your organization uses barcode scanners for time tracking, door access, or cafeteria payments, add a barcode field mapped to barcode_id. Code 128 is the most widely supported format
• Dual-sided ID cards — Create a two-page PDF template: page 1 for the front (photo, name, QR code, logo) and page 2 for the back (policies, emergency contact, barcode, magnetic stripe area). Both pages are filled with the same row’s data automatically

Printing Tips

How you print your ID cards depends on the volume and durability requirements:

PVC card printers — For professional, long-lasting employee and student IDs, use a dedicated ID card printer. These printers accept CR80 PVC cards and apply full-color prints with an optional protective overlay layer. Export your merged PDFs and send them to the printer driver.

Badge paper — For events and conferences, print on perforated badge paper (such as Avery adhesive badges) with a regular color printer. Design your PDF to match the badge paper layout exactly — position, size, and spacing must align with the perforations.

Laminated cards — Print on heavy card stock (200–300 gsm) with a color printer, then laminate each card using a thermal laminator with 5 mil or 7 mil pouches. This approach is cost-effective for quantities under 200.

Best Practices

• Standardize photo formats — Crop all headshots to the same aspect ratio and resolution before uploading. Consistent photos produce uniform, professional-looking cards across the entire batch
• Include human-readable ID alongside barcodes — Always display the employee_id in plain text near the barcode or QR code. If a scanner fails, staff can manually verify the number
• Use high-contrast QR codes — Place QR codes on a white or light background. Black QR codes on white provide the most reliable scan performance across all devices
• Test print before bulk runs — Generate 3–5 sample cards and print them before running the full batch. Verify photo clarity, text legibility, barcode scanning, and color accuracy at the actual print size
• Set expiry dates proactively — Include an expiry_date field and set it 1–2 years in the future. This encourages regular reissuance and lets you invalidate old cards during security audits
• Use filename templates for organized output — Set a filename pattern like id-[[full_name]]-[[employee_id]].pdf so the generated files are easy to sort, search, and distribute without manual renaming

Bulk Generation Workflow

1. Design your ID card layout in Canva, Illustrator, or your preferred tool at the correct card size
2. Prepare a spreadsheet with one row per person, including all personal details and photo filenames
3. Upload headshot photos to a media album with filenames matching your spreadsheet’s photo column
4. Place dynamic fields — name, photo, employee ID, QR code, barcode, dates
5. Generate up to 100,000 ID cards in one batch job
6. Download as individual PDFs or a combined file for batch printing

Get Started

Upload your ID card design and personnel data to Mergram. Place your fields, upload your photos to a media album, and generate your first batch of personalized ID cards in minutes.