Skip to main content
Built-in

Upload CSV, Excel & JSON Files

Drag-and-drop any data file and get AI-powered dashboards in seconds. No connectors, no configuration, no waiting. clariBI auto-detects your file format and creates a queryable dataset instantly.

Supports CSV, TSV, Excel (.xlsx), JSON, and XML with automatic delimiter detection, column typing, and header identification. Available on every plan including Free.

The universal data source

File upload is the fastest way to get data into clariBI. Every tool you use can export to CSV or Excel: CRM reports, accounting exports, marketing data, survey results, inventory lists, or any other tabular data. If it fits in a spreadsheet, clariBI can analyze it.

clariBI accepts CSV, TSV, Excel (.xlsx), JSON, and XML files. When you upload a file, clariBI automatically detects the format, identifies column headers, infers data types (dates, numbers, text, booleans), and creates a clean, queryable dataset. For CSV files, delimiter detection handles commas, semicolons, tabs, and pipes without any manual configuration.

Once your data is imported, clariBI's AI preprocessor analyzes the dataset and automatically generates data insight dashboards with relevant charts and KPIs. You can then use conversational analytics to ask follow-up questions, build custom dashboards, and generate reports.

File upload is available on every plan, including Free and Trial. It is the easiest way to try clariBI with your own data, and it requires no technical setup or external configuration.

How to upload files to clariBI

The entire process takes under a minute. No connectors to configure, no credentials to manage, no network setup required.

1

Open Data Sources and click "Add Data Source"

From your clariBI workspace, navigate to Data Sources in the left sidebar. Click the + Add Data Source button in the top-right corner of the page. You will see a categorised list of all supported integrations.

2

Select "File Upload"

Under the Files category, click the File Upload tile. The upload area will open, ready to accept your file.

3

Drag-and-drop your file

Drop a CSV, Excel, JSON, TSV, or XML file into the upload area, or click to browse. clariBI detects the file format automatically. For CSV files, delimiter detection handles commas, semicolons, tabs, and pipes without any manual configuration.

4

Automatic processing and schema detection

clariBI identifies columns, detects data types (dates, numbers, text, booleans), and creates a clean dataset. You can review the detected schema before confirming. The AI preprocessor then analyzes your data and generates data insight dashboards automatically with relevant charts and KPIs.

5

Ask questions in plain English

Use conversational analytics to explore your data: "What is the average order value by region?", "Show monthly revenue trend", "Which product has the highest margin?" clariBI's AI engine answers instantly using your uploaded data.

What you can do with uploaded files

Once uploaded, your file becomes a full data source in clariBI with access to every analytics feature on the platform.

  • Plain-English queries on any uploaded dataset

    Ask questions like "Show me total sales by product category for Q3" and get instant chart-ready answers.

  • Auto-generated data insight dashboards

    clariBI's AI preprocessor analyzes your file and creates dashboards with relevant charts and KPIs automatically after upload.

  • Automatic delimiter and type detection

    CSV delimiters (comma, semicolon, tab, pipe), column types, headers, and encoding are all detected without manual configuration.

  • 440+ pre-built analysis templates

    Finance, sales, marketing, HR, operations: choose from 440+ templates across 30 business categories and apply them to your uploaded data.

  • Five file formats supported

    CSV, TSV, Excel (.xlsx), JSON, and XML files are all accepted. Upload any format and clariBI handles the rest.

  • Combine files with other data sources

    Use uploaded files alongside database connections, API integrations, and other sources in multi-source dashboards.

  • Scheduled reports from uploaded data

    Generate recurring reports from your uploaded datasets. Schedule email delivery and share dashboards with your team.

  • Available on every plan including Free

    File upload works on all plans, from Free to Enterprise. Start analyzing your own data in under a minute with zero cost.

Supported formats

clariBI accepts five file formats. Each is automatically detected on upload with no manual configuration required.

Format Details
CSV Comma-separated values with automatic delimiter detection (comma, semicolon, tab, pipe)
TSV Tab-separated values; detected automatically from file content
Excel (.xlsx) Microsoft Excel spreadsheets; multi-sheet workbooks supported
JSON JSON arrays or nested objects; automatically flattened into tabular form
XML XML data files with automatic element-to-column mapping

Use cases

Every tool you use can export data as a file. Upload those exports to clariBI and turn static spreadsheets into interactive analytics.

CRM Exports

Export contacts, deals, or activity from any CRM (Salesforce, HubSpot, Pipedrive) as CSV and analyze pipeline, win rates, and customer trends in clariBI.

Accounting Data

Upload transaction exports from QuickBooks, Xero, or your bank to visualize cash flow, expenses, and revenue. Ask "What were our top 5 expense categories last quarter?" and get an instant answer.

Marketing Reports

Import campaign data from any ad platform, email tool, or social media export for cross-channel analysis. Compare performance across campaigns in a single dashboard.

Survey Results

Upload survey exports from SurveyMonkey, Typeform, or Google Forms for visual analysis and cross-tabulation. Identify patterns across demographic groups instantly.

Inventory Data

Analyze product catalogues, stock levels, and supplier data from Excel exports. Track which items are running low and identify top-selling products by location.

Any Tabular Data

If it fits in a spreadsheet, clariBI can analyze it. Employee records, event logs, sensor data, research results, or any other structured dataset you can export as a file.

Security & data handling

Your uploaded files are processed securely and stored within your clariBI workspace. Here is how clariBI protects your data.

Security measures

  • Encrypted storage

    Uploaded files are stored with encryption at rest in clariBI's secure storage infrastructure. Files are isolated per organization and never shared across workspaces.

  • TLS in transit

    All file uploads are transmitted over HTTPS with TLS encryption. Your data is protected from the moment you drag it into the browser until it reaches clariBI's servers.

  • Organization-level isolation

    Each organization's files are stored in isolated containers. Only authenticated members of your workspace can access uploaded data.

  • Audit logging

    All file uploads, deletions, and queries are logged in clariBI's audit trail, visible to workspace administrators at any time.

  • RBAC access controls

    Control which team members can upload, view, and query file-based data sources using clariBI's role-based access control system (Professional plan and above).

How it works

  • Format auto-detection

    clariBI reads the file header and content to determine the format (CSV, TSV, Excel, JSON, XML) without relying on the file extension alone.

  • Delimiter detection

    For CSV files, clariBI automatically detects the delimiter (comma, semicolon, tab, pipe) by analyzing the first rows of the file.

  • Column type inference

    Dates, numbers, percentages, currencies, booleans, and text are detected automatically. You can override detected types before confirming the import.

  • Header identification

    clariBI detects whether the first row contains column headers or data. If headers are missing, clariBI generates descriptive column names automatically.

  • AI-powered preprocessing

    After import, clariBI's AI engine analyzes your data and generates data insight dashboards with charts and KPIs tailored to your dataset.

Available on every plan

File upload works on every clariBI plan, including Free. No extra fees, no add-on charges. Upload limits scale with your plan.

Plan File uploads Storage
Free 5 files 1 GB
Trial (14 days) 5 files 1 GB
Starter ($99/mo) 50 files 5 GB
Professional ($199/mo) 500 files 10 GB
Enterprise ($999/mo) 5,000 files 100 GB

Annual billing saves up to 17% • All plans include unlimited dashboards, reports, and conversational analytics within your plan's limits • See full pricing details

Upload a file and see results in seconds

Sign up free and have your first dashboard live today. No credit card required.

5 formats supported • Auto-generated dashboards • Available on every plan including Free • 440+ analysis templates