dataFormatters logo

CSV Mapper Tool

Upload a CSV file and map its columns to our standard format. Your configurations will be saved automatically.

ℹ️

How to Use the CSV Mapper

Step 1: Upload your CSV file using the file uploader.

Step 2: If you've previously mapped a similar CSV format, the system will automatically apply the matching configuration.

Step 3: For each field, select the corresponding source column from your CSV.

Step 4: For complex transformations, specify a delimiter and position:

Example: Raw Data: "MR. JOHN DOE MALE 123-456-7890"

Delimiter: Space

Position: 3 (to extract "MALE")

Result: "MALE"

Step 5: Verify the transformation in the Mapped Data Preview section.

Step 6: Name and save your configuration for future use.

Note: The system will automatically detect and apply saved configurations when you upload CSVs with the same column structure.

Upload CSV File

No file selected

CSV preview will appear here after uploading a file.

Configure Field Mapping

Target Field Source Column Delimiter Position Index Preview

Mapped Data Preview (First 2 Rows) will appear here after configuring the mapping.

An error occurred during the mapping process. Please check your configuration.