How to get the insights report's csv file into a good format?

[Tim Kahlert]

Does anyone happen to know how to get the csv file into a good format? Good in terms of easily readable so that one could turn it into a graphic.

 

[Phil Rozek]

@Tim Kahlert, the "phone calls" report is a mess. What I'd do is remove a bunch of columns and labels, so you have only the days and numbers of phone calls. Then turn that into a pivot chart.

It's not beautiful, but it is simple and fast.

The "discovery" GMB Insights report is far less cluttered, by the way. (Not that I use or export anything in GMB Insights much.)

 

[Lluc]

Hi @Tim Kahlert , I'm not sure if I'm understanding correctly but have you tried importing the csv file to Google sheets? I believe in Excel you can also convert de csv format.

P.S. We switched to Supermetrics over two years ago for the GMB data extraction and it is well worth it! you can schedule the data extraction and you can export data from many different services/tools like GSC, SEMRUSH, MOZ, etc.

 

[johnlavapie_SEO]

@Tim Kahlert it seems it exported all the data in a single column. Not sure if this is the problem you are trying to solve. If it is, you have to fix the data first - then I will refer to what @Phil Rozek just mentioned above to create a Pivot Table.

To fix the single column issue, follow the steps:

• Highlight the cells with the data

• From the menu, click - Data

• Click Text to Columns

• Select Delimited and click Next
• Check Comma (it's the one separating your data columns) and click Finish

That should separate the data from a single column to multiple columns. Then use it to create pivot charts.

 

[Tim Kahlert]

@Tim Kahlert, the "phone calls" report is a mess. What I'd do is remove a bunch of columns and labels, so you have only the days and numbers of phone calls. Then turn that into a pivot chart.

It's not beautiful, but it is simple and fast.

The "discovery" GMB Insights report is far less cluttered, by the way. (Not that I use or export anything in GMB Insights much.)

That's a really good tip, thank you! I expected it to be more user-friendly, to be honest. Not sure if I'm going to use it though.

 

[Tim Kahlert]

Hi @Tim Kahlert , I'm not sure if I'm understanding correctly but have you tried importing the csv file to Google sheets? I believe in Excel you can also convert de csv format.

P.S. We switched to Supermetrics over two years ago for the GMB data extraction and it is well worth it! you can schedule the data extraction and you can export data from many different services/tools like GSC, SEMRUSH, MOZ, etc.

Thank you! I haven't tried the import, no. I'm not sure if I even want to use it this way. I may check out Supermetrics, thanks.

 

[Tim Kahlert]

@Tim Kahlert it seems it exported all the data in a single column. Not sure if this is the problem you are trying to solve. If it is, you have to fix the data first - then I will refer to what @Phil Rozek just mentioned above to create a Pivot Table.

To fix the single column issue, follow the steps:

• Highlight the cells with the data

• From the menu, click - Data

• Click Text to Columns

• Select Delimited and click Next
• Check Comma (it's the one separating your data columns) and click Finish

That should separate the data from a single column to multiple columns. Then use it to create pivot charts.

Man, thanks for that. I ever wanted to know how that works. Whenever I have such a problem I will come back to this thread now. haha