How to make a Crawl Report readable?
-
Hi!
I am trying to find out how I make my CSV report neat, so I can interprete the report.
I know have a CSV report with just numbers and text all in one column. I tried the button text to columns but that doesn't work because when I do that at column A it overwrites column B in which I have the same problem!
Thanks
-
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 Carole,
Thank you for your help. Before I can use a pivot table, I first need to split the columns with the data to different columns. How do I do that? I now have things like 'no,no no no no no, in one cel..
Lonneke
-
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
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Where is the crawl test tool located in this new site?
Hi there, Where is the crawl test tool located in this new moz site? Formerly it was, http://pro.seomoz.org/tools/crawl-test Hope you can help. Thanks:)
Moz Pro | | steveovens1 -
Find a 4xx or 5xx link referenced in an SEO Crawl Report
So I just got the Crawl Diagnostics report for a client site and it came back with a number of 4xx errors and even 1 5xx error. So while I can find the URL that has the problem, I cannot find the pages that have the links pointing to these non-existent or problematic pages. Normally I would just search the database for the site, but in this case I don't have access to it as the site is on a proprietary platform with no access other than to the CMS. Is there anyway to get the linking URL from the report? Thanks!
Moz Pro | | farlandlee0 -
Why are not nofollowed links counted in On-Page Analysis Report?
When I run the On-Page Analysis on our homepage, the report says the page has 238 **"Internal followed links". ** Why are not nofollowed internal links counted as well? Nofollowed links have been leaking link juice for quite some time now. Martin
Moz Pro | | TalkInThePark0 -
Sorting On-page Optimization Reports
I know there are several pre-set ways to sort the on-page optimization reports, but how can I custom sort them into my own order?
Moz Pro | | WillWatrous0 -
Recommended Custom Reporting Tool?
Can anyone recommend a reporting system I can use to send reports to my clients based on their campaigns in SEOMOZ This appears to be a missing link in the program - Or as a newbie I just have not found it yet. Thanks in advance!
Moz Pro | | HGbiz0 -
Changing Date Range in SEOMoz Campaign Reports?
Hey, I'm trying to create some old reports for a client and wanted to see how I can adjust the reports to a specific timeframe so I can view the statistics & changes between that time frame. Is this possible?
Moz Pro | | SavvyPanda
Thanks!0 -
Is there any way to view crawl errors historically?
One of the website's we monitor have been getting high duplicate page titles, as we work through the pages, we see changes and the number of duplicate page titles are decreasing. However, lately, it went up again and the duplicate page titles have increased. I wanted to ask if there's any way to view the new errors and the old errors separately or sorted in a way that can help me identify why we are getting new page crawl errors. Any advice would be great. Thanks!
Moz Pro | | TheNorthernOffice790