24-Hour to 12-Hour Converter
Turn 24-hour and military times into AM/PM, in bulk or inside text.
Swap between comma, semicolon, tab and pipe — and fix comma decimals while you are there.
Drop a delimited file here, or click to choose one
Converted on your device — the file is never uploaded
The CSV Delimiter Converter re-writes a delimited file with a different separator — comma, semicolon, tab or pipe — and can switch comma decimals to dots at the same time, which is what usually breaks European exports.
A CSV that opens perfectly on one computer lands in a single column on another. The reason is almost always the separator: Excel in much of Europe writes and expects semicolons, because the comma is already doing duty as the decimal point, while importers and APIs nearly always want commas.
This reads the file with whichever delimiter it actually uses — detected automatically — and writes it out with the one you need, re-quoting fields as required. It can also switch the decimal style at the same time, turning 1.234,56 into 1234.56 or the reverse, which is the other half of the same problem. Quoted fields containing commas, quotes or line breaks are preserved exactly, and ragged rows are padded so the grid stays square.
The delimiter is found by column-count consistency, not by counting characters.
Convert 1.234,56 to 1234.56 or back, leaving text values untouched.
Fields are re-quoted for the new delimiter so nothing splits in the wrong place.
Comma decimals inside a comma-separated file are flagged before you download.
The download becomes .tsv or .csv to match the delimiter you chose.
Leave the input delimiter on detect unless the file is unusual.
Comma for importers and APIs, semicolon for European Excel, tab for pasting into sheets.
Convert 1,50 to 1.50 or the other way round, leaving text values alone.
The file extension follows the delimiter you picked.
By reading the first lines and choosing the candidate that gives the same column count on every one of them. Consistency is a far better signal than simply counting characters.
Because those locales write decimals with a comma — 1,50 — so the comma cannot also separate fields. Excel follows the list separator in your Windows regional settings.
No. Only values that are entirely a number in the chosen style are rewritten; anything containing letters is left exactly as it is.
Yes, and the download becomes a .tsv file. Fields containing a tab are quoted so the columns still line up.
What people who use the CSV Delimiter Converter think of it. Reviews come from visitors and are posted as written.
No ratings yet
Yours would be the first.
0 reviews
Newest first
No reviews yet
Be the first to rate the CSV Delimiter Converter. It takes half a minute and no account.
Write the first reviewTurn 24-hour and military times into AM/PM, in bulk or inside text.
Convert indentation between tabs and spaces, with tab stops handled properly.
Turn a spreadsheet of coordinates into GeoJSON points for any mapping tool.
Turn XPath into CSS selectors — and say plainly when CSS cannot express one.
Pull a table out of any HTML — rowspans expanded, links kept, straight to CSV.
Lakh and crore to million and billion, and back — exactly.
Excel serial numbers to dates and dates to serials — 1900, 1904 and Google Sheets.
Convert iPhone and QuickTime video to MP4 for Windows, Android and the web.