CSV Import Formatter

Transform CSV columns with type conversions and value mapping.

CSV Input

Drop CSV file or click to browse

Input delimiter

Output delimiter

Decimal separator

Example CSV:

Import Schema

Import from URL

Import from JSON

Schema Reference

{
  "$schema": "https://csv-import-formatter.mikepage.deno.net/schemas/mapping.schema.json#/$defs/MappingCollection",
  "schemas": [
    {
      "name": "My Schema",
      "config": {
        "version": "1.0",
        "mappings": { "sourceColumn": "targetColumn" },
        "typeTransformations": { "column": "integer" },
        "transformations": { "column": "uppercase" },
        "valueConversions": { "column": { "Mr": "male" } }
      }
    }
  ]
}

Export Schema

Schema name:

{
  "$schema": "https://csv-import-formatter.mikepage.deno.net/schemas/mapping.schema.json#/$defs/MappingCollection",
  "schemas": [
    {
      "name": "Untitled",
      "config": {
        "version": "1.0",
        "inputDelimiter": ";",
        "outputDelimiter": ";",
        "decimalSeparator": ",",
        "mappings": {}
      }
    }
  ]
}