This article is relevant to you if you're planning to generate and email tickets, and additionally, need unique information on each ticket. 

Ticket Generator allows you to do this in two ways—uploading a CSV/MS-Excel data file OR enter data directly in a data table. 

In this article, we share the best practices on how to create and prepare the data file (CSV/MS-Excel).

Firstly, you can get started by creating a new data sheet (CSV, MS-Excel) in a spreadsheet editor such as Google Sheets (Online), MS-Excel (Windows, Mac), Numbers (Mac) or LibreOffice Calc (Linux). 

Or simply, you can download a sample sheet (that is already in the correct format) and modify it. 

When working on the data sheet, enter the required information in the following format:

  • Column A: In this column, specify email addresses of the ticket recipients. One email address in each row. Ensure that Column Header (Cell A1) is "Email ID". Note that this column is mandatory for processing of tickets using the 'Generate & Email' method
  • Column B-F (Optional): You can optionally use these columns to specify unique information that will go on the ticket of the specified recipient in Column A. 

Use these five columns (max) to share unique information such as: Seat Number (e.g., 1, 2, 3, 4, 5), Row  Number (e.g., A, B, C, D), Section (e.g., Silver, Gold, Platinum), Ticket Price (e.g.,  USD 100, EUR 50), Hall/Auditorium (e.g. Audi 1, Hall 5)

For example, if the data in the CSV/MS-Excel is: 

the data on the ticket that will be sent to [email protected] will be printed as follows:

You can use Columns B-F to provide upto 5 data-points. This means if your CSV/MS-Excel has more than 6 columns (incl. column A), data of 7th column onwards will be ignored. 

Note that the total number of characters for Columns B-F are limited. To avoid header text or data text from being truncated, ensure that number of characters are limited. For example, if you are using only 1 column, you can specify upto 70 characters. If you're using 2 columns, each column data should not be more than 32 characters. And so on. For best results, keep in the number of characters in the range given below:

  • 1 Column: 1-70 characters per column
  • 2 Columns: 1-32 characters per column
  • 3 Columns: 1-19 characters per column
  • 4 Columns: 1-13 characters per column
  • 5 Columns: 1-10 characters per column

Note that at no point should the total number of characters (sum of all columns text i.e. B-F) should be greater than 70 characters. This will ensure that the information on the ticket is clearly printed and visible. 

If you're not certain, always check the ticket preview before proceeding to generate the tickets. 

Once you've finalized your CSV/Excel sheet, follow the steps given below:

  • Login to your Ticket Generator account
  • Select an existing event from drop-down. If you don't have one, click on Create New Event and enter event details
  • Click on Generate & Email and customize the design of ticket as per your requirements
  • Click on Upload Data File and upload your CSV/Excel file. Note that the data you upload will be available for review and modification in the data table
  • Enter information in email subject, body, and reply-to fields
  • If specifying and reviewing all fields, click on Generate 

If you have any further questions related to creating the data file using the Generate & Email method, feel free to reach out to us at [email protected] or [email protected]

Did this answer your question?