What is CSV Delimiter?

Published on November 10, 2026 • Last updated November 10, 2026

Official Definition

A CSV delimiter is the character—such as a comma (,), semicolon (;), tab (\t), or pipe (|)—used to separate individual data values or columns within a row in a tabular text file.

Detailed Explanation

In-Depth Guide

Key Takeaway

Although CSV stands for Comma-Separated Values, varying regional conventions and software configurations require alternative delimiter characters. In European countries where a comma serves as the decimal separator (e.g., 14,99 €), spreadsheets use a semicolon (;) as the delimiter to prevent confusion between column breaks and decimal numbers.

Tab-delimited files (TSV) are favored for text datasets containing natural prose with punctuation, while pipe delimiters (|) are common in database bulk dumps. When a cell's text value contains the delimiter itself, standard CSV formatting encloses the entire field within double quotes.

Frequently Asked Questions

The field must be wrapped in double quotes (e.g., "San Francisco, CA"). The parser treats commas inside quotes as literal text rather than column boundaries.

This occurs when Excel's regional settings expect a semicolon delimiter, but the imported file uses commas (or vice versa). You can resolve this using Excel's Text to Columns wizard or by converting the delimiter.

Tab characters (TSV) or pipe characters (|) are typically safest because they rarely appear in conversational prose, addresses, or numerical values.

What do you need to work out next?

Search 276+ free tools by name, or pick a category below. Every one runs instantly in your browser — no signup, nothing to install.

More Finance tools
AI ADVISOR & COACH

Ask AI Advisor

Ask AI