Skip to content

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_dictionaryColumn descriptions (table, column, meaning, pii = Y for personal columns); Si uses them and asks fewer questions.

Connection details

Sign-in methodFile upload
Sync modesFull (reloaded each run)
DeveloperDataxLand
Licenseproprietary

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
GMV (gross merchandise value)Total quantity times unit price of the order lines in valid orders (before discounts, vouchers and refunds).Currency
Valid ordersOrders that were not cancelled (standard status other than cancelled).Count
Average order valueLine revenue after discounts divided by valid orders.= line_net_total / Valid ordersCurrency
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
COGS coverageShare 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_totalRatio (%)
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
Net profit after fees and adsNet revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spendCurrency
Units soldTotal quantity of products in the order lines of valid orders.Count

Connect Excel in 3 steps

  1. 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. 2

    Upload

    In the workspace choose Add source → Excel file and upload the .xlsx.

  3. 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

Ask Si about your Excel data →Excel + Facebook Marketing →Excel + Shopee →All data sources →

Connect Excel and get verified dashboards

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