FAQs & Troubleshooting

Close

QL-820NWB

FAQs & Troubleshooting

FAQs & Troubleshooting

QL-820NWB

Not your product?

Date: 18/05/2020 ID: faqp00001204_004

How to add Microsoft Excel text to a Label List (P-touch Editor 5.x for Windows)

To add Microsoft Excel data to a Label List, the Label List has to be set to record the data.

If it is NOT set, please take the steps below:

 

  1. Click [Tools] - [Options...] in the edit screen.
  2. Click the [Label List] tab.
  3. Check the "Automatically Record Data Imported With Add-In" check box ON.
  1. Start Excel, and then open the document containing the data to be imported.
  2. Select the cells to be imported.
  3. Click the "Brother P-touch" button  on the [Add-in] tab of the Ribbon. 

The imported data will be registered in the Label List as follows:

Label Data

Column

Date Created "Date" field
First line of the highlighted information "Title" field
All highlighted information "Body" field
Text set to be imported into the "Code" field "Code" field

Related Models

PT-9700PC, PT-9800PCN, PT-D600, PT-E850TKW, PT-P700, PT-P710BT, PT-P750W, PT-P900W, PT-P950NW, QL-550, QL-570, QL-700, QL-720NW, QL-800, QL-820NWB, RJ-3150, RJ-4030, RJ-4040, RJ-4230B, RJ-4250WB, TD-2120N, TD-2130N, TD-4000, TD-4410D, TD-4420DN

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

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.