CSV Data Formatting
How to properly structure your data to generate hundreds of IDs perfectly.
Understanding Headers
When you upload a CSV file to the Bulk Generator, our system reads the very first row as the "Headers". These headers must exactly match the names of the dynamic fields you used in your editor design.
name, department, employee_id, phone
John Doe, Engineering, ENG-101, 555-0100
Jane Smith, Marketing, MKT-205, 555-0101
In this example, the template must have {name}, {department}, etc. written on the canvas.
Handling Dynamic Photos
To add unique photos for every individual, you must have added a Photo Placeholder in the editor. In your CSV, you need a column specifically for photos. We recommend naming it photo_url.
You have two options for the photo data:
- URLs: Paste a direct public image link (e.g.,
https://example.com/john.jpg). The system will fetch it automatically. - Filenames: Put the local file name (e.g.,
john.png). Then, in the Data Grid interface, simply click the empty photo box and upload the images from your computer!
Handling Missing Data
If a row in your CSV is missing a specific cell (e.g., John Doe does not have a phone number), CraftMyID will gracefully leave that specific field blank on John's ID card without throwing an error.
Exporting from Excel/Google Sheets
If you maintain your data in Microsoft Excel or Google Sheets, simply go to File > Download / Save As > Comma Separated Values (.csv). Upload that downloaded file directly into CraftMyID.