# Map components to columns

You can link the components of your Output Template to specific columns of your Excel spreadsheet.

# Instructions

# Step 1 - Create your Output template

Drag and drop the components you want to use in your Output Template.

# Step 2 - Set the label

Click on the component you want to map and set the label you want to use in the Excel file.

For example, to map the NUMBER component to the QUANTITY column, click on the NUMBER component and set the Label to "QUANTITY", like this:

 

# Step 3 - Save the settings

Click Save & Apply.

Update values

By default, Barcode to PC will add new rows to your Excel file. To update the value of specific cells in your Excel file, instead, change the Output mode option to Update values.

The Component label value will be used as search key to find the cell to update.

# Example: Update quantity value

If you want to update the quantity value of a product in your Excel file, you can do the following:

• Set the Component label value to BARCODE
• Set the Label of the BARCODE component to BARCODE
• Set the Label of the NUMBER component to QUANTITY

Make sure there are no extra spaces before or after the text, and that it matches exactly the column header in your Excel file.

Barcode to PC will go through the enteire file, searching for a row where the BARCODE column matches the scanned barcode. If it finds a match, it will update the QUANTITY column with the value of the NUMBER component.