European Excel CSV: Germany, Semicolons, and Decimal Commas

“CSV” Does Not Mean Comma in Much of Europe

In Germany, France, and several other European locales, Excel’s Save As CSV often produces semicolon-separated files because the comma is already the decimal mark (2,50). The file extension is still .csv. US, UK, Canadian, and Australian systems that expect commas then show one smashed column — or reject the upload.

This guide is the practical playbook for German and European Excel exports that must travel to English-speaking markets (and the reverse path back into DE Excel).

Locale Building Blocks

Three settings travel together. Fix them as a set.

What a German Excel CSV Looks Like

Example export from a de-DE Excel:

Artikel;Menge;Preis;Datum
Tee;2;2,50;03.05.2026
Kaffee;1;3,20;13.05.2026

Artikel,Menge,Preis,Datum
Tee,2,2.50,2026-05-03
Kaffee,1,3.20,2026-05-13

Step-by-Step: DE Excel → US/UK/AU/CA Systems

Use this when a German export must enter Shopify, a US SaaS importer, UK Xero, or a dollar-based database.

• Do not double-click the file on a US PC first — preview in a text editor or Online CSV Editor.
• Confirm the separator is semicolon and decimals use commas.
• Convert separators with the CSV to Delimited Converter (semicolon → comma), keeping values quoted as needed.
• Normalize decimals: 1.234,56 → 1234.56 (thousands dot removed, decimal comma to period).
• Normalize dates: DD.MM.YYYY → YYYY-MM-DD or the destination’s required mask.
• Save UTF-8 CSV so umlauts (äöüß) survive.
• Upload a small sample; verify amounts and a date after the 12th.

import csv
from datetime import datetime

def parse_de_number(value: str) -> str:
    return value.replace(".", "").replace(",", ".")

with open("de_export.csv", newline="", encoding="utf-8") as inp, \
     open("us_uk_ready.csv", "w", newline="", encoding="utf-8") as out:
    reader = csv.DictReader(inp, delimiter=";")
    fieldnames = reader.fieldnames or []
    writer = csv.DictWriter(out, fieldnames=fieldnames)
    writer.writeheader()
    for row in reader:
        row["Preis"] = parse_de_number(row["Preis"])
        row["Datum"] = datetime.strptime(row["Datum"], "%d.%m.%Y").strftime("%Y-%m-%d")
        writer.writerow(row)

Step-by-Step: US/UK CSV → German Excel

English-speaking vendors send comma CSV; German Excel users need a painless open.

• Prefer sending UTF-8 with BOM only if the DE user opens via double-click and needs Excel to detect UTF-8 — or instruct them to use Data → From Text/CSV.
• Tell them to set delimiter to comma explicitly in the import wizard.
• Alternatively convert to semicolon CSV before sending, leaving US decimals as periods only if you also document that amounts are US-formatted — mixing semicolon separators with US decimals is common for technical handoffs.
• For fully localized DE files, convert decimals to European form and dates to DD.MM.YYYY in a controlled script.

Artikel;Menge;Preis;Datum
Tee;2;2.50;2026-05-03
Kaffee;1;3.20;2026-05-13

Excel Import Wizard Beats Double-Click

On both sides of the Atlantic, Data → Get Data → From Text/CSV (or legacy Text Import) lets you choose delimiter, encoding, and column types.

• Set Delimiter to Semicolon or Comma explicitly.
• Set File Origin / encoding to UTF-8 when umlauts appear wrong.
• Set the date column type with the correct DMY or MDY order.
• Set amount columns as Text first if you need to preserve formatting, then convert with a formula.

Encoding: UTF-8 vs Windows Western European

German text exposes encoding mistakes immediately.

• Müller becoming Müller means UTF-8 bytes were read as Latin-1/Windows-1252.
• Müller becoming Müller’s cousin artifacts can also mean the reverse mis-label.
• Excel “CSV” (code page) vs “CSV UTF-8” are different menu items on Windows.
• For cross-border sharing, prefer UTF-8 CSV and tell recipients which delimiter you used.

UK and Australia Are Not “European Excel”

Important nuance for multi-country teams.

• UK and Australian Excel usually use comma CSV and period decimals — like the US for separators — but day-first dates.
• Germany adds semicolon + decimal comma on top of day-first dates.
• Do not apply a “Europe = semicolon” rule to a London or Sydney file.
• Canada may use either English-style or French-style numeric formatting depending on locale — verify.

Business Systems That Reject European CSV

Common destinations for Convert CSV Online users.

• US ecommerce and ad platforms expecting comma CSV.
• UK/AU Xero bank imports expecting comma separators with local dates.
• US QuickBooks bank CSV uploads.
• Developer APIs and cloud warehouses that parse RFC 4180 comma CSV.
• German DATEV or local tools that may want semicolon — keep a DE-localized copy.

Common Mistakes

These destroy numbers.

• Find-and-replace ; with , across the file, splitting European decimals.
• Find-and-replace , with . in amounts without removing thousands dots first (1.234,56 → 1.234.56 chaos).
• Assuming a .csv from Berlin uses commas.
• Sending US comma CSV to a DE user without import instructions.
• Fixing delimiters but leaving DD.MM.YYYY for a US importer.

Best Practices

Treat locale as part of the file contract.

• Document separator, decimal mark, date mask, and encoding in the README or filename.
• Convert with quote-aware tools, not Notepad replace.
• Keep a golden sample row for round-trip tests (umlaut + amount + date > 12).
• Prefer ISO dates in interchange files.
• Use the Excel import wizard on receipt; train both DE and US teammates.

Why Use Convert CSV Online?

Convert CSV Online is free, browser-based, and requires no account for everyday conversions. Switch semicolon and comma layouts with the CSV to Delimited Converter, preview German exports in the Online CSV Editor, and deliver UTF-8 files that US, UK, Australian, Canadian, and German partners can agree on. Client-side workflows run on Windows, macOS, and Linux browsers.

Conclusion

European Excel CSV is a locale stack: separators, decimals, dates, and encoding. Handle each explicitly when files move between Germany and the US, UK, Canada, or Australia — and never trust the .csv extension alone.