Free fix · CSV in one column

CSV opens in one column in Excel? Fix it in one click

Excel puts everything in column A when the CSV's separator (comma or semicolon) doesn't match your computer's regional settings. Upload the CSV here: the separator and encoding are detected and you get a proper .xlsx with every value in its own column.

How it works

  1. 01
    Upload the CSV

    Comma, semicolon, tab or pipe separated, the separator is detected automatically.

  2. 02
    Check the columns

    The preview shows your data split into the right columns, including special characters like é and ü.

  3. 03
    Download XLSX

    Open the .xlsx in Excel: columns are correct, leading zeros kept, no import wizard needed.

Frequently asked questions

Why does my CSV open in one column in Excel?+

Excel uses your system's list separator. In many European locales that's a semicolon, so a comma-separated file lands in one column (and the other way around).

How do I fix it inside Excel?+

Select column A, go to Data → Text to Columns, choose Delimited and pick the right separator. Or use Data → From Text/CSV. Converting to .xlsx avoids the problem for everyone who opens the file.

Why do I see strange characters like é?+

The file is UTF-8 but Excel read it with another encoding. The .xlsx from this page stores characters correctly.

Will my leading zeros disappear?+

No. Values are written as text, so postal codes, IDs and phone numbers keep their zeros.

Is it free and private?+

Yes. Free, no account, and the file is converted in your browser.