File Format

Please send us your file in one of the following formats:

• *.csv
• *.xlsx

Each column in your Excel file requires a unique header, which we use as a placeholder for your personalized layout. Please be clear and consistent when naming columns.

We can process the following data for personalization:

• Text incl. special characters (e.g. bib number, contest name, first / last name, team, club, company, year of birth, address fields, phone, …)
• CMYK color code
• URLs for QR-code or barcode 

Please note the following points when creating your data file:

• Per order, create only a single file with all bib numbers (including the numbers that do not have any personalization). Do not create multiple files or worksheets. If you have multiple products with personalized data, please use additional columns in the same file to specify these products.
• If you order print products with transponders, there can't be any number duplicates in the file.
• If the printed bib number differs from the requested transponder coding, you must create a separate column with the transponder number. For example: the printed bib number is A101, but the transponder is programmed as 101.
• If you order print products with transponders, please note that the programmed transponder codes may have a maximum of 7 digits – the highest permissible number is therefore 9,999,999.
• Name each column header and inform us, which column should be placed where on the layout. The column headers can't contain any empty spaces or special characters.
• In case of a layout change within the same order, please create a column with the layout's name.
• In case of a color change, please create a column with the CMYK color value or the color name.
• For personalization with country flags, we need the ALPHA-2 or ALPHA-3 code in a column. All countries must be written in the same code.