Visual Data Mapping
Define reusable source-to-target mappings with a spreadsheet-style editor. Handle CSV, Excel, JSON, PDF, and more.
Learn more
Platform Features
Everything You Need for
Data Transformation
Map, transform, validate, and deliver data from any file format — visually, with AI, or with custom Python. Build once, reuse forever.
Capabilities
The Complete Feature Set
Every tool you need to map, transform, validate, and deliver data — in one platform
Data Mapping
Visual Mapping Editor
Horizontal, card-based field mappings that mirror how you think about source-to-destination transformations.
Drag & Drop Fields
Reorder destination fields, drag source fields into inputs, and reorganize your mapping layout effortlessly.
Import Fields from File
Upload a sample CSV, Excel, or JSON file to auto-extract headers as destination fields — no manual entry.
Card & List Layouts
Toggle between horizontal card view and vertical list view to suit your screen and workflow.
Smart Template Match
Upload a source file and the system auto-suggests the best matching template from your library based on field overlap.
Transformation
No-Code Logic Builder
Build complex transformation rules visually with drag-and-drop variables, if/then blocks, and functions.
If/Then Conditional Logic
Visual conditional blocks with AND/OR operators, nested logic, condition groups, and multiple action types.
50+ Built-in Functions
String, math, date, conversion, and utility functions — searchable, configurable, and chainable.
Custom Python (Monaco Editor)
Full Monaco code editor for writing raw Python. Seamlessly switch between visual and code modes.
Pre & Post Filters
Filter rows before or after transformation to exclude bad data or remove unwanted output rows.
NewRow Function
Conditionally expand your dataset by adding new rows during transformation — ideal for one-to-many scenarios.
AI & Automation
AI Data Onboarding Agents
Autonomous agents that iteratively generate, transform, validate, and refine mapping logic — running in the background.
Map All Orchestrator
Describe your requirements in plain English and AI builds the entire mapping — direct mappings, custom logic, and filters.
Suggest Mappings
AI analyzes source and destination fields to propose 1-to-1 mappings with confidence scores you can approve or decline.
AI Logic Assist
Describe a transformation in plain English and get generated Python code that fits directly into the logic builder.
Adapt to File
When source fields change, AI remaps your existing template to the new column names — preserving all logic and validation.
Validation & Quality
Per-Field Validation Rules
Define validation logic for every output field using the same visual builder. Return pass/fail with custom error messages.
Data Viewer with Error Highlighting
Interactive tabular preview with cell-level error highlighting, column filtering, and one-click error navigation.
Cell-Level Error Isolation
A single bad cell never crashes the job. Errors are caught per-cell, logged, and processing continues.
Import & Share Validations
Import validation rules from another template. Share validation standards across mappings and team members.
Transformation Logs & Reports
Detailed summary with processed, filtered, errored, and warning row counts. Export reports for offline review.
Lookups & Enrichment
Local Lookup Tables
Upload CSV, Excel, or JSON reference tables. Stored in mapping files — no external dependencies needed.
Self-Join Lookup
Look up values from other rows within the same dataset by matching fields. Like VLOOKUP within your own file for cross-referencing.
Remote Lookups (API & DB)
Pull reference data from APIs or databases during transformation. Cached for performance, no repeated calls.
Fuzzy Local Lookup
Fuzzy match against reference tables with configurable algorithms (token sort, partial ratio) and score thresholds.
Computed Keys
Create virtual columns on lookup tables using the logic builder — combine fields, normalize values, generate match keys.
Parameterized Tables
Swap lookup table data at run time without modifying the template. Same template, different reference data per job.
Power Functions
ForEach Loops
Iterate over lists within a row — unpivot data, build new rows, or accumulate values with a visual loop builder.
Regex Suite
Match, extract, and replace with full regex — built into the visual function library with common pattern presets.
Value Count & Duplicate Detection
Count occurrences of a value across the entire column. Flag duplicates or validate uniqueness in a single function.
Group Counter & Unique Index
Auto-number line items within groups, assign consistent IDs to unique value combinations, or reset counters per parent.
Coalesce (Waterfall Fallback)
Return the first non-empty value from a prioritized list of fields — ideal for fallback logic across multiple columns.
Apply (Cross-Field Reference)
Reference another destination field's transformation logic. Compose complex outputs by chaining field results together.
Sources & Integration
CSV, Excel, JSON
Any delimiter, multi-sheet Excel, nested JSON with automatic record path detection and recursive expansion.
PDF & Word Documents
AI-powered table extraction from PDF and DOCX files. Select from multiple detected tables and map like any other source.
API Connections
Connect to REST APIs with multiple auth types, pagination strategies, and auto-detect. Pull or push data.
Database Connections
PostgreSQL, MySQL, SQL Server, SQLite. Run queries, call stored procedures, and push transformed data back.
Cloud Storage
Box and SharePoint/OneDrive integration with OAuth2, file browsing, chunked uploads, and conflict handling.
Multi-File Concatenation
Upload multiple source files and concatenate them into a single dataset. Track origin with source filename injection.
Templates & Collaboration
Template Library
Save mapping configurations to your account with versioned files. Load, reuse, and iterate on templates.
Team Sharing
Share templates across your team with the Team plan. Personal and shared templates in a unified library.
Version Control
Every save creates a new version. Roll back, compare, and track how templates evolve over time.
Transformation History
View recent jobs with status, restore results, and reprocess past jobs without re-uploading files.
Guided Walkthroughs
Interactive product tours with demo data that walk new users through the full workflow step by step.
Deep Dives
Explore Each Feature
Learn how each core capability works with detailed walkthroughs, screenshots, and use cases
Logic Builder
Visually build transformation rules with if/then blocks, functions, and variables — or drop into Python anytime.
Learn more
Smart Lookups
Enrich and cross-reference data with local lookup tables, remote API/DB lookups, and fuzzy matching.
Learn more
Validation & Review
Define per-field validation rules and review results with cell-level error highlighting and detailed logs.
Learn more
AI Mapping Agents
Deploy autonomous AI agents that iteratively generate, test, and refine complete mapping configurations.
Learn more
JSON Transformation
Work with deeply nested JSON structures using intuitive path syntax. Map to and from nested formats with ease.
Learn more
Full Access for 30 Days
Try DataFlowMapper for 30 days. If it's not the right fit, we'll refund you — no questions asked. Early adopter pricing locks in after.
1-on-1 Onboarding & Support
Partner with us and get tailored solutions for your unique data onboarding needs.
Product Roadmap & Features
Get first say in the future of DataFlowMapper. Your feedback shapes our platform.
The visual data transformation platform that lets implementation teams deliver faster, without writing code.
Start mappingNewsletter
Get the latest updates on product features and implementation best practices.