---
title: "XLS - Lasernet Form Editor 9 - XLS, CSV and TXT Input"
slug: "xls-training-lasernet-form-editor-9"
description: "Input files in XLS format are automatically converted to XML. More on handling and processing the XLS input format files in the Lasernet Form Editor is in the article."
tags: ["Form Editor", "Lasernet 9 ", "XLS "]
updated: 2026-03-06T07:47:52Z
published: 2026-03-06T07:47:52Z
canonical: "kb.lasernetgroup.com/xls-training-lasernet-form-editor-9"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.lasernetgroup.com/llms.txt
> Use this file to discover all available pages before exploring further.

# XLS

**Applies to:** Lasernet 9

Input files in XLS format are automatically converted to XML. Handling and processing the XLS input format files in the Lasernet Form Editor application is similar to the operations with the XML input format files.

When an .xlsx grab file opens, it is automatically converted to XML.

Spreadsheets created in Microsoft Excel 2007 or newer are supported. Installing Microsoft Excel is not required to convert Excel into XML.

> [!NOTE]
> Note
> 
> This article describes a software version that is no longer supported. Although the software will no longer receive updates or technical support, existing documentation, such as this article, will be retained for reference purposes but will no longer be updated. If you have any questions, contact [Lasernet Support](https://support.lasernetgroup.com/new-ticket).

## Exercise

Download and import the attached configuration called **01. XLS** **in Lasernet Developer 9**. Afterward, follow these steps:

1. On the **Tools** panel, click **Forms** to open a form area.
2. Click the **Add** button on the top toolbar.

Otherwise, you can drag the **Form** item to the form area. As one more alternative, you can right-click in the form area and then click **Add** in the context menu that appears.

1. Enter the name of the new form (**Sample**) in the **Name** field.
2. Select **XLS** as an input format.
3. Once you are done, click **Ok** to confirm adding a new form.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628257281428.png)

1. Open the **Sample** form you have just added for editing. To this end, select it, and then click the **Edit** button on the toolbar. Otherwise, you can right-click the form and then select **Edit** on the context menu that appears, or just double-click the form.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628257281672.png)

1. Open a grab file named **Sample**. To this end, on the **Form** menu, click **Select Grab File(s)**.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628257280615.png)

1. In the **Select Grab File(s)** dialog that opens select the **Copy of Sample** folder, then select the **Sample** file, and then click **Open**.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628257282340.png)

You are now proposed to modify the structure of the input file to improve your effectiveness and efficiency for working with XML. To this end, follow the steps listed below:

1. On the **Form** menu, click **Form Options**.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628257281027.png)

1. In the **Form Options** dialog displayed, switch to the **Excel to XML** tab.
2. Use the **Number of header rows** spin box to specify **1** as a value, meaning that the first row(s) in the Excel spreadsheet is to be parsed as column name(s) and not as common data.
3. Select the **Header names for elements** check box, which means that a header name is to be used instead of the column name with an attribute.

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628257281197.png)

See the following image to compare the XML file structures before and after changing the form options:

![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/1628257282000.png)

## Attachments

- [01.-XLS.lnconfigx](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/01.-XLS.lnconfigx)