> ## Documentation Index
> Fetch the complete documentation index at: https://clickhouse.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

> Documentation for the LineAsString format

# LineAsString

| Input | Output | Alias |
| ----- | ------ | ----- |
| ✔     | ✔      |       |

<h2 id="description">
  Description
</h2>

The `LineAsString` format interprets every line of input data as a single string value.
This format can only be parsed for a table with a single field of type [String](/docs/reference/data-types/string).
The remaining columns must be set to [`DEFAULT`](/docs/reference/statements/create/table#default), [`MATERIALIZED`](/docs/reference/statements/create/view#materialized-view), or omitted.

<h2 id="example-usage">
  Example usage
</h2>

```sql title="Query" theme={null}
DROP TABLE IF EXISTS line_as_string;
CREATE TABLE line_as_string (field String) ENGINE = Memory;
INSERT INTO line_as_string FORMAT LineAsString "I love apple", "I love banana", "I love orange";
SELECT * FROM line_as_string;
```

```text title="Response" theme={null}
┌─field─────────────────────────────────────────────┐
│ "I love apple", "I love banana", "I love orange"; │
└───────────────────────────────────────────────────┘
```

<h2 id="format-settings">
  Format settings
</h2>