I have successfully downloaded a CSV export (comma delimited) on my mac and opened the file but because there are lots of commas in the description fields I decided to try a semicolon delimited export instead.
However, the second file does not open correctly either in TEXT EDITOR or EXCEL - the fields are misaligned.
Tried to revert to the comma version by putting speech marks around the comma (",") but when I did that and imported, the speech marks showed up in the text.
Try surrounding the text of each field (with commas in it) with quotes, not the separators.
For example, going a bit William Shatner:
The quick, brown, fox, jumped over the, lazy, dog ; Mr flibble says 'time to die'
The quick"," brown"," fox"," jumped over the"," lazy"," dog ; Mr flibble says 'time to die'
But I think you need
"The quick, brown, fox, jumped over the, lazy, dog" ; "Mr flibble says 'time to die'"
Thank you for the quick response - the problem is that I can surround the comma using 'find and replace' in excel (12000 instances, 4000 issues). But its more tricky to surround the whole text and there are parts of the text (like tables) which would presumably not format correctly if encapsulated by speech marks?
Don't do it with "find and replace", it's too primitive. There's all sorts of ways you might do it, but there's actually a really simple trick I've used - set the export separator to "," rather than , then all you have to do is pad the beginning and end of each line with a "
With a "," separator, everything gets treated as content, it shouldn't affect any tables or selections. You should, of course, check that none of the text contains a "," though.
Feels like it is something to do with the original export, as my colleague can export OK from his PC (not Mac) and it stays intact on google sheets.
But the file I export does not look OK in excel or google sheets. (Also, it looks wrong when I open his file on my mac but he tells me its something to do with PCs adding extra invisible characters in text data that Mac interprets as, I guess, delimiters..)
Phew, Atlassian Team 2021 blew by. With dozens of demos and a handful of keynotes, you may have missed some of the awesome Confluence Cloud sessions. Don't' worry, you can watch them all here or on Y...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events