FAQs

Browse Categories
 
     Instructions:
     Art Submission
       & Specifications
  
       Spreadsheets
  
     10% Discount
       for Non-Profit
 
     ______________
 
       External Links  
      
       E-Mail Us

       FAQ's
Personalized Bibs Personalization and Spreadsheets

Feel free to call us if you have any questions regarding personalization or spreadsheets at 1-800-255-4120 or by emailing us at sales@marathononline.com..

We can print athlete names, registration information, or personalized messages on bibs.  
We accept .xls, .xlsx, or .csv formats.

This is a great way to encourage pre-registration for your event, offer uniquely personalized keepsake bibs, or replace the need for attaching labels.  You will need to provide us an Excel file with the complete number sequence and all names and data.

Personalized Bibs


Guidelines


Please follow these guidelines to make sure your file is properly formatted:

1. BASIC
In the simplest case, we need a column for bib number and a column for name.  For example:

A B
1 BIB# NAME
2 101 Amy
3 102 Pete
4 103 Roland
5 104 Sarah

2. BIB NUMBERS
Bib numbers can be assigned in any sequence you wish.  They can be duplicates or completely random, it's up to you.  For example:

A B
1 BIB# NAME
2 1001 Amy
3 555 Pete
4 555 Roland
5 2576 Sarah

3.  BLANKS
If you also need 'blanks' (bibs that do not have names assigned) printed, be sure to include them in the file by listing the complete number sequence.  Numbers not included in the spreadsheet will NOT be printed.  For example:

A B
1 BIB# NAME
2 1997 Sue
3 1998 Ralph
4 1999
5 2000

4.  ADDITIONAL DATA
For additional information, please provide the data in additional columns.  For example:

A B C D
1 BIB# NAME AGE GENDER
2 101 Amy 31 Female
3 102 Pete 28 Male
4 103 Roland 33 Male
5 104 Sarah 19 Female

5.  MULTIPLE EVENTS
For multiple events, please use a separate spreadsheet for each event.  You can also use a column to specify event, but this is not preferred.

6.  ALL CAPS vs Mixed (Proper) Case
We can format your list to print in all caps to ensure names are large and legible.  Please note that printing lower case letters can run into the issue of letters like 'g' or 'y' hanging into the art below.  For this reason we generally prefer to print all caps.  Notable exceptions are when registrants have used creative 'nicknames' using mixed case.  Please let us know if you have a preference.

7.  EXTRA COLUMNS / HIDDEN OR FORMULATED DATA
Please do us the courtesy of removing any unneeded data from the spreadsheet.  Some registration files can be large and complicated, including hidden columns or formulated data.  All of this will need to be removed in order for us to use the file for print.   (Spreadsheets with formulated data can be saved as .csv files to automatically remove all formulas and replace with static text.)

8.  HOW TO QUICKLY CREATE A NUMBER SEQUENCE IN MICROSOFT EXCEL
You can quickly extend a regular (incremental) number sequence by typing in the first 3 numbers (e.g. 101, 102, 103), selecting them, then dragging the bottom right corner of the selection down the page.  Excel should automatically recognize the sequence as incremental and fill in all subsequent numbers (tested in Microsoft Excel 2010).  For other tips and tricks you may need to search online.  There are many references available for helpful shortcuts and how-to's.




Search
Shopping Cart
Your cart is empty.
 
 

        Follow RaceNumbers on Twitter