Row error when importing CSV into Excel



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!


Try this:

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