---
title: "Import files and data into Strata | Oplema"
description: "Load a table into Strata from a file, a URL, Cloud, a bundled example dataset or a connector such as Postgres, Google Sheets or Stripe."
url: "https://oplema.com/docs/strata/io/input"
updated: "2026-11-14"
---

# Input

Input starts a flow by loading a table. It reads a file from your computer, a public file URL, a file in Cloud, a bundled example dataset or a database or app through a connector.

**Learn this in context:** [Build your first data flow from a CSV](https://oplema.com/learn/export-to-report/first-data-flow); [Load a CSV file into a data flow](https://oplema.com/learn/export-to-report/load-a-csv-file) (Build a report from a CSV export); [Move a flow's files to Cloud and rerun it](https://oplema.com/learn/table-to-dashboard/move-files-to-cloud) (Build and publish a dashboard)

## Load an example dataset

Input is set to File, then Example, with the Retail Stores dataset. Example datasets are bundled with Oplema, so they load with no file or account.

Result
| store\_id | store\_name | city | country | store\_format |
| --- | --- | --- | --- | --- |
| 1 | Nordlight Copenhagen | Copenhagen | Denmark | High street |
| 2 | Nordlight Aarhus | Aarhus | Denmark | High street |
| 3 | Nordlight Odense | Odense | Denmark | Outlet |
| 4 | Nordlight Aalborg | Aalborg | Denmark | High street |
| 5 | Nordlight Stockholm | Stockholm | Sweden | High street |
| 6 | Nordlight Gothenburg | Gothenburg | Sweden | Outlet |
| 7 | Nordlight Malmo | Malmo | Sweden | High street |
| 8 | Nordlight Uppsala | Uppsala | Sweden | High street |

1. Look at the preview. It reports 40 rows and 5 columns, and the first row is store 1, Nordlight Copenhagen.
2. Open Dataset and choose `Coffee Ratings`. The preview reloads with that table, so its row count and columns change.
3. Select Connectors under Source. The menu that appears lists the services Input can read. Connecting an account works in the editor, not in this example.

## When to use

Use Input whenever your data already exists somewhere: a CSV on your computer, a file in Cloud, a database table or records in an app such as Stripe or HubSpot. To type a small table by hand, use Manual Input. To read a value someone sets on a dashboard, use Vista Parameter.

## Choose a source

Pick one of the three options under Source.

- File: Local File reads a file from your computer, File from URL reads a public link to a file and Example loads a bundled dataset.
- Cloud: reads a data file stored in [your Cloud](https://oplema.com/docs/cloud/files).
- Connectors: reads from a database or app through a saved connection.

Input reads CSV, compressed CSV, TSV, text, JSON, JSON Lines, Parquet, Arrow, Excel and DuckDB files. Excel and delimited files show further settings, such as the sheet, separator and header row.

## Connectors

Read the [connector guides](https://oplema.com/docs/strata/io/connectors) for setup, permissions and limits.

- **Sheets and files:** [Google Sheets](https://oplema.com/docs/strata/io/connectors/google-sheets), [OneDrive](https://oplema.com/docs/strata/io/connectors/onedrive), [Dropbox](https://oplema.com/docs/strata/io/connectors/dropbox), [HTTP](https://oplema.com/docs/strata/io/connectors/http).
- **Databases:** [Supabase](https://oplema.com/docs/strata/io/connectors/supabase), [SQL Server](https://oplema.com/docs/strata/io/connectors/sql-server), [Postgres](https://oplema.com/docs/strata/io/connectors/postgres), [MySQL](https://oplema.com/docs/strata/io/connectors/mysql), [BigQuery](https://oplema.com/docs/strata/io/connectors/bigquery), [Snowflake](https://oplema.com/docs/strata/io/connectors/snowflake), [Databricks](https://oplema.com/docs/strata/io/connectors/databricks).
- **Apps:** [Stripe](https://oplema.com/docs/strata/io/connectors/stripe), [HubSpot](https://oplema.com/docs/strata/io/connectors/hubspot), [Airtable](https://oplema.com/docs/strata/io/connectors/airtable), [Notion](https://oplema.com/docs/strata/io/connectors/notion), [QuickBooks](https://oplema.com/docs/strata/io/connectors/quickbooks), [Xero](https://oplema.com/docs/strata/io/connectors/xero).

## What connector downloads cost

The first 50 MB of each download are free. Additional data costs $0.01 per GB and needs available usage. A download that needs more than you have available stops with an error. Project viewers (Viewer role) always stop at 50 MB.

To type a small table instead of loading one, use [Manual Input](https://oplema.com/docs/strata/io/manual-input).

To send the finished table somewhere, use [Output](https://oplema.com/docs/strata/io/output).

## Inputs and outputs

### Inputs

0 ports

No input ports

This block has no incoming connection.

### Outputs

1 port

**Out**

## Configure the block

All 136 settings

**Source**

Where the table comes from.

Default: `File`

Options: File, Cloud, Connectors.

**File source**

Where the file comes from: your computer (Local File), a public link (File from URL) or a bundled dataset (Example).

Default: `Local File`

Options: Local File, File from URL, Example.

**Dataset**

Bundled example dataset.

Default: `Coffee Ratings`

Options: Coffee Ratings, NYC Squirrel Census, Retail Orders, Retail Sales, Retail Stores, Sales: orders, Sales: refunds, Monthly demand (sample), Contacts, Bike Share (sample), Profitability: orders, Profitability: costs, Cups sold, Orders over time, Fundraising, Team utilization, Website response time, Regional orders, Cups by day and drink, Cups through the week, Tea and coffee through the week, Customer wait times, Warm days and cold drinks, Drink price, sales and revenue, Cold drink sales, Units by department and item, Survey answers, Cups by store and drink, Three measurements, Daily orders, Bike ratings, Compare three electric cars, A small website project, Product launch milestones, Four orders, A tiny data quality example.

**File**

Path to the input file. Supported types: csv, csv.gz, tsv, txt, json, jsonl, ndjson, parquet, arrow, ipc, xls, xlsx, xlsm, xlsb, duckdb

**URL**

Public file URL. Supported types: csv, csv.gz, tsv, txt, json, jsonl, ndjson, parquet, arrow, ipc, xls, xlsx, xlsm, xlsb, duckdb. Paste a direct file link and press Enter or Load. Reload refreshes the preview and preserves import settings. Full runs download fresh data.

**Cloud File**

Data file stored in Cloud.

**Connector**

Connector to load from.

Default: `Google Sheets`

Options: Google Sheets, OneDrive, Dropbox, HTTP, Supabase, SQL Server, Postgres, MySQL, BigQuery, Snowflake, Databricks, Stripe, HubSpot, QuickBooks, Xero, Airtable, Notion.

**Connection**

The help for this setting changes with the connector you choose.

**Connection**

• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. For Excel, the whole workbook counts.

**Connection**

• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. For Excel, the whole workbook counts.

**Connection**

• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage.

**Path**

Path and URL-encoded query below the connection URL.

**Method**

Default: `GET`

Options: GET, POST.

**Body**

JSON request body. Leave empty to send none.

**Format**

Format of the response.

Default: `JSON`

Options: JSON, JSON Lines, CSV, Parquet.

**Connection**

• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Reads accounting records; attachments contain metadata only. • Use Parse → JSON for nested details: Unnest object for fields, or Flatten array then Unnest object for lists. • Lines can include discounts and subtotals; summing every line may give the wrong total.

**Object**

QuickBooks Online records to load, including supplied totals and nested details.

**Active status**

All includes inactive records needed for historical transactions.

Default: `All records`

Options: All records, Active only, Inactive only.

**Transaction from**

Inclusive transaction date, not last modified. Leave blank for no limit.

**Transaction to**

Inclusive transaction date, not last modified. Leave blank for no limit.

**Rows**

Records retains reported totals and every returned detail. Line items includes all top-level line types; summing lines doesn't necessarily equal the transaction total. Parent totals remain in Records; join using ParentId and CompanyId.

Default: `Records`

Options: Records, Line items.

**Connection**

• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Reads accounting records and supported reports; aged reports require a contact. • Use Parse → JSON for nested details: Unnest object for fields, or Flatten array then Unnest object for lists. • Line amounts don't necessarily add up to reported totals.

**Organisation**

Xero organisation the login can reach.

**Object**

Xero list to load.

**Type**

All invoice types, sales invoices or purchase bills.

Default: `All`

Options: All, Sales invoices, Purchase bills.

**Status**

All includes archived records.

Default: `All records`

Options: All records, Active only, Archived only.

**From**

Inclusive transaction date, or required reporting period for Profit and Loss.

**To**

Inclusive transaction date, or required reporting period for Profit and Loss.

**As of date**

Required report date.

**Accounting basis**

Basis used by Xero for this report.

Default: `Accrual`

Options: Accrual, Cash.

**Contact**

Contact for the aged report.

**Rows**

Records preserves source totals and nested data. Line items retains every line without repeating parent totals.

Default: `Records`

Options: Records, Line items.

**Connection**

• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Copy the Project URL from Supabase → Connect and a secret key from Settings → API Keys. Secret keys can bypass row-level security. • Input and Output can share a connection. A PostgreSQL connection string is required only for Output. • Reads tables and views exposed through your project’s Data API. • A custom schema must be exposed separately, even if Output can write to it.

**Table or view**

Table or view exposed by the project's Data API.

**Columns**

Read every column, or only the ones you select.

Default: `All columns`

Options: All columns, Selected columns.

**Columns**

Columns to read when Columns is set to Selected columns.

**Date column**

Both bounds include the whole day. Timestamps with a timezone use UTC; other date fields use stored calendar dates.

**From**

First day to read from the date column, inclusive. Optional.

**To**

Last day to read from the date column, inclusive. Optional.

**API schema**

Leave blank to use the Data API’s default schema. For a custom schema, add it to Exposed schemas in Supabase’s Data API settings. Grant your API role USAGE on the schema and SELECT on its tables. Enter the exact schema name and refresh the table list. Writing to a schema doesn't expose it automatically.

**Connection**

• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Create a restricted key in Stripe Dashboard → API keys, with Read access to the objects you need; Write access is unnecessary. Test keys read test data; live keys read live data. • Use Parse → JSON for nested details: Unnest object for fields, or Flatten array then Unnest object for lists.

**Object**

Native Stripe objects to load.

**Created from**

Filter object creation dates in UTC; leave empty for no boundary.

**Created to**

Filter object creation dates in UTC; leave empty for no boundary.

**Status**

Choose subscription status or active/inactive catalog prices. Stripe excludes inline prices from its Prices list.

Default: `All statuses`

Options: All statuses, Active, Inactive, Canceled, Incomplete, Incomplete expired, Past due, Paused, Trialing, Unpaid.

**Load complete line items**

Fetch missing invoice, credit-note or subscription items. Additional pages can increase loading time. Items remain nested JSON.

Default: `false`

**Connection**

• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Use SQL username/password authentication and a host with port, or host\\instance without a port. Verify server certificates in production. • Your administrator must allow Oplema’s backend network access and database permissions. • Consistency follows your database’s configured isolation.

**Schema**

Schema that holds the table or view to read.

Default: `dbo`

**Table or view**

Table or view to read.

**Columns**

Read every column, or only the ones you select.

Default: `All columns`

Options: All columns, Selected columns.

**Columns**

Columns to read when Columns is set to Selected columns.

**Date column**

Both bounds include the whole day. DATETIMEOFFSET uses UTC; other date fields use stored calendar dates.

**From**

First day to read from the date column, inclusive. Optional.

**To**

Last day to read from the date column, inclusive. Optional.

**Connection**

• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Use your administrator’s host, port, database and database-user credentials, with the required TLS setting. • Your administrator must allow Oplema’s backend network access and database permissions. Local/private databases need a route from that backend. • Reads one consistent snapshot. • Transfer charges don't include your database's own costs.

**Schema**

Schema that holds the table or view to read.

Default: `public`

**Table or view**

Table or view to read.

**Columns**

Read every column, or only the ones you select.

Default: `All columns`

Options: All columns, Selected columns.

**Columns**

Columns to read when Columns is set to Selected columns.

**Date column**

Both bounds include the whole day. Timestamps with a timezone use UTC; other date fields use stored calendar dates.

**From**

First day to read from the date column, inclusive. Optional.

**To**

Last day to read from the date column, inclusive. Optional.

**Connection**

• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Use your administrator’s host, port, database and database-user credentials, with the required TLS setting. • Allow Oplema’s backend network access and the MySQL user’s connecting host. Local/private databases need a route from that backend. • InnoDB reads use one consistent snapshot. Nontransactional data can change during loading.

**Table or view**

Table or view to read from the connection's database.

**Columns**

Read every column, or only the ones you select.

Default: `All columns`

Options: All columns, Selected columns.

**Columns**

Columns to read when Columns is set to Selected columns.

**Date column**

Both bounds include the whole day. TIMESTAMP uses UTC; DATETIME uses stored calendar dates.

**From**

First day to read from the date column, inclusive. Optional.

**To**

Last day to read from the date column, inclusive. Optional.

**Connection**

• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Use your account identifier, programmatic access token and optional warehouse; blank uses your Snowflake default. • The token needs warehouse/data access, and network policies must allow Oplema’s backend. Replace an expired token by creating a connection with a new one. • Transfer charges don't include warehouse compute costs, which your provider bills.

**Database**

Database that holds the table or view to read.

**Schema**

Schema that holds the table or view to read.

**Table or view**

Table or view to read.

**Columns**

Read every column, or only the ones you select.

Default: `All columns`

Options: All columns, Selected columns.

**Columns**

Columns to read when Columns is set to Selected columns.

**Date column**

Both bounds include the whole day. Zoned timestamps use UTC; unzoned timestamps use stored calendar dates.

**From**

First day to read from the date column, inclusive. Optional.

**To**

Last day to read from the date column, inclusive. Optional.

**Connection**

• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Find Server hostname and HTTP path in SQL Warehouses → your warehouse → Connection details. • Use a personal access token with warehouse/data access; create a connection with a new token when it expires. Allow Oplema’s backend to access the workspace and download query results. • Transfer charges don't include compute costs, which your provider bills.

**Catalog**

Catalog that holds the schema to read.

**Schema**

Schema that holds the table or view to read.

**Table or view**

Table or view to read.

**Columns**

Read every column, or only the ones you select.

Default: `All columns`

Options: All columns, Selected columns.

**Columns**

Columns to read when Columns is set to Selected columns.

**Date column**

Both bounds include the whole day. TIMESTAMP uses UTC; DATE and TIMESTAMP\_NTZ use stored calendar dates.

**From**

First day to read from the date column, inclusive. Optional.

**To**

Last day to read from the date column, inclusive. Optional.

**Connection**

• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • A selected view filters and orders records; hidden fields are still included. • Linked records and attachment contents aren't downloaded automatically.

**Base**

Airtable base to read.

**Table**

All fields are included.

**View**

Use an Airtable view to filter and order records. Fields hidden in the view are still included.

**Connection**

• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Share the data source with your Notion connection. • Reads database properties, not page bodies or attachment contents.

**Data source**

Share the data source with your Notion connection.

**Calculated values**

Standard uses values returned with rows. Retrieve calculation details makes extra requests and can be slower; Notion may not support every calculation.

Default: `Standard`

Options: Standard, Retrieve calculation details.

**Connection**

• The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. • Loads the authorized properties you select. • Related record links contain IDs and labels, not the related records’ other fields.

**Object**

Reconnect to grant access to additional objects.

**Archived only**

Read archived records only. Off reads active records.

Default: `false`

**Columns**

Choose columns to load, or explicitly include every authorized property.

Default: `All columns`

Options: Selected columns, All columns.

**Columns**

Choose the HubSpot properties to include. Record metadata is always included.

**Related record links**

Includes related record IDs and relationship labels, not the related records’ other columns.

**Spreadsheet**

Google Sheet to load.

**Tab**

Sheet tab to load; its used cells are imported.

**Project selection**

Pick from your projects, or enter a project ID directly. Use the ID, not the display name.

Default: `Choose project`

Options: Choose project, Enter project ID.

**Project**

Project that holds the dataset to read.

**Project ID**

Google Cloud project ID, not its display name.

**Dataset**

Dataset that holds the table or view to read.

**Table or view**

Table or view to read.

**Columns**

Read every column, or only the ones you select.

Default: `All columns`

Options: All columns, Selected columns.

**Columns**

Columns to read when Columns is set to Selected columns.

**Date column**

Both bounds include the whole day. TIMESTAMP uses UTC; DATE and DATETIME use stored calendar dates.

**From**

First day to read from the date column, inclusive. Optional.

**To**

Last day to read from the date column, inclusive. Optional.

**Query / billing project**

Leave blank to run and bill queries in the data project.

**Maximum query size (GiB)**

Maximum bytes Google may bill per query. Separate from download pricing and the available usage credit.

Default: `1`

**Folder**

OneDrive folder; its files are listed next.

**File**

OneDrive file to load. Supported types: csv, csv.gz, tsv, txt, json, jsonl, ndjson, parquet, arrow, ipc, xls, xlsx, xlsm, xlsb, duckdb

**Folder**

Dropbox folder; its files are listed next.

**File**

Dropbox file to load. Supported types: csv, csv.gz, tsv, txt, json, jsonl, ndjson, parquet, arrow, ipc, xls, xlsx, xlsm, xlsb, duckdb

**Refresh data**

Reload the selected data.

**Sheet**

Excel sheet to read. A workbook with one usable sheet selects it automatically.

**Table**

Database table to import.

**Area**

Part of the sheet to read: detected automatically, or a custom range such as A1:H500.

**Range**

Rectangular cell address to import.

**Headers**

Automatic detects headers. First row uses the first row as column names. No header generates names.

Options: Automatic, First row, No header.

**Separator**

Empty detects the separator. TSV defaults to tab.

Options depend on the connected data and configuration.

**Headers**

Automatic detects headers. First row uses the first row as column names. No header generates names.

Options depend on the connected data and configuration.

**Starting row**

First row to read, counting from 1.

Default: `1`

**Custom separator**

Character that separates columns in a delimited file when the separator is custom.

**Encoding**

Empty uses UTF-8 or a Unicode BOM. Supports utf-8, utf-16le, utf-16be, windows-1252.

Options: Automatic (UTF-8/BOM), UTF-8, UTF-16 LE, UTF-16 BE, Windows-1252.

**Quote**

Empty detects quoting; none disables it.

**Escape**

Empty detects escaping; none disables it.

**Decimal separator**

Period or comma. Empty uses a period.

Options: Period (default), Period, Comma.

**Date format**

Optional strptime date format, such as %d/%m/%Y.

**Null marker**

Empty unquoted fields are null by default; quoted empty strings remain strings. Enter a literal marker to replace the default.

**Read as text**

Keep original CSV field text before numeric or date conversion.

Default: `false`

**Records**

Empty chooses unambiguous records. $ reads the root; /data selects a JSON Pointer.

## Input FAQs

**What can Input read?**

A file from your computer, a public file URL, a file in Cloud, a bundled example dataset or a table or list from a connector.

**What does loading data through a connector cost?**

The first 50 MB of each connector download are free. Additional data is charged at the transfer price and needs available usage. Query costs in BigQuery, Snowflake and Databricks are billed separately by those services.

**Does connector data stay in my browser?**

No. Connector traffic passes through Oplema servers, even when the rest of the flow runs in your browser.

**How do I get the latest data?**

Select Refresh data on the Input block to fetch the selected connector data again.

### 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)
