Importing data into Mathesar¶
Mathesar allows importing data in CSV format. It also attempts to automatically infer the data type of the columns.
Importing CSV data¶
Delimiters¶
Fields in the CSV data may be delimited by any of the following characters:
| Name | Character | Notes |
|---|---|---|
| Comma | , |
A traditional CSV file (a “Comma Separated Value” document) |
| Tab | (not printable) | This is sometimes referred to as a TSV file (a “Tab Separated Value” document) |
| Semicolon | ; |
|
| Colon | : |
|
| Pipe | | |
Header rows¶
By default, Mathesar will use the first row of CSV data to name the columns.
If you un-check “Use first row as header”, then Mathesar will generate default names for the columns which you can edit later.