Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Problem opening CSV files in Excel #20211

Closed
samiii3103 opened this issue Jan 13, 2023 · 2 comments
Closed

Problem opening CSV files in Excel #20211

samiii3103 opened this issue Jan 13, 2023 · 2 comments
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@samiii3103
Copy link

samiii3103 commented Jan 13, 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.
ImportWindowExcel

The file is still using comma to seperate the data. Nevertheless, the data cannot be displayed correctly.
EditorView

@heurteph-ei
Copy link

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?

@sgiehl sgiehl added the Waiting for user feedback Indicates the Matomo team is waiting for feedback from the author or other users. label Jan 18, 2023
@sgiehl
Copy link
Member

sgiehl commented Oct 9, 2023

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 sgiehl closed this as not planned Won't fix, can't repro, duplicate, stale Oct 9, 2023
@sgiehl 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Development

No branches or pull requests

3 participants