Complete Feature Set

Everything You Need for
Excel Analytics

From Excel and CSV upload to professional dashboards, xlanalysis provides all the tools you need for comprehensive data analysis and visualization.

Data Management

Excel & CSV File Upload

Drag and drop your Excel (.xlsx) or CSV (.csv) files with automatic processing. Support for multiple files, large datasets (up to 200k rows per sheet), and smart column detection.

  • ✓Drag-and-drop interface - no setup required
  • ✓Support for both Excel (.xlsx) and CSV (.csv) files
  • ✓Multiple file upload support
  • ✓Automatic data type detection (dates, numbers, text, booleans)
  • ✓Smart column name detection and normalization
  • ✓Intelligent CSV parsing with quote and delimiter handling
  • ✓Progress tracking with real-time updates
  • ✓File validation and error handling
  • ✓Subscription-based limits and quotas

SQL Editor & Query Builder

Powerful SQL editor with syntax highlighting, query history, templates, and AI-powered query generation in plain English.

  • ✓Monaco editor with SQL syntax highlighting
  • ✓Query history with save/load functionality
  • ✓Query templates and snippets
  • ✓AI-powered natural language to SQL conversion
  • ✓Result pagination for large datasets
  • ✓Execution time tracking
  • ✓Keyboard shortcuts (Cmd+Enter to execute)
  • ✓Query optimization suggestions

Data Quality & Validation

Automatic primary key detection, type inference, relationship suggestions, and data quality scoring.

  • ✓Intelligent primary key detection with scoring
  • ✓Composite key support (two-column keys)
  • ✓Advanced type inference (dates, numbers, currency, percentages)
  • ✓Null handling and completeness tracking
  • ✓Relationship suggestions based on column patterns
  • ✓Data integrity validation
  • ✓User override capabilities

Data Modeling

Relationship Management

Visual relationship graph with drag-and-drop interface. Define relationships between tables with automatic foreign key detection.

  • ✓Visual relationship graph editor
  • ✓Drag-and-drop relationship creation
  • ✓Automatic foreign key detection
  • ✓Relationship validation and integrity checks
  • ✓One-to-many and many-to-many support
  • ✓Confidence scoring for suggestions

Measures & Calculations

Create custom measures, calculated columns, and time intelligence functions for advanced analytics.

  • ✓Custom measure creation (SUM, AVG, COUNT, etc.)
  • ✓Calculated column support
  • ✓Time intelligence functions (YTD, MTD, QTD)
  • ✓DAX-like expression builder
  • ✓Measure reuse across dashboards
  • ✓Aggregation functions

Data Model Visualization

Interactive graph view of your data model showing all tables, relationships, and connections.

  • ✓Interactive graph visualization
  • ✓Table and relationship overview
  • ✓Zoom and pan controls
  • ✓Search and filter tables
  • ✓Relationship path highlighting

Dashboard Builder

Drag-and-Drop Canvas

Professional dashboard builder with smooth drag-and-drop, pixel-perfect positioning, and resize controls.

  • ✓Smooth drag-and-drop interface
  • ✓Pixel-based positioning (no snapping)
  • ✓Resize visuals with corner handles
  • ✓12-column grid system
  • ✓Fullscreen canvas mode
  • ✓Alignment guides for precise positioning
  • ✓Multi-select with Shift+Click
  • ✓Keyboard shortcuts for movement (arrow keys)
  • ✓Keyboard shortcuts for resizing (Shift+arrow keys)

Visual Library

Rich collection of visualization types including tables, charts, matrices, and KPI cards.

  • ✓Table visual with sorting and pagination
  • ✓Matrix visual with row/column groups
  • ✓Bar, Line, Area charts
  • ✓Pie and Donut charts
  • ✓KPI cards with targets
  • ✓Custom visual configurations
  • ✓Data point click interactions
  • ✓Cross-filtering between visuals

Filters & Slicers

Global and visual-specific filters with support for multiple filter types and cross-filtering.

  • ✓Global filters applied to all visuals
  • ✓Visual-specific filters
  • ✓Multiple filter operators (equals, contains, greater than, etc.)
  • ✓Date range filters
  • ✓Cross-filtering on data point clicks
  • ✓Filter indicators on visuals
  • ✓Clear all filters option

Visual Configuration

Comprehensive visual configuration with query selection, column mapping, formatting, and styling options.

  • ✓Query selection for data source
  • ✓Column mapping (X-axis, Y-axis, series, categories)
  • ✓Visual type selection
  • ✓Color scheme customization
  • ✓Formatting options (currency, dates, numbers)
  • ✓Title and description editing
  • ✓Size and position controls

Sharing & Collaboration

One-Click Sharing

Generate shareable links instantly. Share dashboards with team members, clients, or embed in websites.

  • ✓Generate shareable links with one click
  • ✓Public or private sharing options
  • ✓Read-only shared dashboards
  • ✓No account required for viewers
  • ✓Access from any device
  • ✓Embed code generation

Export & Download

Export dashboards as images or PDFs, and export data as CSV or Excel files.

  • ✓Dashboard export as PNG/PDF
  • ✓Data export as CSV/Excel
  • ✓High-resolution image export
  • ✓Batch export options

Saved Dashboards

Save and load dashboards with auto-save functionality. Organize multiple dashboards per project.

  • ✓Save dashboards with names and descriptions
  • ✓Auto-save with 2-second debounce
  • ✓Load previously saved dashboards
  • ✓Dashboard listing and management
  • ✓Multiple dashboards per project
  • ✓Save status indicators

Security & Privacy

Enterprise-Grade Security

SOC 2 compliant infrastructure with encryption, access control, and data isolation.

  • ✓Data encryption at rest and in transit
  • ✓Complete workspace isolation
  • ✓Read-only database access
  • ✓SQL injection prevention
  • ✓Access control and permissions
  • ✓Regular security audits
  • ✓99.9% uptime guarantee
  • ✓Automated backups

Data Privacy

Your data stays private. Complete workspace separation ensures data isolation between projects.

  • ✓Project-based data isolation
  • ✓No data sharing between workspaces
  • ✓User-controlled access
  • ✓GDPR compliant
  • ✓Data retention policies

User Experience

Responsive Design

Fully responsive interface that works seamlessly on desktop, tablet, and mobile devices.

  • ✓Mobile-responsive layouts
  • ✓Touch-friendly interactions
  • ✓Adaptive UI for different screen sizes
  • ✓Mobile-optimized dashboard viewing

Keyboard Shortcuts

Power BI-like keyboard shortcuts for fast navigation and productivity.

  • ✓Navigation shortcuts (Ctrl+1, Ctrl+2, Ctrl+3)
  • ✓Canvas shortcuts (Ctrl+N for new visual, Delete, Ctrl+D for duplicate)
  • ✓SQL editor shortcuts (Ctrl+Enter to execute)
  • ✓Save shortcuts (Ctrl+S)
  • ✓Shortcuts help modal (Ctrl+K)

Performance

Optimized for speed with lazy loading, virtual scrolling, and efficient data processing.

  • ✓Fast data processing
  • ✓Optimized query execution
  • ✓Efficient rendering
  • ✓Smooth interactions
  • ✓Large dataset support

Why Choose xlanalysis?

The most comprehensive Excel-first business intelligence platform

Easy to Use

No technical skills required. Drag, drop, and share in minutes.

Fast & Powerful

Process large datasets quickly with optimized performance.

Share Instantly

One-click sharing with secure, read-only access.

Secure & Private

Enterprise-grade security with complete data isolation.

Ready to Experience All Features?

Start building professional dashboards from your Excel and CSV files today.