1. Resolving Stray Quotes and Mixed Delimiters in CRM Exports
Data EngineerBackground
A CRM export contains a mix of comma-separated and tab-separated rows, along with unescaped quotes in the notes field, causing the database import script to crash.
Problem
The import script expects a strict comma-separated format and fails on row 2 due to an unescaped quote, and row 3 due to tab delimiters.
How to use
Paste the CRM export into the CSV data field, set the input delimiter to Comma, set the target delimiter to Comma, and check 'Unescape stray quotes' and 'Detect and rewrite mixed delimiters'.
{
"delimiter": ",",
"targetDelimiter": ",",
"unescapeStrayQuotes": true,
"detectMixedDelimiters": true
}Outcome
The tool escapes the stray quotes, converts the tab delimiters to commas, and outputs a clean CSV with a row-level diff showing the exact changes.