Loading Profile...
.csv export is not comma separated
The .csv export of the product backlog saves a file with data separated by semi-colons instead of commas, so the result does not display properly in excel:
I’m annoyed
2
people have this problem
I have this problem, too!
Tell me when someone solves it.
The more people who report this problem, the more it gets noticed.
The more people who report this problem, the more it gets noticed.
The company marked this problem solved.
Create a customer community for your own organization
Plans starting at $19/month
-
Inappropriate?Hello!
I'm sorry for such delay in responding. We had some national holidays.
I've tried to reproduce your case on our computers, using Office 2007
Professional on Windows, OpenOffice.org on Windows, Mac and Linux.
Both Excel 2007 and OpenOffice were working as expected.
I'm not sure what can be couse of this problem. Could you provide
a little bit more details on software you're using, ie. Excel version? -
Inappropriate?The excel version isn't really relevant, but I am using excel 2007. The problem is exactly as I have stated it, the application does not save a "comma" separated file, it saves a semi-colon separated file. If I save the export and then open it with notepad instead of excel, I can clearly see that there are no commas, only semi-colons.
If I then do a search-and-replace on the exported file in notepad, replacing all of the semi-colons with commas, then the file will open correctly in excel. I would just like the application to save the export correctly so that I do not have to do this search-and-replace every time.
See screenshot of the file with SEMI-COLONS, not commas
-
Inappropriate?We're using semicolon deliberately, that is not a bug. Being one of standard CSV (or more precisely DSV) formats, it works well on our testing machines.
Probably this is an issue related to localization. We're working on that and this will be resolved soon. -
Inappropriate?Just confirmed it on US-localized machine. This will be fixed shortly.
-
Inappropriate?thanks for the quick reply!
-
Inappropriate?For a temporary work-around you can do following:
- Export your backlog to CSV and save it as file on disk.
- Open your Excel 2007
- From main menu select Data and than "From Text"
- Select previously saved file
- In "Import Wizard", step 1 select "Delimited"
- Step 2: select "semicolon" only.
- Finish the wizard and place your imported data on new sheet.
-
-
