File-based ETL for teams handling sensitive data

ETL for sensitive data. Local-first. HIPAA-ready.

QX Flow is a file-based ETL platform that cleans, standardizes, calculates, aggregates, and masks sensitive data - all inside your browser, with zero uploads.

Get started free
File-based ETL for Excel, CSV, and JSON
No formulas to memorize - build logic visually
Smart PII/PHI recommendations with 90%+ match scores
One-click masking plus reusable batch workflows
Local-first execution Run sensitive-data ETL inside the browser without cloud sync or remote database connections. See the privacy model
www.qingxiflow.com/app
ETL Flow
Batch ETL
✓
5 PHI fields masked
Start
⚙
Build ETL steps
Start
↓
Export safe output
Start
Field Original Processed Status
phone (415) 555-0192 (415) ***-0192 ✓
ssn 123-45-6789 ***-**-6789 ✓
email user@example.com u***@e.com ✓
npi 1234567890 123456***0 ✓
dob 01/15/1985 [DOB REDACTED] ✓
3
Supported File Formats
90%+
PII/PHI Match Scores
0
Cloud Sync Steps
1
Reusable Workflow Engine
Why teams switch

Sensitive-data ETL breaks down in the usual stack.

Teams handling PHI, audit extracts, and financial records need ETL that works on files, stays local, and remains easy to review.

数据来源分散

JSON、CSV、Excel 格式混用，不同系统导出格式不一致，整合成本高

工具链割裂

查看、清洗、脱敏、计算、聚合，导出需要多个工具来回切换

重复劳动严重

同类任务多次处理一遍，明天换一批数据还要重新操作一遍

交付一致性差

不同同事按自己习惯处理，口径不统一，复核与交接成本高

敏感数据有风险

在线工具要求上传原始数据，不适合内部经营数据与敏感场景

缺少自动化

周报、月报、批量查这次作业人工反复点击，耗费时间、效率低

Why it is different

Built around sensitive-data ETL from day one

QX Flow combines file-based ETL, local-first execution, and HIPAA-ready workflows in one browser-native platform.

原始数据在本地处理

安全合规，适合敏感场景

核心处理逻辑在本地完成，不上传数据到第三方平台，更适合内部经营数据、客户资料、审计明细等敏感场景。

Internal Business Data Customer Information Audit Records Financial Data

规则标准与复用

一次配置，长期复用

处理规则可存储为模板，形成团队统一的数据处理口径，降低培训与交接成本，实现团队众筹串联。

Rule Templates Team Sharing Faster Onboarding Standardized Logic

批量与自动化执行

从人工操作升级为自动作业

支持对多份文件统一应用规则，按计划定时自动运行，让高频重复性数据处理业进入标准作业流程。

Batch Delivery Reusable Rule Assets Team Standardization Consistent Outputs
What you can do

A file-based ETL flow in one browser workspace

Mask, clean, standardize, calculate, and aggregate sensitive files without leaving the browser.

Masking

Protect sensitive data before handoff

  • Phone / SSN / Member ID / MRN
  • Email / Name / Address minimization
  • Hash masking / numeric obfuscation
  • Custom masking rules
Cleaning

Fix dirty data with reference lookups

  • Replace / fill missing / deduplicate
  • Normalize / enrich from references
  • Lookup replacement / reference validation
  • JSONPath extract and replace
Conversion

Unify data formats and types

  • Date / numeric / type conversion
  • Ordinal encoding / unit conversion
  • Field split / merge / copy
  • Encoding conversion / geo-coordinate transform
Computation

Field computation and row-level operations

  • Formula engine: conditional, text, numeric, date, and logic functions
  • Python UDF for custom business logic
  • Sort, filter, and row-level operations
Aggregation

Generate statistical outputs

  • Grouped aggregation metrics
  • SUM / AVG / COUNT / MIN / MAX
  • First / Last / Median / STDDEV / Distinct Count
  • Conditional filters + multi-field Group By
Built for business teams

No formulas to memorize. No code to write.

Drag fields and functions together, preview every change, and run ETL logic without handing the job to engineering.

Side-by-Side Value Comparison

After applying rules, each field displays "Original → Processed" side by side. Added, modified, and deleted fields are highlighted with color for instant verification.

id A001 → A001
phone 13812340111 → 138****0111
review_flag — → Needs Review
raw_email alex@example.com → (removed)

Change Navigation Track

An IDE-style minimap on the right marks changed rows in green, so operators can jump directly to edits in large files.

↑ Click to jump to changed rows

Real-time Formula Preview

When building compute formulas or Python UDFs, preview outputs instantly before saving to prevent rework.

Formula IF(amount > 10000, "Needs Review", "OK")
amount: 15000 → Needs Review
amount: 3200 → OK
amount: 88000 → Needs Review

Ordered Rule Management

Rules are ordered by execution sequence and can be reordered with drag-and-drop for deterministic outputs.

1 Mask patient phone · phone ⠿
2 Normalize member region · region ⠿
3 Compute claim risk flag · review_flag ⠿
4 Aggregate claim total · total_amount ⠿

Zero ramp-up for non-technical teams

Use business-first language and guided validation so audit, finance, and operations teams can run workflows confidently without coding.

①
Open a CSV, JSON, or Excel file
→
②
Stack ETL steps and formulas
→
③
Review diffs before export
→
④
Reuse the ETL workflow for the next batch
How teams run it

Start with one sensitive file. Reuse the ETL later.

Build the workflow visually in interactive mode, then rerun it across future batches without rebuilding logic.

