You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When exporting a CSV file from the report system, it cannot be opened in Excel correctly anymore. No matter what encoder is used, it will always only display the first column. All other columns are cut off.
The file is still using comma to seperate the data. Nevertheless, the data cannot be displayed correctly.
The text was updated successfully, but these errors were encountered:
Since when doesn't it work anymore?
What are your Matomo and Excel versions?
Did you try to use the TSV format instead of the CSV format while exporting Matomo data into Excel file?
I'll close this one now, as there hadn't been an further feedback.
Excel often fails when using CSV files that use a comma as separator, as it expects a semicolon instead. In most cases it works fine when opening the file customly and define the separators manually.
sgiehl
added
answered
For when a question was asked and we referred to forum or answered it.
and removed
Waiting for user feedback
Indicates the Matomo team is waiting for feedback from the author or other users.
labels
Oct 9, 2023
When exporting a CSV file from the report system, it cannot be opened in Excel correctly anymore. No matter what encoder is used, it will always only display the first column. All other columns are cut off.
The file is still using comma to seperate the data. Nevertheless, the data cannot be displayed correctly.
The text was updated successfully, but these errors were encountered: