Common No-Code Database Import Blocks We Solve
Airtable and Notion require precise column separators and field formats to build structured relational tables. Here is how CleanMyCSV repairs your data:
1. Re-aligning Merged Columns (Semicolon Delimiters)
When importing European Excel CSV exports (which use semicolons ;) into Airtable or Notion, all fields collapse into a single text column. CleanMyCSV auto-detects the delimiter and converts your file to standard comma separation (,), properly populating every database field.
2. ISO Date Formatting for Date Field Types
Airtable and Notion Date fields fail to recognize regional date formats like DD/MM/YYYY or text dates. CleanMyCSV standardizes date columns into ISO 8601 format (YYYY-MM-DD), enabling native calendar views, timeline views, and automation filters.
3. Encoding Fix for Accents & Special Characters
Scraped web data and legacy CSV exports often display broken character encoding (like é instead of é). CleanMyCSV converts raw file buffers into forced UTF-8 BOM, ensuring titles, select options, and rich text fields display perfectly.
4. Phone Number & ZIP Code Normalization
Airtable Phone and Location field types expect standardized numbers. Excel strips leading zeros from postal codes (06100 becoming 6100) and phone numbers. CleanMyCSV pads missing zeros and normalizes phone numbers into E.164 formats (+33 / +1).