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

Antal_SofalvyAntal_Sofalvy Member Posts: 13 Contributor II
edited June 2019 in Help

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...

 

Tagged:

Best Answer

Answers

  • Antal_SofalvyAntal_Sofalvy Member Posts: 13 Contributor II

    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_SofalvyAntal_Sofalvy Member Posts: 13 Contributor II

    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

Sign In or Register to comment.