Crawl Diagnostics : Problem of display in Excell.
-
Hi Mozers,
I've just finished watching the Crawl Diagnostics Webinar and when I try to export one of my campaign into the CSV format, I've a display problem into Microsoft Excell.
Every headtitles are into the "A" column so, I can't do anything with that : I can't organize the data,... It's totally unreadable.
What can I do?
Thank you for yours answers.
Jonathan
-
Glad you got it sorted Jonathan - Original spreadsheet opened up fine for me in Excel
-
Eventually, the problem was the format which was on my computer in .cvs. In .xlsx, there is no display problem.
Now I work with open office, the comma like delimitator and there is no problem anymore.
-
It's really kind, thank you for your help.
-
If you don't mind Jonathan, you could drop me a PM with a link to the spreadsheet so I could take a quick go at fixing it up for you?
-
Thank you Mark. It helps me a lot.
Now I've still a little problem, in the first colomn (A) it's not always beginning with a url.
For example : the 148 first lines begin with a url and the line 149 begin with that a text. So, after the line 149 all my results are distorted. Is it anything to do?
<colgroup><col width="80"></colgroup>
| FÃminin et tendance • Fermeture par bouton pression • Grandes anses de transport 2,5x 60cm",,,,http://www.4dimension.be/catalogue/article-acc-7885-13-159.html http://www.4dimension.be/catalogue/article-acc-6826-13-72.html http://www.4dimension.be/catalogue/article-acc-6654-13-615.html http://www.4dimension.be/catalogue/article-acc-10134-13-4.html http://www.4dimension.be/catalogue/article-ac-9562-13.html http://www.4dimension.be/catalogue/article-ac-9507-13.html http://www.4dimension.be/catalogue/article-ac-9803-13.html http://www.4dimension.be/catalogue/article-ac-9468-13.html http://www.4dimension.be/catalogue/article-acc-7883-13-164.html http://www.4dimension.be/catalogue/article-ac-10028-13.html http://www.4dimension.be/catalogue/article-ac-5407-13.html http://www.4dimension.be/catalogue/article-acc-10028-13-159.html http://www.4dimension.be/catalogue/article-acc-9515-13-288.html http://www.4dimension.be/catalogue/article-acc-7876-13-4.html http://www.4dimension.be/catalogue/article-ac-5352-13.html http://www.4dimension.be/catalogue/article-ac-6654-13.html http://www.4dimension.be/catalogue/article-ac-6664-13.html http://www.4dimension.be/catalogue/article-acc-9129-13-847.html http://www.4dimension.be/catalogue/article-ac-5366-13.html http://www.4dimension.be/catalogue/article-acc-5209-13-61.html http://www.4dimension.be/catalogue/article-acc-5382-13-2.html http://www.4dimension.be/catalogue/article-ac-4545-13.html http://www.4dimension.be/catalogue/article-acc-4545-13-1032.html http://www.4dimension.be/catalogue/article-acc-9803-13-273.html http://www.4dimension.be/catalogue/article-ac-6827-13.html http://www.4dimension.be/catalogue/article-acc-9858-13-2458.html http://www.4dimension.be/catalogue/article-acc-7881-13-212.html http://www.4dimension.be/catalogue/article-ac-7552-13.html http://www.4dimension.be/catalogue/article-acc-9866-13-25.html http://www.4dimension.be/catalogue/article-acc-9158-13-2314.html http://www.4dimension.be/catalogue/article-acc-9858-13-2455.html http://www.4dimension.be/catalogue/article-acc-5342-13-4.html http://www.4dimension.be/catalogue/article-ac-7873-13.html http://www.4dimension.be/catalogue/article-ac-7041-13.html http://www.4dimension.be/catalogue/article-acc-9845-13-4.html http://www.4dimension.be/catalogue/article-ac-7885-13.html http://www.4dimension.be/catalogue/article-ac-8186-13.html http://www.4dimension.be/catalogue/article-ac-8184-13.html http://www.4dimension.be/catalogue/article-acc-9866-13-4.html http://www.4dimension.be/catalogue/article-acc-6668-13-85.html http://www.4dimension.be/catalogue/article-ac-6668-13.html http://www.4dimension.be/catalogue/article-ac-9550-13.html http://www.4dimension.be/catalogue/article-ac-9592-13.html http://www.4dimension.be/catalogue/article-ac-8183-13.html http://www.4dimension.be/catalogue/article-ac-8314-13.html http://www.4dimension.be/catalogue/article-acc-6664-13-106.html http://www.4dimension.be/catalogue/article-acc-7885-13-213.html http://www.4dimension.be/catalogue/article-ac-10136-13.html http://www.4dimension.be/catalogue/article-ac-9845-13.html http://www.4dimension.be/catalogue/article-ac-9131-13.html,http://www.4dimension.be/catalogue/article-acc-9866-13-25.html http://www.4dimension.be/catalogue/article-acc-9866-13-4.html http://www.4dimension.be/catalogue/article-acc-9866-13-81.html,2012-11-05T19:28:18Z,0,0,0,0,http://www.4dimension.be/catalogue/categorie-sacs-bagagerie.html | -
Hi Jonathan,
If it's simply Excel displaying the content incorrectly, you can follow these steps -
If not, I can see if I can offer any other advice then.
Cheers,
Mark
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
-
Problem with Forums
I am trying to respond in the forums, but keep getting an error. 1 error prohibited this form from being saved: Response can't be blank anyone else having issues?
Moz Pro | | netviper0 -
How do I exclude my blog subfolder from being crawled with my main domain (www.) folder?
I am trying to setup two separate campaigns for my blog and for my main site. While it is easy enough to do through the wizard the results I am getting for my main site still include pages that are in my blog sub folder. Please Advise!
Moz Pro | | sameufemia0 -
I've got quite a few "Duplicate Page Title" Errors in my Crawl Diagnostics for my Wordpress Blog
Title says it all, is this an issue? The pages seem to be set up properly with Rel=Canonical so should i just ignore the duplicate page title erros in my Crawl Diagnostics dashboard? Thanks
Moz Pro | | SheffieldMarketing0 -
"Duplicate Page Title" Problem - Please Help
Hello, My website is categorized into 2 main categories. Sci/Tech (Has 4 sub-categories) Gadgets(Has 2 sub-categories) The Crawl diagnostic tool shows "Duplicate Page Title" error on Gadget's sub-categories while there's no error on the Sci/Tech. I don't really know how to get rid of these errors. Anyone has a solution to this?
Moz Pro | | MighteeObvious0 -
Crawler has stopped crawling my website
Hi all, I recently changed my site www.ipbskinning.com to ipbskinning.com. For some reason my weekly scan states that no pages have been crawled. I tried making a new campaign with the sub-domain ipbskinning.com but still the starter crawl returns nothing? Am I doing something wrong? :S Thanks all!
Moz Pro | | pezza34340 -
I have corrected the Problems in Crawl Diagnostics. When would it refresh/ re-crawl my site ?
I have corrected most of the problems shown in crawl diagnostics and changed the meta desc. , titles etc. When will SEOMOZ recrawl those pages and show that Its correct now ?
Moz Pro | | VarunBansal0 -
SEOMoz Crawling Only 1 Page
I entered a new site into my dashboard 2 days ago - everything looked kosher, there were a few hundred pages crawled and a whole bunch of errors. I came back this morning to start work on the site and SEOMoz has crawled the site again, this time returning only 1 page and 0 errors. I haven't even logged in to the site since the first crawl, so I couldn't have broken anything. Has anyone seen this before?
Moz Pro | | Junction0 -
Crawl Diagnostics Report Lacks Information
When I look at the crawl diagnostics, SEOMoz tells me there are 404 errors. This is understandable, because some pages were removed. What this report doesn't tell me is how those pages were discovered. This is a very important piece of information, because it would tell me there are links pointing to those pages, either internal or external. I believe the internal links have been removed. If the report told me how if found the link, I would be able to take immediate action. Without that information, I have to go so a lot of investigation. And when you have a million pages, that isn't easy. Some possibilities: The crawler remembered the page from the previous crawl. There was a link from an index page - i.e. it is in the database still There was an individual link from another story - so now there are broken links Ditto, but it in on a static index page The link was from an external source - I need to make a redirect Am I missing something, or is this a feature the SEO Moz crawler doesn't have yet? What can I do (other than check all my pages) to discover this?
Moz Pro | | loopyal0