TabSeparated

Insert the data:

```
INSERT INTO football FROM INFILE 'football.tsv' FORMAT TabSeparated;
```

### Reading data[​](#reading-data "Direct link to Reading data")

Read data using the `TabSeparated` format:

```
SELECT *
FROM football
FORMAT TabSeparated
```

The output will be in tab separated format:

```
2022-04-30      2021    Sutton United   Bradford City   1       4
2022-04-30      2021    Swindon Town    Barrow  2       1
2022-04-30      2021    Tranmere Rovers Oldham Athletic 2       0
2022-05-02      2021    Port Vale       Newport County  1       2
2022-05-02      2021    Salford City    Mansfield Town  2       2
2022-05-07      2021    Barrow  Northampton Town        1       3
2022-05-07      2021    Bradford City   Carlisle United 2       0
2022-05-07      2021    Bristol Rovers  Scunthorpe United       7       0
2022-05-07      2021    Exeter City     Port Vale       0       1
2022-05-07      2021    Harrogate Town A.F.C.   Sutton United   0       2
2022-05-07      2021    Hartlepool United       Colchester United       0       2
2022-05-07      2021    Leyton Orient   Tranmere Rovers 0       1
2022-05-07      2021    Mansfield Town  Forest Green Rovers     2       2
2022-05-07      2021    Newport County  Rochdale        0       2
2022-05-07      2021    Oldham Athletic Crawley Town    3       3
2022-05-07      2021    Stevenage Borough       Salford City    4       2
2022-05-07      2021    Walsall Swindon Town    0       3
```

## Format settings[​](#format-settings "Direct link to Format settings")

|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Setting Description Default|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`format_tsv_null_representation`](/docs/operations/settings/formats#format_tsv_null_representation) Custom NULL representation in TSV format. `\N`| [`input_format_tsv_empty_as_default`](/docs/operations/settings/formats#input_format_tsv_empty_as_default) treat empty fields in TSV input as default values. For complex default expressions [input\_format\_defaults\_for\_omitted\_fields](/docs/operations/settings/formats#input_format_defaults_for_omitted_fields) must be enabled too. `false`| [`input_format_tsv_enum_as_number`](/docs/operations/settings/formats#input_format_tsv_enum_as_number) treat inserted enum values in TSV formats as enum indices. `false`| [`input_format_tsv_use_best_effort_in_schema_inference`](/docs/operations/settings/formats#input_format_tsv_use_best_effort_in_schema_inference) use some tweaks and heuristics to infer schema in TSV format. If disabled, all fields will be inferred as Strings. `true`| [`output_format_tsv_crlf_end_of_line`](/docs/operations/settings/formats#output_format_tsv_crlf_end_of_line) if it is set true, end of line in TSV output format will be `\r\n` instead of `\n`. `false`| [`input_format_tsv_crlf_end_of_line`](/docs/operations/settings/formats#input_format_tsv_crlf_end_of_line) if it is set true, end of line in TSV input format will be `\r\n` instead of `\n`. `false`| [`input_format_tsv_skip_first_lines`](/docs/operations/settings/formats#input_format_tsv_skip_first_lines) skip specified number of lines at the beginning of data. `0`| [`input_format_tsv_detect_header`](/docs/operations/settings/formats#input_format_tsv_detect_header) automatically detect header with names and types in TSV format. `true`| [`input_format_tsv_skip_trailing_empty_lines`](/docs/operations/settings/formats#input_format_tsv_skip_trailing_empty_lines) skip trailing empty lines at the end of data. `false`| [`input_format_tsv_allow_variable_number_of_columns`](/docs/operations/settings/formats#input_format_tsv_allow_variable_number_of_columns) allow variable number of columns in TSV format, ignore extra columns and use default values on missing columns. `false` | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

- [Description](#description)- [Data formatting](#tabseparated-data-formatting)- [Example usage](#example-usage)
      - [Inserting data](#inserting-data)- [Reading data](#reading-data)- [Format settings](#format-settings)

Was this page helpful?