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. |
| Formats | CSV, JSON, JSONL, Excel, Feather, Parquet; reader options (Reader Options) such as the delimiter. |
| File locations | Public HTTPS, GCS, S3, Azure Blob, SSH/SFTP. |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) |
| Fields to fill in | Dataset Name, File Format, Storage Provider, URL |
| Developer | Airbyte (certified), run inside DataxLand |
| License | ELv2 |
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.
| Metric | Definition | Unit |
|---|---|---|
| Net revenue | Line value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here. | Currency |
| Cost of goods sold | Quantity 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 margin | Net 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 cost | Currency |
| Valid orders | Orders that were not cancelled (standard status other than cancelled). | Count |
Connect File (CSV, JSON, Excel, Feather, Parquet) in 3 steps
- 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
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
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
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