2 linked guides. Start at part 1 or open the chapter that matches your question.
CSV vs TSV compared—delimiters, quoting rules, spreadsheet behaviour and clipboard quirks—so you know which delimited format to choose and how to convert between them.
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.