Universal Data Ingestion
Break the barriers of file formats. Learn how BlazeXL ingests data from Excel, CSV, JSON, and Web tables via a normalized layer.
Universal Data Ingestion
The BlazeXL workflow begins with a Normalized Ingestion Layer. We believe that your decision logic (Blaze Blocks) should be decoupled from your data source.
Whether your data is trapped in an old Excel file, a JSON API, or a table on a website, BlazeXL can ingest it and prepare it for execution on the Execution Grid.
Supported Entry Points
1. Excel
Our deep integration with Microsoft Excel allows you to stream ranges directly to the grid.
- Active Selection: Select
A1:D100and "Send to BlazeXL Analyst" - Dynamic Ranges: Use named ranges or tables that expand as data grows. Create data using
=BLAZEXL.DATA(sales_data)and click to send to dashboard.
2. Universal Clipboard (Copy-Paste)
One of our most powerful features. Copy any tabular data from:
- Websites
- Spreadsheets
- PDF documents
- Messaging apps (Slack, Teams) Then, simply Paste into the Web Dashboard. The normalization engine automatically detects headers, types, and schema.
3. Local File Uploads
Drag and drop common data science formats directly into the browser. Available on all tiers (Free+):
- CSV / TSV: Standard flat files.
- JSON: Nested structures are automatically flattened for analysis.
- XLSX / XLSB: Direct parsing of Excel files without opening Excel.
4. Cloud Storage & APIs
Connect securely to your external data sources. Available on the Advanced tier:
- S3 / HTTP: Direct ingestion from Amazon S3 buckets or remote HTTP web servers.
- REST API: Pull JSON data directly from external software systems without writing integration scripts.
The Normalization Process
Before data reaches your logic, BlazeXL performs several automated tasks:
- Type Detection: Identifying dates, currencies, and numeric strings.
- Schema Alignment: Mapping disparate tables to a consistent format for Python processing.
- Security Scrubbing: Sanitizing data to prevent injection attacks before it reaches the isolated Execution Grid.
Connecting to Live Data
BlazeXL includes native connectors for modern data warehouses and SQL databases to keep your governance central. Available on the Pro tier and above:
- Snowflake: Direct data-warehouse streaming to your executed Blaze Blocks.
- PostgreSQL: Real-time operational database connections.
These database connectors allow the Governance Gateway to manage permissions for live enterprise data streams.