Interactive ETL building

Bring in a sensitive file, add ETL steps visually, preview changes, and export once the results look right.

Supported formats
JSON CSV Excel (.xlsx/.xls)

Highlights

  • Row-level before/after comparison for every change
  • Clear highlights for updated fields
  • Field filters and tree view for deep inspection
  • Mask, clean, convert, compute, and aggregate in one flow

Batch ETL reuse

Apply saved workflows across folders and repeated deliveries without rebuilding the ETL logic from scratch.

Supported formats
JSON CSV Excel (.xlsx/.xls)

Highlights

  • Automatic rule-to-file matching by naming convention
  • Apply one ruleset across many files in one run
  • Unified ZIP export for handoff and archive
  • Lower operational cost versus file-by-file execution
Where it fits

Built for teams that prep and protect sensitive files

QX Flow fits healthcare, finance, audit, compliance, operations, and implementation teams working with exported data.

Audit & Inspection

Import transaction records or logs, mask sensitive fields, and aggregate quickly for review-ready outputs.

  • Reduce manual review overhead
  • Protect sensitive fields before sharing
  • Keep inspection standards consistent

Finance & Business Analytics

Standardize expense and reconciliation data, compute fields, and deliver analysis-ready datasets faster.

  • Normalize formats for faster rollups
  • Reduce repetitive calculation errors
  • Improve reconciliation speed

Compliance & Secure Sharing

Mask sensitive fields before external handoff to lower privacy risk and improve partner trust.

  • Lower sensitive-data exposure risk
  • Increase handoff security
  • Create safe sample datasets quickly

Batch Delivery

Run one governed ruleset across projects and export consolidated ZIP deliverables with consistent quality.

  • More stable high-volume execution
  • Fewer repetitive clicks per batch
  • Consistent output standards at scale

Healthcare & PHI Prep

Detect PHI fields, apply HIPAA-ready masking logic, and prepare safer outputs before files move onward.

  • Detect phone, email, SSN, and other PHI-sensitive fields faster
  • Apply HIPAA-ready masking rules before handoff
  • Reduce manual PHI review effort

Operations & Implementation

Clean imports, map fields, and standardize sensitive records before they land in the next system.

  • Fix inbound sensitive records faster before launch or migration
  • Keep mappings and cleanup logic repeatable
  • Reduce launch-week manual cleanup
Why not use a generic ETL stack?

Made for file-based sensitive-data workflows

QX Flow focuses on browser ETL for exported files, with local-first privacy controls and HIPAA-ready handling.

Typical Approach
Operational Gaps
How QX Flow Improves It
Excel 手工处理
× 依赖个人习惯，处理口径难统一 × 公式链条长，复核和交接成本高 × 同类任务换一批数据还要重新做一遍
✓ 用规则替代手工步骤，结果更稳定，经验可沉淀为模板
多工具拼接
× 导入、清洗、脱敏、汇总、导出分散在多个工具 × 中间过程割裂，核对责任边界不清晰 × 数据多次迁移，出错点和泄露面同时增加
✓ 在一个工作台内完成导入、处理、核对、导出，减少切换与迁移
写脚本处理
× 强依赖技术同事，业务团队难直接上手 × 脚本分散在个人电脑里，难复用、难交接 × 小改动也要重新开发和验证，维护成本高
✓ 业务人员可直接配置和执行，规则集可共享、可复用、可持续迭代
Cloud ETL Tools
× 原始数据需要上传或中转，敏感场景顾虑大 × 对内部经营数据、客户资料、审计明细不够稳妥 × 审批和合规边界更复杂
✓ 核心处理逻辑在本地完成，数据不外发，更适合敏感业务场景
DIY PHI Handling
× Sensitive fields are detected and masked manually × HIPAA-related prep depends on operator memory and spot checks × Repeatability breaks across files, teams, and review cycles
✓ PHI-aware recommendations, one-click masking, and reusable workflows make sensitive-data prep more consistent
Compared to prompt-only helpers

AI can suggest transformations. QX Flow runs the ETL reliably on sensitive files.

Ad-hoc prompts help with ideas, but sensitive-data ETL still needs reusable logic, reviewable outputs, and a clearer privacy boundary.

Prompt-based helper
Where it breaks
How QX Flow helps
Prompted one-off cleanup
× 同一任务换个人、换提示词，输出口径可能不一致 × 更适合一次性问答，不适合长期重复作业
✓ 规则可保存为模板，确保同类任务长期按同一口径执行
Upload data for AI assistance
× 涉及原始数据粘贴、上传或脱敏后再沟通，流程更绕 × 对敏感数据、客户资料、经营明细存在边界顾虑
✓ 处理逻辑在本地执行，原始数据不必外发，更符合敏感场景要求
AI Suggestion + Manual Execution
× Significant manual work remains between idea and execution × Field mapping and rule consistency still depend on operator experience
✓ Slot matching and reusable rule assets convert intent into governed execution
AI output or code snippet
× 缺少面向业务人员的核对界面和过程留痕 × 交接时往往还要重新解释 prompt、脚本和处理步骤
✓ 提供新旧值对比、导出结果、运行历史与规则资产，便于复核和团队协作
File-based ETL. Zero uploads.

Bring in the file. Run the ETL locally.

Clean, standardize, calculate, aggregate, and mask sensitive data in the browser, then reuse the workflow on the next batch.

Open the app free Talk To Sales
File-based ETL for Excel, CSV, and JSON
Local-first processing
HIPAA-ready recommendations and masking
Reusable workflows and batch jobs