Home / Event Ticket Maker

Create event tickets from Excel

Upload an Excel sheet with your attendees' data: each column becomes a field. Design the ticket single or double-sided, with a background, images and a QR code linked to its data, and download every ticket in a print-ready PDF.

Advertisement
Reserved space for Google AdSense ad (Top Banner)

Select Excel file

or drag and drop your sheet here (XLSX or CSV)

Your documents are processed in your browser and never leave your computer.

The first row of the sheet holds the column names (Name, Date, Seat…) and each following row is one ticket.

Add:

Click an element to edit it. Drag it to move it, use the corners to resize it and the arrow keys to nudge it. Delete removes it.

Selected element

Click an element on the ticket to change its format.

Excel fields

Each column is a field. Rename it or change its value on the ticket you are viewing, and use “+” to add it to the design. In texts, a field is written in braces: {Name}.

You can also drag a field from ⠿ onto the ticket.

You can also use [n] (ticket number) and [total] (number of tickets).

Ticket and background
Sides

Printing and download

The design is saved as a file on your device (with its images) so you can reuse it with another Excel sheet.

Your tickets are ready!

More tools
Advertisement
Reserved space for Google AdSense ad (Bottom Banner)

How to create event tickets from Excel

The tool reads the first sheet of your Excel file (or the CSV), takes the first row as field names and creates one ticket per row. The design is the same for all of them and the fields are filled in with each row's data.

  1. Upload your Excel file with one column per item (name, date, seat, code…) or download the template and fill it in.

  2. Design the ticket: background, images, text with fields such as {Name} and a QR code with a link carrying each ticket's data.

  3. Choose single or double-sided and the print layout, and download the PDF with every ticket.

What it is for

Concerts, theater and parties

Numbered tickets with row and seat, price and a code for access control.

Conferences and trade fairs

Badges with each attendee's name, company and pass type.

Invitations with QR

One QR per guest that opens their record on your website or access-control system.

Why use JapalTools?

Your files never leave your device

Everything happens in your browser. Documents are never uploaded to any server, so you can use it with payslips, contracts or ID documents.

Free, no sign-up and no watermarks

You don't need an account or to leave your email, and nothing is added to the result.

Works on any device

Computer, tablet or phone, with an up-to-date browser (Chrome, Edge, Firefox or Safari). Nothing to install.

Advertisement
Reserved space for Google AdSense ad (In-content)

Frequently asked questions

An .xlsx or .csv file with the column names in the first row and one ticket per row. Dates and numbers are shown with their Excel format. If the workbook has several sheets, you can choose which one to use. Old .xls files are not supported: save it as .xlsx first.

Whatever you choose: a link to your website with the ticket's data (for example https://yoursite.com/ticket?code={Code}), the value of a column or a text with the data. JapalTools does not store or validate tickets: the link must lead to your own website or access-control system.

Choose “Double-sided” and design the back. In the PDF, each sheet of fronts is followed by its sheet of backs, placed so they line up when printed double-sided with the chosen flip. Print at 100 % size and test with one sheet first.

Yes. The background can be a color, a gradient or an image, and on top you can add as many images as you like (logos, sponsors, photos), move them, rotate them and change their opacity.

Yes. “Save design” downloads a file with the design and its images. For your next event, upload the new Excel file and press “Open design”: if the columns have the same names, the fields fill in automatically.

Yes, if your sheet has a column with email addresses. Tick “Prepare an email for each person”, write the subject and message and download the emails: each .eml file is a draft with that person’s ticket as a PDF, which you open in your desktop email app (Outlook, Thunderbird or Apple Mail) and send from your own account. The website sends nothing: the emails are prepared in your browser.

No. The document is processed in your own browser and is not sent to JapalTools or anyone else. When you close the page, no copy remains outside your device.

Creating the tickets…