Files and storage
Connect Excel to DataxLand
An Excel file is the fastest way to start with DataxLand, including on the Free plan. Each sheet is a table (orders, order lines, products, costs, expenses…), and a data_dictionary sheet describes each column - table, column, meaning, whether it holds personal data. Si reads that description with a masked sample to propose how to read the data and map it to your industry's standard model; you approve before anything is built.
Free plan with no time limit · No card required · Sample workspace ready in minutes
What you can do with Excel
- Get a profit dashboard straight from your sales software export or your bookkeeping file.
- Combine multi-channel orders exported to Excel with the cost table you maintain.
- Add product cost, fixed costs or targets for connected sources that lack them.
- Try DataxLand on real data before connecting a marketplace or a database.
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 |
|---|---|
| <sheet name> | Each sheet becomes its own table, first row as column names, your column names kept. |
| data_dictionary | Column descriptions (table, column, meaning, pii = Y for personal columns); Si uses them and asks fewer questions. |
Connection details
| Sign-in method | File upload |
|---|---|
| Sync modes | Full (reloaded each run) |
| Developer | DataxLand |
| License | proprietary |
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 |
| GMV (gross merchandise value) | Total quantity times unit price of the order lines in valid orders (before discounts, vouchers and refunds). | Currency |
| Valid orders | Orders that were not cancelled (standard status other than cancelled). | Count |
| Average order value | Line revenue after discounts divided by valid orders.= line_net_total / Valid orders | 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 |
| COGS coverage | Share of line revenue (after discounts) coming from SKUs that have a cost. Below 100% means the profit metrics are overstated.= line_net_with_cost / line_net_total | Ratio (%) |
| 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 |
| Net profit after fees and ads | Net revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spend | Currency |
| Units sold | Total quantity of products in the order lines of valid orders. | Count |
Connect Excel in 3 steps
- 1
Prepare the file
One sheet per table, first row as column names; add a data_dictionary sheet (table, column, description, pii = Y for personal columns).
- 2
Upload
In the workspace choose Add source → Excel file and upload the .xlsx.
- 3
Review Si's proposal
See how Si reads each table, fix the highlighted parts, answer the multiple-choice questions and approve to build.
Limits and caveats
- Excel is a full load only; upload the file again when numbers change. For scheduled refresh use Google Sheets, a marketplace or a database.
- Columns marked pii = Y are hashed on load; Si only sees a masked sample.
- Storage follows your plan; the Free plan takes one source, Excel only.
Frequently asked questions
How do I update the data?
Upload the new file; DataxLand rebuilds on it. For scheduled refresh, connect Google Sheets, a marketplace or a database.
Is there a file size limit?
It follows your plan's storage; the Free plan takes one Excel file.
What if there is no data_dictionary sheet?
It still works; Si guesses from column names and sample data but asks you more questions at review.
Dashboard templates that use this source
Connect Excel and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes