"Google CSV export format issue - AdWords, WebmasterTools, Analytics..."

Antal_Sofalvy

Hello,

Recently I've realized some issues with Google generated CSV files. When I CSV Read them into Rapidminer (v7.1) the result is strange - I attached a file for

The same happens in case of any CSV files exported from Google web related tools, like AdWords, Keyword Planner, WebmasterTools, etc.

The CSVs are usually tab separated and this is win1250 (I think) - but charset does not an issue

Please help me what I am overlooking?

 

Thanks,

Antal

 

PS Read File turnaround works but VERY time consuming...

 

bhupendra_patil

it looks like some sort of encoding issue,

 

in your import wizard try one of the UTF -encoding like in the screen shot below

 

 

bhupendra_patil

it looks like some sort of encoding issue,

 

in your import wizard try one of the UTF -encoding like in the screen shot below

 

 

Antal_Sofalvy

Thanks it looks OK - so encoding setting is the solution.

The issue is, that NOT every CSV is encoded accordingly - so I have to find out one by one... but it is my challenge.

 

 

Thanks,

Antal

 

 

Antal_Sofalvy

Thank you!

So it is encoding - hopefully all Google CSVs are UTF16...

Regards,

Antal

 

BTW if you want to set tab / tabulator for coloumn separator type \t

I have not found it in the documentation, hopefully it is useful