Excel File Step
The Excel File step imports spreadsheets in XLSX, XLS, and XLSB formats to start a Data Preparation flow using data from the file.
In the flow editor, click + (Add Steps): Excel File is in the Data Source category. Drag the step into the flow. After configuring the preparation with it, upload the files through the platform's File Upload screen in Dattos.
Import the spreadsheet
When you add the step to the flow, the Send sample file for configuration screen asks for a sample spreadsheet. There are two ways to upload the file:
Import File: opens the file explorer so you can select the file.
Drag and drop: drag the file directly onto the screen.
Validation during import: only files with the XLSX, XLS, and XLSB extensions are accepted, with a maximum size of 100 MB for Turbo AI processes and 50 MB for Standard processes.
Configure the step and choose the sheets
On the configuration screen, you will find:
File information: identifies the name of the imported file.
AI Identifier: artificial intelligence reads the sample spreadsheet and fills in the step configuration, including sheets, columns, and types, and records the result immediately. Check the columns afterward.
Preview: displays the contents of the sample spreadsheet.
Change file: replaces the imported file. When you import a new file, the platform lets you keep the configurations already made and update only the sample, or update all configurations based on the new file.
Name: identifies the name of the step. By default, it uses the name of the imported sample file, but the field can be edited.
Next, choose how the platform locates the sheets to configure for reading:
Read based on the sheet name: the platform searches for the sheet by name.
Read based on the sheet order: the platform searches for the sheet by its order. This is useful when the sheet name may change but the data remains the same.
When the file has more than one sheet, the select sheets option appears and lets you choose which sheets to configure. For each sheet, the screen shows the Sheet order in the file, the Sheet name in the file, and the Output (the data output port used to connect the steps).
Tip: choose a name that represents the file's information and is easy for you and your colleagues to understand.
One output per sheet: for each imported sheet, according to the selection made, the platform generates an output port.
Unified sheets: if the "Unify sheets into a single output port" option is enabled in the advanced settings, you can select only one sheet as a template.
Configure the sheets and columns
For each selected sheet, adjust the reading settings and columns:
Select the File sheet: selects the sheet to configure.
Contains Header?: determines whether the file has a header.
Start importing data at row / Enter the header row: defines the starting row for reading the data.
Column Order: shows the order in which the columns were imported; the field can be edited.
Column Name: shows all columns in the file; the names can be renamed.
Data Type: Text, Numeric, or Date. The field can be edited. In Turbo AI processes, a Date column gets the Date format field (see the following section).
Sample: displays the contents of the columns in the first imported row.
Add Column: manually adds columns to the configuration. Enter the quantity and click the button; the new row opens so you can fill in Order (editable), Name in Source (editable), Sample (is null and cannot be edited), and Data Type (Text, Numeric, or Date).
Delete Column icon: removes a column from the sheet configuration.
Use Close to exit without saving and return to the editor, or Save and close to save the configurations.
Enter the date format
In Turbo AI processes, each Date column has the Date format field. It indicates how the date is written in the spreadsheet, for example DD/MM/YYYY for day, month, and year separated by slashes. With this setting, 01/09/2026 is read as September 1, not January 9.
Pre-filled: when importing the spreadsheet, if the column contains dates written as text, the platform marks the column as Date and suggests the format. It determines from the data itself whether the day or month comes first. Check the format before saving.
Choose or type: the field provides the same 24 formats as the Text File step and accepts a manually entered format.
Applies to dates written as text: a cell that Excel already stores as a date is imported as a date, without the time, regardless of the format.
Mismatched values are left blank: text written in another format (such as 01-09-2026 in a DD/MM/YYYY column) or a number is left blank, without a warning. If the column is blank in the result, check the format.
Optional: without a format, the column continues to be read as before.
Same result for all three file types: XLSX, XLS, and XLSB.
The format is used to read the date: it does not change how the date appears in the result.
Standard processes: the Excel File step in these processes does not have the Date format field.
Reference date taken from the spreadsheet
In Turbo AI processes, the reference date can come from a date column in the spreadsheet: each distinct date generates its own load, containing only the rows for that date. The column must be of type Date. Check its date format, described above, because a date read incorrectly becomes an incorrect reference date.
This configuration is not done in this step, but through the Reference date button in the designer header. The step-by-step instructions are in the Data flow article.
Advanced settings
Turn on the Advanced settings toggle below the columns to see the first two options. The last three are always visible.
Decimal separator for converting text to numbers: Comma ( , ) or Period ( . ), depending on the separator used in the file. For example, content "100,99" read as a number requires the Comma separator; "100.99" requires the Period separator. In both cases, the displayed result is "100,99".
Add the data source name as a column: adds a column containing the step name to the sample.
Add the file name as a column: adds a column containing the imported file name to the sample.
Add the sheet name as a column: adds a column containing the name of the data output sheet to the sample.
Unify sheets into a single output port: use this when the column structure is identical across all sheets or when you want to treat all sheets as a single table in the step output.
When unifying sheets: with "Unify sheets into a single output port" enabled, you can select only one sheet as a template when choosing the sheets to read.
Related articles
Configure Data Preparation
OFX File Step
Text File Step