When I export analytics data and import the CSV to Excel, rows seem to be affected by signs like parenthesis, # or @ in the tweet texts, even though the separator is comma and import source is UTF-8.
It is a fairly long spreadsheet and there are numerous rows that aren’t correctly separated.
I use MS Office 2010 in Win8 64bit.
Any ideas or solution?
Thanks in advance!