Uploading Data
Learn how to upload your clinical data to MedTWIN.
Supported File Formats
| Format | Extension | Notes |
|---|---|---|
| CSV | .csv |
UTF-8 encoding recommended |
| Excel | .xlsx, .xls |
Multiple sheets supported |
| REDCap | .csv |
Direct export from REDCap |
Coming Soon
SPSS (.sav) and SAS (.sas7bdat) support is on our roadmap.
Preparing Your Data
Best Practices
- One row per patient: Each row should represent a unique patient/case
- Consistent headers: Use clear, descriptive column names
- No merged cells: Avoid merged cells in Excel
- Date format: Use ISO format (YYYY-MM-DD) when possible
Example Structure
patient_id,age,gender,procedure,mortality_30d,los_days
P001,67,Male,CABG,0,7
P002,72,Female,Valve,1,12
P003,58,Male,CABG,0,5
Uploading Files
Drag and Drop
- Open your project
- Navigate to Data → Upload
- Drag your file into the upload area
- Wait for processing
File Browser
- Click "Browse Files"
- Select your file
- Click "Open"
- Wait for processing
Upload Progress
During upload, you'll see:
- Uploading: File transfer in progress
- Processing: Parsing and validating data
- Mapping: AI-suggested variable mappings
- Complete: Ready for analysis
Data Validation
MedTWIN automatically checks for:
Quality Checks
- Missing values (with percentage)
- Duplicate rows
- Data type consistency
- Outlier detection
- Date format validation
Handling Issues
If issues are detected:
- Review the Data Quality Report
- Choose to:
- Fix in MedTWIN: Use built-in tools
- Re-upload: Fix in your source file
- Proceed: Accept with documented issues
Large Files
For files over 100MB:
- Consider splitting by year or site
- Use CSV format (smaller than Excel)
- Contact support for enterprise uploads
Performance
Files under 50MB process fastest. For large datasets, consider uploading overnight.
Data Security
Your uploaded data is:
- Encrypted at rest (AES-256) and in transit (TLS 1.3)
- Isolated in your tenant's storage
- Never shared with other users
- Backed up automatically
See our Data Handling guide for details.
Versioning
MedTWIN automatically versions your data:
- v1.0: Original upload
- v1.1, v1.2, ...: Updates and corrections
You can always:
- View any previous version
- Compare versions
- Revert to earlier version
- See which analyses used which version