Ticket #1322 (closed New feature: fixed)

Opened 21 months ago

Last modified 21 months ago

Add a "CSV for Excel" download link

Reported by: matt Owned by:
Priority: major Milestone: Piwik 0.9.9 - Stable release
Component: UI (templates, javascript) Keywords:
Cc: Sensitive: no

Description (last modified by matt) (diff)

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

Changed 21 months ago by matt

  • description modified (diff)

Changed 21 months ago by vipsoft

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

Changed 21 months ago by matt

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

Changed 21 months ago by matt

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

Changed 21 months ago by matt

  • status changed from new to closed
  • resolution set to fixed

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

Note: See TracTickets for help on using tickets.