Directly import a CSV, TSV or Excel file from your workstation. No external authentication required.
For the general flow of adding a source, see Connect Data Sources.
A .csv, .tsv, .xls or .xlsx file, ideally with a header row
UTF-8 encoding recommended. A CSV saved by Excel on Windows (Windows-1252) is recognized and read too
The first row should be a header row with the column names:
name,email,department
Alice,[email protected],ITComma or semicolon delimiter, detected automatically · UTF-8 or Windows-1252 · For an Excel workbook, only the first sheet is imported
A title or blank lines above the header row are skipped. If the file has no header row, turn off First row contains column names in the preview: the columns are then numbered column_1, column_2, …
Enter a name for the connector
Drag and drop or select your file
Review the detected columns preview, and any warning shown above it
Click Save: the rows are loaded into the table
To update the data later, open the source and upload the new file: its rows replace the previous ones.
Field | Where to find it |
|---|---|
CSV file | Your workstation |
(dynamic) — All header columns are imported automatically, into a table named after the file
Need help? Contact [email protected].