v2.0 · Smart Validator
1
Upload
2
Map Columns
3
Validate & Fix
4
Configure
5
Download SQL
📋
New here? Start with the official template
Pre-formatted Excel file with all required columns, colour coding, and an example row.
Red = Required fields
Green = Optional fields
📌 Headers on Row 1 — data starts Row 2
🔑 patient_id must come from your source EMR
Upload Patient Data
📊
📂
Drop your spreadsheet here
Supports the Helium Migration Template or any compatible Excel/CSV file
.xlsx  ·  .xls  ·  .csv
Map Your Columns

The app has auto-detected your columns from the spreadsheet header. Confirm or adjust below. Fields marked * are required.

Validation Report
Migration Configuration
Used in patient_updates for every row in this batch
Defaults to current UTC time if blank
Auto-increments for rows without an mrn value
Data Preview 0 rows
Migration Files Ready
✓  SQL files generated successfully. Check row counts before running against your database.
🗃
Patient_Table.sql
📍
Patient_Data_Address.sql
📋
Patient_Update_Table.sql