Welcome to the Q&A Forum
Browse the forum for helpful insights and fresh discussions about all things SEO.
Hi Lonneke
It depends on your version of Excel, but it sounds to me like you are opening a file that is CSV (comma separated values) and excel isn't seeing the comma as a delimiter.
When you first open the file, there should be a wizard that lets you specify that it is a delimited (not fixed) file and that your delimiter is a comma. That should fix your problem....
Carole
Hi L.B.,
Your best bet is to use Pivot Tables in Excel. With pivot tables, you'll be able to aggregate, sort, and filter the data, which will then become extremely valuable!
Carole
Bryan, thank you very much for your answer. I see the report you are referring to, but (unless I am missing something) it is not the report I had in mind.
The one you are referring to is a summary report that shows the grade of each Keyword-URL pairing, and how it has changed from the previous week.
What I am looking for is an Excel version of the detailed report for a given keyword/URL pairing - the one that shows all of the critical, high, moderate, low and optional elements with a check mark.
My absolute dream would be to have some sort of data dump with all the pages and all their individual elements, but I would be thrilled just to be able to export one page at a time. Any ideas?
I am preparing recommendations for my client's Webmaster from the On-page Report Card. I am integrating them into a larger Excel spreadsheet with other recommended changes.
So many SEO Moz reports can be exported to Excel. Is this an exception, or am I missing something? It would really save me a lot of time and effort.
Hi L.B.,
Your best bet is to use Pivot Tables in Excel. With pivot tables, you'll be able to aggregate, sort, and filter the data, which will then become extremely valuable!
Carole
Hi Lonneke
It depends on your version of Excel, but it sounds to me like you are opening a file that is CSV (comma separated values) and excel isn't seeing the comma as a delimiter.
When you first open the file, there should be a wizard that lets you specify that it is a delimited (not fixed) file and that your delimiter is a comma. That should fix your problem....
Carole