You askedWill it work with my data?

Connect

If it lives in a sheet, an export or a database, Datatopple can read it.

No migration, no warehouse project, no new tool for the people who maintain the data. Datatopple reads what you already keep, where you already keep it, and never writes back.

  1. Step 1

    Pick a source

    Upload a workbook, authorise Google, or paste a read-only database connection string.

  2. Step 2

    Datatopple maps it

    It reads headers, types and sample values, then shows you how it understood each column. Rename anything it got wrong.

  3. Step 3

    Ask the first question

    Usually inside two minutes of starting. The first answer is the test: open the working and check it against what you know.

Column mapping

Messy headers are fine. It tells you what it thinks they mean.

Before your first question, Datatopple shows how it read every column. Abbreviated headers, mixed date formats and status codes like “Cxl” are mapped once and remembered.

Your columnRead asMeaningNote
Inv DtDateinvoice_dateDD-MM-YYYY detected
PartyTextcustomer_name61 distinct values
BrTextbranchSalem, Erode, Coimbatore
Net AmtCurrencynet_amountINR, 2 decimals
StsStatusstatus"Cxl" read as cancelled

Spreadsheets and files

The format most answers still live in.

Microsoft Excel

xlsx and xls workbooks, multiple sheets, merged headers and all.

Setup
Upload a workbook or point Datatopple at a OneDrive or SharePoint folder.
Refresh
On upload, or every 15 minutes for a watched folder.
Access
Read-only. The original file is never rewritten.
Handles
Named ranges, formula results, pivot source sheets, multi-row headers.

Google Sheets

Live sheets, shared drives, and sheets that three people edit at once.

Setup
Authorise with Google and pick the sheets you want readable.
Refresh
Every 5 minutes, or on demand when you ask a question.
Access
Viewer scope only. Datatopple cannot edit or share your sheets.
Handles
Tab-per-month layouts, filter views, IMPORTRANGE results.

CSV and TSV

Exports from any system that can produce a flat file.

Setup
Drop files in, or let Datatopple pick them up from an SFTP folder.
Refresh
On arrival.
Access
Read-only.
Handles
Mixed delimiters, quoted commas, inconsistent date formats.

Accounting and ERP exports

Where the numbers are already reconciled.

Tally exports

Day book, sales register, receivables and payables ledgers.

Setup
Export from Tally as XML or Excel and drop it in, or schedule the export.
Refresh
Nightly if scheduled, otherwise on upload.
Access
Read-only. Datatopple never writes back to Tally.
Handles
Ledger groupings, cost centres, voucher types, branch tagging.

Zoho Books and QuickBooks

Invoices, bills, chart of accounts and payment history.

Setup
Connect through the vendor API with a read scope token.
Refresh
Hourly.
Access
Read-only scope requested at authorisation.
Handles
Multi-currency, tax splits, credit notes.

Busy and Marg exports

Stock registers, purchase books and GST summaries.

Setup
Scheduled Excel export into a watched folder.
Refresh
On arrival.
Access
Read-only.
Handles
Godown-wise stock, batch numbers, HSN grouping.

Databases and warehouses

For when the data already has a schema.

MySQL and MariaDB

Direct read access to the tables you whitelist.

Setup
Create a read-only user, whitelist our IP, paste the connection string.
Refresh
Live. Every question runs against current data.
Access
SELECT only. Datatopple refuses to start if the user has write grants.
Handles
Views, large tables, joins across whitelisted schemas.

PostgreSQL

Schemas, views and materialised views.

Setup
Read-only role plus connection string, or an SSH tunnel.
Refresh
Live.
Access
SELECT only, enforced at the connection layer.
Handles
Row-level security, partitioned tables, JSON columns.

SQL Server and BigQuery

Warehouse-scale reads without a modelling layer.

Setup
Read-only credentials or a service account with viewer role.
Refresh
Live, with result caching for repeated questions.
Access
Read-only.
Handles
Billions of rows, partition pruning, cost guardrails.
Read-only, by construction

It cannot change your data. Not “will not”. Cannot.

Read-only is enforced at four separate layers, so a mistake in one never becomes a write to your books.

Read scopes only

Google and accounting connections request view-only scopes. There is no permission to grant that would let Datatopple edit.

Write grants are refused

For databases, Datatopple checks the connected user on every connection. If it holds INSERT, UPDATE, DELETE or DDL rights, the connection is rejected until you supply a read-only user.

Every query is a SELECT

Generated queries are parsed before they run. Anything that is not a read statement is blocked at the parser, not by trust.

You choose what is visible

Whitelist sheets, tables or individual columns. Salary columns can be hidden from everyone except the seats you name.

Freshness

How current is each answer?

Every answer prints the time its source was last synced, so nobody mistakes last night’s numbers for this morning’s.

DatabasesLiveEvery question runs against current data
Google SheetsEvery 5 minutesOr on demand when you ask
Watched Excel folderEvery 15 minutesOneDrive and SharePoint
Accounting APIsHourlyZoho Books, QuickBooks
Scheduled exportsOn arrivalTally, Busy, Marg, CSV via SFTP
The question you keep putting off

Type it. Get the answer.

No dashboard to build, no analyst to brief, no 40-tab workbook to open first. Connect a source and your first answer lands in about two minutes.

Want to see it against your own workbook first? Contact us

  • Read-only connections
  • Source and rows on every answer
  • Never used to train models