[New-bugs-announce] [issue27752] CSV DictReader default dialect name 'excel' is misleading, as MS Excel doesn't actually use ', ' as a separator.

[lockywolf]

New submission from lockywolf:

Hello, everyone.

I want to report a minor usability issue:

I wanted to use the csv module to load CSV's and the documentation says that the default dialect for reading CSVs is 'excel'.

However, the delimiter used with this dialect in Python is a comma (','), whereas in fact (even though is's called _comma_ separated values) MS Excel (2016) uses a semicolon (';') as a delimiter.
Therefore, the Python's 'excel' actually doesn't read Excel generated files.

----------
components: Library (Lib)
messages: 272579
nosy: lockywolf
priority: normal
severity: normal
status: open
title: CSV DictReader default dialect name 'excel' is misleading, as MS Excel doesn't actually use ',' as a separator.
type: behavior
versions: Python 2.7

_______________________________________
Python tracker <report at bugs.python.org>
<http://bugs.python.org/issue27752>
_______________________________________