Excel 2007+ (.xlsx) Help

Description

Excel 2007+ refers to the file format used by Microsoft Excel versions from 2007 onwards, typically having the .xlsx extension. This format is part of the Office Open XML (OOXML) standard and represents a significant change from the older binary format used in previous versions Excel. Excel files are a compressed Zip package which reduces the file sizes and makes them easier to manage and share. Excel support 1,048,576 rows and 16,384 columns per sheet, more complex formulas, and advanced features like conditional formatting, richer graphics, and improved security options.

Upload Settings for Excel

Click on Upload Settings button to start configuring the import settings for your Excel file.

Sheet Name

If your file contains multiple sheets, you can specify which sheet to use by entering the name of the sheet in this field. If you leave this field empty, the first sheet will be used. If you want to export all sheets, you have to enter each sheet name one at a time and export them separately.

Starting Row

Defines the row number where the data reading should begin. Use 0 for the first row.

Last Row

Defines the last row number to read from the sheet. Use -1 to read until the last available row in the sheet.

Starting Column

Defines the column index where reading should begin. Use 0 for the first column.

Field Names In First Row

If enabled, the system will use the values from the first row of the sheet as the field names (column headers). If this is disabled, the fields will be named generically as A, B, C, etc., based on their column position.

Skip Empty Rows

If enabled, rows that are completely empty will be ignored during import.

Evaluate Expressions

If enabled, the system will evaluate any formulas present in the Excel cells and import their calculated results.

Use Sheet Column Count

Determines how the number of fields (columns) for each row is calculated:

• If enabled, the field count will be based on the total number of columns in the sheet. Each row will be padded with blank values or trimmed as needed to match the sheet's column count.
• If disabled (default), each row will use its own number of fields based on the number of populated cells in that row. This means rows may contain a different number of fields.

Example: If some rows have missing cells at the end, disabling this option means those rows will have fewer fields. Enabling it will keep the field count consistent across all rows, filling missing cells with blank values.

Once you have configured the settings, click Save Changes to apply them.