BaseToolbox LogoBaseToolbox
Blog

© 2025 BaseToolbox. All rights reserved.

Privacy PolicyAboutContact Us
  1. Home
  2. /
  3. Ecommerce Spreadsheet Analyzer

Ecommerce Spreadsheet Analyzer

Analyze sales, costs, fees, refunds, and advertising data from CSV, TSV, or XLSX files in your browser. Calculations are deterministic, missing inputs are disclosed, currencies stay separate, and local AI only explains the calculated evidence.

Saved sessions

Drop an ecommerce CSV, TSV, or XLSX file here

The file stays in this browser. Legacy .xls files are not supported.

Private, browser-local ecommerce analysis

The source report, mappings, calculations, saved session, and optional AI explanation stay in your browser and are excluded from BaseToolbox analytics. Source files use persistent browser file storage when available; verified model weights are cached by version.

Current limitations
  • CSV, TSV, and modern XLSX files are supported; legacy .xls, macros, and desktop-Excel formula recalculation are not.
  • Metrics depend on the mapped export fields. Missing costs, platform fees, payment fees, refunds, fulfillment costs, or ad spend are explicitly marked not included and are never estimated.
  • Currencies are calculated separately without exchange-rate conversion. Date trends accept unambiguous ISO dates; unsupported dates are reported and excluded.
  • Browser storage can be cleared or reclaimed, and private browsing may not retain sessions, source files, or downloaded model weights.

How the local ecommerce analyzer works

1

Import and map actual report fields

The browser parses your file, suggests likely fields, and waits for you to confirm the columns and number format.

2

Calculate deterministically

A decimal-based rules engine calculates each currency separately and records valid, invalid, missing, and not-included inputs for every metric.

3

Inspect, explain, and export

Review metrics, coverage, and the monthly trend. The shared local AI may explain only those results, and CSV, XLSX, or Markdown exports preserve the disclosures.

Ecommerce spreadsheet analyzer FAQ

Does BaseToolbox upload my ecommerce report?
Will the tool estimate missing costs or marketplace fees?
Does AI calculate profit, ROAS, or refund rate?
Will the downloaded local AI model survive a refresh?

Related local tools

Generate product descriptions in bulkAnalyze a general spreadsheet