CSV Upload

CSV Upload is generally available in the DataSquares connection wizard. Upload a .csv file — rows are imported into your workspace.

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

2. Pick CSV 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 CSV Upload in the connector picker and upload your file — no credentials needed. The file rows are imported into a staging table in your workspace and become queryable immediately.

File expectations

• First row = column headers; names are cleaned into valid field names.
• The delimiter is detected from the file — comma, semicolon (European exports), tab (.tsv, Excel’s Unicode Text) and pipe all work.
• Encoding is detected too: UTF-8 (with or without a byte-order mark), UTF-16 and Windows-1252 exports all keep their accented characters.
• Column types are inferred from the data: integers, decimals, booleans, ISO dates and date-times, and day-first / month-first calendar dates when the values make the order unambiguous (15/01/2024 is day-first; a column where every value could be read either way stays text). Scientific notation becomes a floating-point number; values with leading zeros stay text.
• A file can have at most 1,600 columns.

Replacing the data

An upload is a snapshot. To update it, open the source’s Replace file action and upload the new file — the staged table is swapped in place under the same source, and dashboards built on it pick up the new data. Every replacement is listed in the source’s run history.

When CSV isn’t the right tool

Multi-sheet workbooks → Excel upload. Very large or repeated extracts → connect the database they come from instead; uploads are best for one-off and occasional data.

Related

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