---
title: "Strata - visual data preparation | Oplema"
description: "Clean, combine and reshape data in your browser with blocks or a script. Inspect every step, then run the flow again when your data changes."
url: "https://oplema.com/strata"
updated: "2026-11-08"
---

# Prepare your data. See every step.

Clean, combine and reshape data in your browser. Build a flow, inspect the results and run it again when your data changes.

Give me a file of refunded orders, including their order details. I'll match the refunds to their orders and add a CSV output. The refund file is ready. Your monthly sales report is unchanged.

Open Strata and start with your own file. No sign-up, nothing to install.

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

## Your data. In one flow.

- ### Start with a file.
  Spreadsheets, CSV and Parquet on your computer.
- ### Connect to your database.
  Combine database tables with your other sources.
- ### Bring your apps along.
  Read records from your sales, finance and other apps.

[Explore the connectors](https://oplema.com/connectors)

Files, databases and apps 20 sources

Google Drive

OneDrive

Airtable

Notion

HubSpot

Stripe

QuickBooks

Xero

Dropbox

HTTP

Postgres

MySQL

MariaDB

SQL Server

Supabase

Snowflake

BigQuery

Databricks

Local files

Cloud

Explore supported sources and connection details

## Clean. Combine. Transform.

43 blocks for reading, cleaning, joining and reshaping data. Use SQL, Python or R for anything they don't cover.

### [IO](https://oplema.com/docs/strata/io)

8 blocks

Read data from files, databases and apps, or type it in. Write results back out or send them to a dashboard.

### [Prep](https://oplema.com/docs/strata/prep)

16 blocks

Filter, sort and clean rows and columns. Fill gaps, remove duplicates and calculate new fields.

### [Combine](https://oplema.com/docs/strata/combine)

5 blocks

Bring tables together by stacking, joining or looking up rows, even when values are spelled differently.

### [Transform](https://oplema.com/docs/strata/transform)

6 blocks

Summarize and pivot tables. Calculate totals, running figures and changes over time.

### [Parse](https://oplema.com/docs/strata/parse)

6 blocks

Turn messy text, dates and JSON into clean columns, or split one column into several.

### [Developer](https://oplema.com/docs/strata/developer)

2 blocks

Add Python or R steps for anything the blocks don't cover, using the libraries you already know.

Add notes alongside your flow with the Documentation palette. [Explore Documentation](https://oplema.com/docs/strata/documentation)

[Explore all blocks](https://oplema.com/docs/strata)

## Change a step.
See the result.

Rename a column, change a rule or adjust a step. The results update as you work.

## Build visually. Edit the script.

Every flow has a script you can read and edit, and the canvas stays in sync. Elara works with the same script when it edits your flow.

Workflow Block script

## Add your own code.

- ### Use Python or R.
  Write custom calculations right in your flow.
- ### Bring in libraries.
  Use the packages your calculation needs.
- ### Pass the results back.
  Use data from earlier steps and send the results on.

[Read about the Developer palette](https://oplema.com/docs/strata/developer)

Here, NumPy uses 12 months of fictional sales to estimate demand for the next three months.

## Ask Elara to help.

Elara can build and edit flows, check calculations, help you interpret your results and work through errors.

Break down revenue by product category and rank the results. I'll group revenue by category, then put the largest categories first. The categories are grouped and ranked by revenue.

Elara turns joined data into a ranked breakdown without leaving the flow.

[Explore Elara](https://oplema.com/elara)

## Keep a working version.

Try another approach without losing the one that worked. Your edits and Elara's share the same history.

[Explore Echo](https://oplema.com/echo)

## Use what you build.

Write out the data, build a dashboard or take the flow with you.

### Write your data.

Save a file or write to a supported database.

[Output destinations](https://oplema.com/docs/strata/io/output)

### Build a dashboard.

Send a table to Vista and turn the result into a chart.

[Explore Vista](https://oplema.com/vista)

### Take the flow.

Export flows as Python and run them outside Oplema.

[Read the Strata docs](https://oplema.com/docs/strata)

## Start free. Add cloud when you need it.

Build and run flows locally for free. Pay for hosted runs, Elara and connector transfers when you use them, with no seat fees.

### Start for free

$0 No subscription

Work locally without an account. Sign up for free to get a one-time $10 of usage.

**Strata & Vista**

Build data flows and interactive dashboards.

**Echo**

Branch, compare and restore your work.

**Cloud storage**

The first 25 MB is free, with or without an account. An account pays for more from usage, at $0.01 per GB per day. Guest files are deleted about 30 days after the guest session started.

### In the cloud

Billing frequency Monthly Annual Save 20% annually

Plans from $20 USD / month

Billed monthly. Excludes tax.

Starter $20, Regular $60 or Scale $200 a month, each with monthly usage you can assign to your teams. You can also buy usage from $10 without a subscription.

**Hosted runs**

$0.0024 per minute on 2 vCPU and 4 GiB.

**Elara**

From $0.3456 input / $2.16 output per million tokens, depending on the model and account region.

**Data transfer**

$0.01 per GB for connector reads and writes over 50 MB per transfer. Local files are free and unlimited.

There are no seat fees, and local work stays free. Larger machines and larger transfers are coming.

[Explore pricing](https://oplema.com/pricing) [Explore Console](https://oplema.com/console)

## FAQ

[Read the Strata docs](https://oplema.com/docs/strata)

**Do I need an account?**

No. You can build and run flows in your browser without an account. Sign in to keep projects with your account or use Elara.

**Where does my flow run?**

Your flow runs in your browser as a local run, or as a hosted run in your region. Database and app connections always go through Oplema's servers, even in a local run. See [pricing](https://oplema.com/pricing) for what hosted runs cost.

**What data can I use?**

Start with local files, files from URLs or a supported database or app. [Connectors](https://oplema.com/connectors) lists the available formats and connections. The [worked examples](https://oplema.com/use-cases) start from billing, ledger and ad exports.

**Do I need to write code?**

No. Build your flow with blocks. You can also add Python or R for custom calculations, or edit the flow's script directly.

**Will my work be saved?**

Your changes are saved automatically. Guest projects are deleted about 30 days after the guest session started; sign in to keep them with your account. Cloud storage limits apply.

**Can I run a flow outside Oplema?**

Yes. Export a flow as Python, install the packages listed at the top of the script and run it on your own machine. The script only reads and writes local files, so replace URL, Cloud and connector inputs first.

## Put your data to work.

Open Strata and start with a file.

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