🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

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

Find more posts tagged with

AI Studio

CSV

Accepted answers

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

2016-08-09 16_26_51-Settings.png

All comments

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

2016-08-09 16_26_51-Settings.png

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