Excel Upload

Excel Upload is generally available in the DataSquares connection wizard. Upload a .xlsx workbook — every sheet is imported as a table.

1. In DataSquares, open Data Sources and choose Add data source.

2. Pick Excel Upload in the connector picker (search or browse by category).

3. Fill in the connection details below, then test the connection and save.

Uploading the file

Pick Excel Upload in the connector picker and upload your file — no credentials needed. Every sheet in the workbook is imported as its own table.

How workbooks import

• Every sheet becomes a table, named after the sheet.
• The header is the first row that looks like one: title lines and blank rows above it are skipped, and unnamed header cells get positional names.
• Column types are inferred from the cells: numbers stay numbers, date cells become dates (a cell with no time of day becomes a calendar date), booleans become booleans.
• Formulas import as their computed values — formula logic doesn’t execute after import.
• .xlsx and .xlsm (macros are ignored). Re-save legacy .xls files as .xlsx; a CSV renamed to .xlsx is imported as CSV.
• Workbooks are read row by row, so large files import without loading the whole workbook into memory. A sheet can have at most 1,600 columns.

Clean imports come from clean sheets

The importer wants each sheet to be a plain grid: a header row, one record per row. Merged cells and pivot-style layouts import poorly — flatten them first.

Replacing the file

Open the source’s Replace file action and upload the new workbook. It is read exactly like the original and swapped in under the same source, so the models and dashboards built on it keep working and show the new data. Sheets or columns missing from the new file disappear from the staged tables; every replacement is listed in the source’s run history.

Related

• Connector catalog — everything DataSquares connects to.
• Quickstart — from connection to shared dashboard.