2 linked guides. Start at part 1 or open the chapter that matches your question.
CSV vs TSV compared — delimiters, quoting rules, spreadsheet behavior and clipboard quirks, plus how to convert between the two delimited formats.
How CSV quoting works under RFC 4180—when fields need double quotes, how to escape a quote inside a field and why naive comma replacement corrupts data.