In P-touch Editor 5.x, you can easily save the format settings. Follow the steps below.
 

1. As usual – highlight the data in Excel, and click on the P–touch icon  :
   
   


2. The "Import Setup" screen appears – and all fields are spread across the label layout :
   
   


3. [Label Layout] enables you to change the way your text is displayed/printed. When you choose any listed item in the [Fields] box and click the Add button, a new field is added to the [Label Layout] box. You can enter spaces, line feeds, commas, and characters for each cell and print them on a label. You can also remove fields in this screen by highlighting the field and pressing the delete key on your keyboard.
   
   
   
   After you have set the format, check on the "Save Format for Importing." check box. The current format will be used next time you use Add-In function with Microsoft Excel too.