---
title: "Parse text, dates and JSON in Strata | Oplema"
description: "Turn text into data you can use in Strata: dates, numbers, JSON, pieces extracted with a pattern and lists split into columns or rows."
url: "https://oplema.com/docs/strata/parse"
updated: "2026-11-04"
---

# Parse

Parse blocks turn text into data you can use: real dates and numbers, JSON unpacked into columns or rows, pieces of text extracted with a pattern and lists split apart.

**Learn these blocks in context:** [Build a report from a CSV export](https://oplema.com/learn/export-to-report); [Combine and reconcile data files](https://oplema.com/learn/many-sources)

## Blocks in this palette

- Turn text into dates and timestamps.
- Turn JSON text into columns or rows.
- Turn formatted text into numbers.
- Extract text or flag a pattern.
- Split text across columns.
- Split text into rows.

## Parse FAQs

**Should I split to columns or to rows?**

Split to columns suits a fixed set of parts, such as first and last name. Split to rows suits a list with a varying number of items, such as tags.

**How do I read JSON from a connector?**

Use the JSON block on the column that holds it. Unnest object makes columns; Flatten array makes rows.

### Prepare your data. Build it in Strata.

Strata opens in your browser, with no account.

[Open Strata](https://oplema.com/editor?path=%2F%3Fopen%3Dstrata) [About Strata](https://oplema.com/strata)
