CSV Tools Pro

    Change CSV Delimiter Online

    Convert CSV files between comma, semicolon, tab, and pipe delimiters directly in your browser. Fast, private, and free to use.

    • Four common single-character delimiters
    • Auto-detects the current delimiter
    • No uploads — files stay on your device
    • Free, no account required

    Your file is processed in your browser and is not uploaded unless explicitly stated.

    Drag & drop your CSV file here

    or click to browse

    Choose File

    Supports .csv, .tsv, and .txt files

    What Does the CSV Delimiter Changer Do?

    This tool lets you change the delimiter used in a CSV file directly in your browser. It is useful when a CSV file uses the wrong separator for your software, spreadsheet application, or import process. You can convert between comma-separated, semicolon-separated, tab-separated, and pipe-separated formats without uploading your file.

    Because processing happens locally in your browser, your data remains private and is never sent to a server. The delimiter is auto-detected from your file, and you can override it manually if needed before converting.

    How to change a delimiter

    1. Upload a .csv, .tsv or .txt file, or paste delimited text.
    2. Check the detected source delimiter and correct it if necessary.
    3. Choose comma, semicolon, tab or pipe as the target, convert, then download.

    When would I use this?

    • Fixing CSV files that open incorrectly in Excel because they use semicolons instead of commas
    • Converting semicolon-separated CSV files to comma-separated format for compatibility
    • Preparing files for import into systems that expect a specific CSV separator
    • Converting tab-separated exports from databases into standard comma-delimited CSVs
    • Fixing delimiter issues when sharing files between teams in different countries or using different software

    Common Problems Caused by Wrong CSV Delimiters

    • CSV files that use semicolons open in Excel with all data jammed into a single column because Excel expects commas
    • Files exported from European software or ERP systems often use semicolons instead of commas due to regional settings
    • Tab-separated data exported from databases is not recognised as valid CSV by many import tools
    • CRM and e-commerce platforms often require a specific delimiter for CSV imports, rejecting files that use a different separator
    • Pipe-delimited files are unreadable in Excel without converting them to a standard format first

    Best Ways to Change the CSV Delimiter

    • Change the delimiter in Excel — Possible via Data > Text to Columns, but involves multiple steps and does not produce a downloadable CSV directly
    • Write a script — Most scripting languages handle delimiter conversion in a few lines, but require coding knowledge
    • Use a browser-based delimiter converter — The fastest and simplest approach: upload your file, choose the source and target delimiter, and download the converted CSV immediately

    Things to be aware of

    • This tool supports four single-character delimiters; custom and multi-character delimiters are not supported
    • Values containing the target delimiter character are automatically quoted in the output to prevent parsing errors
    • Very large files may be slow to process in the browser due to memory constraints
    • If the source file uses a delimiter not in the supported list, auto-detection may select the wrong one — manual override is available
    • Files are read as browser-default UTF-8 text. Legacy encodings such as Windows-1252 are not detected and may show replacement characters
    • Auto-detection only counts candidates on the first physical line, including punctuation inside quoted fields

    Worked example

    A semicolon-delimited file exported from European accounting software is converted to comma-delimited format to open correctly in Excel.

    INPUT
name;note
Alice;"London, UK"

OUTPUT
name,note
Alice,"London, UK"

    The comma inside the note remains quoted, so it is not mistaken for a column break.

    Frequently Asked Questions

    No. All processing happens entirely in your browser. Your CSV file is never sent to any server. Once you close or refresh the page, all data is cleared from memory.

    Yes, completely free. No account or sign-up is required.

    You can convert between comma (,), semicolon (;), tab, and pipe (|) delimiters. These cover the most common CSV and TSV formats used by spreadsheet applications, databases, and data export tools.

    Excel uses the system list separator, which varies by region. In many European countries the comma is the decimal separator, so Excel defaults to semicolons for CSV files. This is a common source of delimiter issues when sharing CSV files across different countries or software tools.

    No installation is required. The tool runs entirely in your browser. Just open the page, upload your CSV file or paste your data, choose your delimiters, and download the result.

    The tool compares comma, semicolon, tab and pipe counts on the first line. Quoted punctuation can mislead this simple check, so select the correct Current delimiter manually when the preview looks wrong.

    Yes. The tool uses standard CSV parsing rules, so values that contain the delimiter character are automatically quoted in the output to prevent them from being interpreted as column separators.

    Related Tools