Skip to content

Files and storage

Connect File (CSV, JSON, Excel, Feather, Parquet) to DataxLand

The File connector reads one file from an address: public HTTPS, Google Cloud Storage, Amazon S3, Azure Blob or SFTP, in CSV, JSON, JSONL, Excel, Feather or Parquet format. It fits when your software has a fixed export link (for example an order report exported to a URL every night): DataxLand re-downloads the file on schedule, Si proposes a mapping to the standard model, and your dashboard shows net revenue, cost of goods and contribution margin with no manual uploads.

Free plan with no time limit · No card required · Sample workspace ready in minutes

What you can do with File (CSV, JSON, Excel, Feather, Parquet)

  • Refresh dashboards automatically from your sales software's fixed report export link.
  • Read a cost-of-goods table hosted on an internal URL with a public address.
  • Read Excel files stored on S3 or GCS.

What data you get

Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.

Stream (table)Contents
(Dataset Name)One stream per source, named by you; it holds the whole file.
FormatsCSV, JSON, JSONL, Excel, Feather, Parquet; reader options (Reader Options) such as the delimiter.
File locationsPublic HTTPS, GCS, S3, Azure Blob, SSH/SFTP.

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run)
Fields to fill inDataset Name, File Format, Storage Provider, URL
DeveloperAirbyte (certified), run inside DataxLand
LicenseELv2

Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.

Metrics computed from this source

Real definitions from the analytics packs; dashboards and Si share them.

MetricDefinitionUnit
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency
Cost of goods soldQuantity times unit cost on the order date (half-open validity interval). SKUs without a cost count as 0; see COGS coverage. Returned lines do not reverse their COGS.Currency
Contribution marginNet revenue minus COGS, marketplace fees, payment fees, shipping and return costs (before advertising).= Net revenue - Cost of goods sold - Marketplace fees - Payment fees - Seller-paid shipping cost - Return costCurrency
Valid ordersOrders that were not cancelled (standard status other than cancelled).Count

Connect File (CSV, JSON, Excel, Feather, Parquet) in 3 steps

  1. 1

    Prepare the file address

    Get the file's URL and, if the file sits in a storage service, read-only access credentials for it.

  2. 2

    Add the File source

    In the workspace choose Add source, find File, enter the Dataset Name, File Format, URL and Storage Provider with its access details.

  3. 3

    Test and review

    Click Test connection; Si reads a masked sample to propose a mapping, and you approve before the build.

Limits and caveats

  • Every refresh re-downloads the whole file; there is no incremental load.
  • Each source reads one file (one table); for many files, use S3, GCS or Google Drive with a path pattern, or several sources.
  • Internal network addresses are blocked; the file must be reachable from the Internet.
  • The metrics on this page are examples for a file with orders and cost of goods. Requires the Starter plan or above.

Frequently asked questions

How is this different from an Excel upload?

The Excel source takes a file you upload with a data_dictionary sheet and works on the Free plan. The File connector fetches a file from an address on a schedule.

What if the file needs a login to download?

Use an authenticated storage provider (S3, GCS, Azure Blob, SFTP) in Storage Provider; HTTPS links are for public files only.

Are large files supported?

Yes, within your plan's storage limit; for very large files use Parquet for faster loads.

Dashboard templates that use this source

All data sources →

Connect File (CSV, JSON, Excel, Feather, Parquet) and get verified dashboards

Free plan with no time limit · No card required · Sample workspace ready in minutes