Opened 4 years ago

Closed 4 years ago

#1322 closed New feature (fixed)

Add a "CSV for Excel" download link

Reported by: matt Owned by:
Priority: major Milestone: Piwik 0.9.9 - Stable release
Component: UI - UX (AngularJS, twig, less) Keywords:
Cc: Sensitive: no

Description (last modified by matt)

We regularly receive emails from users who claim the CSV export doesn't work well in Excel.

CSV with comma separated values doesn't import well in Excel 2007. It imports well in OpenOffice calc though.

It seems Excel by default only accepts tabs as delimiters. Piwik could add an export link in the table footers "CSV for Excel" which would be the CSV export, with a tab delimiter.

Change History (5)

comment:1 Changed 4 years ago by matt (mattab)

  • Description modified (diff)

comment:2 Changed 4 years ago by vipsoft (robocoder)

Wouldn't this be better described as "TSV - tab separated values" ?

comment:3 Changed 4 years ago by matt (mattab)

(In [2131]) CSV renderer works with tab delimited values refs #1322

comment:4 Changed 4 years ago by matt (mattab)

Vipsoft, maybe "TSV (Excel)" ? to make it clear that this works in excel, when CSV doesn't by default

comment:5 Changed 4 years ago by matt (mattab)

  • Resolution set to fixed
  • Status changed from new to closed

(In [2181]) Fixes #1322 Adding CSV that works in Excel (TSV)

Note: See TracTickets for help on using tickets.