Read the downloaded data

[Abel73]

I am trying to open the downloaded gdelt data with read.csv.

The gdelt event data, to my knowledge, should have 61 variables (61 columns)

If I open the .csv file without setting "sep", I will get a data frame with 7 columns. This is because the raw data use "\t" to seperate variables.

If I read useing "sep="\t"", I still only get a data frame with 58 columns. What's worse, many column apparently appear at the wrong columns.

I wonder how could this happen?