How to use Excel data to print labels (P-touch Editor 5.x for Windows)

 Image

Please follow the instructions below:

 

  1. Preparing the database

     

    • Using the file "Parts.xls" in the folder at Program Files "C:\Program Files\Brother\Ptedit5x\Samples" or "C:\Program Files (x86)\Brother\Ptedit5x\Samples"

      Image
  2. Specifying the size of the label

     

    • Click Image to display the Paper Properties.
      (If the properties are currently displayed, this step is not necessary.)

    • e.g. Specify 1-1/7" (29 mm) in the Tape Combo box, and 3.2" (81.3 mm) in the length edit box.

      Image Image
  3. Connecting the database

     

    • Click [File] - [Database] - [Connect...].

      <Using Professional mode as an example. You can edit on Express mode as well>
      Image

    • Select the prepared Microsoft Excel file. Check the "Header Row Contains Field Names" check box. Check the "Connect as read-only" box and then click the "Next" button.

      Image

    • The database appears.

      Image

    If the file being used contains multiple sheets, the Select Database Table dialog box appears. Select the sheet that you wish to use.

     
  4. Merging data into a layout as text

    First, specify the font that will be used in the layout.

     

    • In the Font box on the Text Properties, specify the font (e.g. "Arial").
    • In the Font Size edit box on the Text Properties, specify the font size (e.g. "14").
    • The font and size can also be changed after text is pasted into the layout.
    Merge the database data into the layout.

     

    • Click the field name "Part Name" and drag the field name into the layout window. The dialog box appears. Select "Text".

      Image

      Image

    • In the same way, merge the field name "Model Name".

      Image
  5. Merging data into the layout as a bar code

     

    • Click the field name "Part Code" and drag it into the layout window. The dialog box appears. Select "Bar Code".

      Image

      Image

    • Double-click the merged bar code data.

    • Click the [Setup] tab of the Bar Code Properties dialog box. To adjust width, under "Width", select "Small". To adjust alignment, under "Show Characters", select "Center". After specifying the desired settings, click the "OK" button.

      Image

    Depending on the selected barcode protocol, the data may not be displayed.
    ("Invalid" or "Incorrect check digit" appears.)
    If the barcode cannot be displayed, any of the following may be the cause :

     
    • The data that cannot be used with the barcode is included.
    • The data does not include the specified number of digits.
    • The check digit calculation is incorrect.
    Check the data or change the barcode protocol. e.g. "CODE39" or "CODE128" can be used.
     
  6. Aligning the objects

     

    • Click Image to display the Layout Properties.
      (If the properties are currently displayed, this step is not necessary.)

    • Align all objects along their horizontal centers. Click [Select All] on the [Edit] menu to select all of the objects.

      Image

    • Click the "Align Horizontal Center" button.

      Image

    • You can also align all objects vertically along the width of the label with the "Align Vertically Center" button.

      Image

      Image
  7. Printing

     

    • Click Image to display the Print Properties.
      (If the properties are currently displayed, this step is not necessary.)

    • Click Image on the print property palette.

      Image

    • The Print dialog box will appear. Under "Print Range", select "All Records". After specifying the desired settings, click the "Print" button.

      Image

    For details on selecting a record range, refer to the following table.

    Print Range Records to be Printed
    All Records Print all records.
    Current Record Print the current record.
    Marked Record(s) Print only the marked records.
    Record Range Print records in the range specified by "From" and "To".

If your question was not answered, have you checked other FAQs?

Have you checked manuals?

If you need further assistance, please contact Brother customer service:

Related Models

PT-2430PC, PT-2730, PT-9700PC, PT-9800PCN, PT-E550W, PT-E800T, PT-E850TKW, PT-P750W, PT-P900W, PT-P950NW, QL-1060N, QL-1100, QL-1110NWB, QL-700, QL-720NW, QL-800, RJ-3150, RJ-4230B, TD-2020, TD-4410D, TD-4420DN

Content Feedback

To help us improve our support, please provide your feedback below.

Step 1: How does the information on this page help you?

Step 2: €Are there any comments you would like to add?

Please note this form is used for feedback only.