Printing Perforated Card Sheets

Use Microsoft Excel to print your product and location data

Instructions for Printing Data Cards

Creating a page layout for printing cards can be a time consuming and possibly a frustrating task. If you have access to Microsoft Excel, these instructions will enable you to easily set-up your data card page layout in a spreadsheet format. Below are two methods of instructions:

A basic working knowledge of the Excel program is required. To expedite the printing set-up process, we recommend utilizing one of our existing templates.

Using Our Standard Size Data Card Templates

Templates of over 50 data card sizes have been created for you. We strongly suggest utilizing one of these pre-formatted template pages to print your data cards. The choices are popular card sizes including all of those offered with our Perforated Data Card Sheets.

The card sizes are listed from smallest to largest in the Data Card Specifications chart below.

If your desired size is not listed or if you printer overrides the design layout provided, then it will be necessary to create your own card layout template using the instructions following the data card template chart.

Data Card Specifications

Click on a Part # to select an Excel template sheet

                                                                                                                                                                      I ----------- Margin Settings ----------- I

Template    Sheet     Part #  Card   Size  H" x L"Fits Holder     Part #     SeriesCards   Per   Pack # of Rows# of Col. Top Bottom Left RightCol. Wid.Row Hgt.
SL03X23/8 x 2B,H,KP2160  27 40.500  0.3150.25 0.19 2.00.375
SL03X33/8 x 3B,H,KP1080  27 20.500  0.3150.25 2.19 3.00.375
SL03X43/8 x 4B,H,KP1080  27 20.500  0.3150.25 0.19 4.00.375
SL03X8.53/8 x 8-1/2B,H,KP  540  27 10.500  0.3150.25 0.19 8.00.375
SL035X225/64 x 2C,H,KP2080  26 40.453  0.3310.25 0.19 2.00.391
SL035X325/64 x 3C,H,KP1040  26 20.453  0.3310.25 2.19 3.00.391
SL035X425/64 x 4C,H,KP1040  26 20.453  0.3310.25 0.19 4.00.391
SL035X8.525/64 x 8-1/2C,H,KP  520  26 10.453  0.3310.25 0.19 8.00.391
SL04X21/2 x 2B,H,KP1600  20 40.500  0.4400.25 0.19 2.00.500
SL04X31/2 x 3B,H,KP  800  20 20.500  0.4400.25 2.19 3.00.500
SL04X41/2 x 4B,H,KP  800  20 20.500  0.4400.25 0.19 4.00.500
SL04X8.51/2 x 8-1/2B,H,KP  400  20 10.500  0.4400.25 0.19 8.00.500
SL06X173/4 x 1-7/8B,H,KP1040  13 40.500  0.6900.25 0.691.8750.750
SL06X23/4 x 2B,H,KP1040  13 40.500  0.6900.25 0.19 2.00.750
SL06X33/4 x 3B,H,KP  520  13 20.500  0.6900.25 2.19 3.00.750
SL06X43/4 x 4B,H,KP  520  13 20.500  0.6900.25 0.19 4.00.750
SL06X63/4 x 6B,H,KP  260  13 10.500  0.6900.25 2.19 6.00.750
SL06X8.53/4 x 8-1/2B,H,KP  260  13 10.500  0.6900.25 0.19 8.00.750
SL065X213/16 x 2C,H,KP  960  12 40.437  0.7500.25 0.19 2.00.813
SL065X313/16 x 3C,H,KP  480  12 20.437  0.7500.25 2.19 3.00.813
SL065X413/16 x 4C,H,KP  480  12 20.437  0.7500.25 0.19 4.00.813
SL065X613/16 x 6C,H,KP  240  12 10.437  0.7500.25 2.19 6.00.813
SL065X8.513/16 x 8-1/2C,H,KP  240  12 10.437  0.7500.25 0.19 8.00.813
SL07X27/8 x 2B,H,KP  880  11 40.500  0.8150.25 0.19 2.00.875
SL07X37/8 x 3B,H,KP  440  11 20.500  0.8150.25 2.19 3.00.875
SL07X47/8 x 4B,H,KP  440  11 20.500  0.8150.25 0.19 4.00.875
SL07X67/8 x 6B,H,KP  220  11 10.500  0.8150.25 2.19 6.00.875
SL07X8.57/8 x 8-1/2B,H,KP  220  11 10.500  0.8150.25 0.19 8.00.875
SL1X21 x 2B,H,J,KP  800  10 40.500  0.4400.25 0.19 2.01.000
SL1X31 x 3B,H,J,KP  400  10 20.500  0.4400.25 2.19 3.01.000
SL1X41 x 4B,H,J,KP  400  10 20.500  0.4400.25 0.19 4.01.000
SL1X61 x 6B,H,J,KP  200  10 10.500  0.4400.25 2.19 6.01.000
SL1X8.51 x 8-1/2B,H,J,KP  200  10 10.500  0.4400.25 0.19 8.01.000
SL12X21-1/4 x2B,H,KP  640    8 40.500  0.4400.25 0.19 2.01.250
SL12X31-1/4 x 3B,H,KP  320    8 20.500  0.4400.25 2.19 3.01.250
SL12X41-1/4 x 4B,H,KP320    8 20.500  0.4400.25 0.19 4.01.250
SL12X61-1/4 x 6B,H,KP160    8 10.500  0.4400.25 2.19 6.01.250
SL12X8.51-1/4 x 8.5B,H,KP160    8 10.500  0.4400.25 0.19 8.01.250
SL14X31-1/2 x 3B,H,KP240    6 20.500  1.4400.25 2.19 3.01.500
SL14X41-1/2 x 4B,H,KP240    6 20.500  1.4400.25 0.19 4.01.500
SL14X61-1/2 x 6B,H,KP120    6 10.500  1.4400.25 2.19 6.01.500
SL14X8.51-1/2 x 8-1/2B,H,KP120    6 10.500  1.4400.25 0.19 8.01.500
SL15X31-11/16 x 3C,H,KP240    6 20.500  0.3150.25 2.19 3.01.688
SL15X41-11/16 x 4C,H,KP240    6 20.500  0.3150.25 0.19 4.01.688
SL15X61-11/16 x 6C,H,KP120    6 10.500  0.3150.25 2.19 6.01.688
SL15X8.51-11/16x8.5C,H,KP120    6 10.500  0.3150.25 0.19 8.01.688
SL2X32 x 3B,H,J,KP200    5 20.500  0.4400.25 2.19 3.02.000
SL2X42 x 4B,H,J,KP200    5 20.500  0.4400.25 0.19 4.02.000
SL2X62 x 6B,H,J,KP100    5 10.500  0.4400.25 2.19 6.02.000
SL2X8.52 x 8-1/2B,H,J,KP100    5 10.500  0.4400.25 0.19 8.02.000
SL26X42-3/4 x 4B,H,KP120    3 20.500  2.1900.25 0.19 4.02.750
SL26X52-3/4 x 5B,H,KP60    3 10.500  2.1900.25 3.19 5.02.750
SL26X62-3/4 x 6B,H,KP60    3 10.500  2.1900.25 2.19 6.02.750
SL26X8.52-3/4 x 8-1/2B,H,KP60    3 10.500  2.1900.25 0.19 8.02.750
SL3X43 x 4B,C,H,KP120    3 21.000  0.9400.25 0.19 4.03.000
SL3X53 x 5B,C,H,KP60    3 11.000  0.9400.25 3.19 5.03.000
SL3X63 x 6B,C,H,KB,KP60    3 11.000  0.9400.25 2.19 6.03.000
SL3X83 x 8B,C,H,KB,KP60    3 11.000  0.9400.25 0.19 8.03.000
SL3X8.53 x 8-1/2B,C,H,KB,KP60    3 11.000  0.9400.25 0.19 8.03.000
SL4X64 x 6H,KP40    2 10.500  2.4400.25 2.19 6.04.000
SL4X8.54 x 8-1/2H,KP40    2 20.500  2.4400.25 0.19 4.84.000

* Card Holder Part Series:

B = Plastic Card Holders C-Channel style

C = Magnetic Card Holders C-Channel style

H = Rack & Shelf, Card & Ticket, Sealtite and Grommet Card Holders styles

J = Clear Card Holders Tubular style

KB = Flexible Card Holders style

KP = Wire Rack Label Tags style

Creating Your Own Card Template

If you decide to design your own custom label template, these steps provide the necessary Excel program instructions. Some printers may override your margins or other dimensional settings and therefore may require additional layout refinements.

There is no direct way to easily set column widths and row heights in Excel without some trial and error - the widths are specified as a number of characters in a Normal font (on your Excel copy) as the unit of measure. Generally this is the number of non-bold, non-Italic, Arial 10 pt zeroes. A width of 10.0 would hold ten zeroes. We have provided the exact dimensions for each standard card size in the Data Card Specifications chart above.