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.
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.
Select "File Upload"
Under the Files category, click the File Upload tile. The upload area will open, ready to accept your file.
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.
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.
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