Row error when importing CSV into Excel

analytics

#1

Hi there,

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!


#2

Try this: http://superuser.com/a/396494

Or add sep=, as the first line of the file