# Importing JSON Lines data

SurrealDB Studio can be used to import CSV data to SurrealDB.

This page details JSON data types and their SurrealQL equivalents, followed by links to the [Surreal Sync](https://github.com/surrealdb/surreal-sync/) tool which allows this data to be automatically imported to SurrealDB.

## Data types

|      JSON Data Type      |           JSON Representation            | Recommended SurrealQL type    |
| ------------------------ | ---------------------------------------- | ----------------------------- |
| **String**               | `"text"`                                 | `string`                      |
| **Number**               | `42` or `3.14`                           | `int`, `float`, or `decimal`  |
| **Boolean**              | `true`/`false`                           | `bool`                        |
| **null**                 | `null`                                   | `none` or `null`              |
| **Array**                | `[1, 2, 3]`                              | `array` or `set`              |
| **Object**               | `{"key": "value"}`                       | `object`                      |
| **ISO 8601 Date String** | `"2024-01-15T14:30:00Z"`                 | `datetime` or `string`        |
| **UUID String**          | `"550e8400-e29b-41d4-a716-446655440000"` | `uuid` or `string`            |
| **Base64 String**        | `"SGVsbG8gV29ybGQ="`                     | `bytes` or `string`           |

## Importing JSON Lines data using Surreal Sync

The JSONL source in Surreal Sync allows you to import JSON Lines (JSONL) files into SurrealDB. Each JSONL file becomes a table in SurrealDB, and each line in the file becomes a document in that table.

For more on how to import JSON Lines data to SurrealDB, please see the following pages in the Surreal Sync repo.

* [JSONL Source Usage Guide](https://github.com/surrealdb/surreal-sync/blob/main/docs/jsonl.md)
* [JSONL Data Types Support in Surreal Sync](https://github.com/surrealdb/surreal-sync/blob/main/docs/jsonl.md)