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
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
-
Unsolved Moz Pro crawl signaling missing canonical which are not?
Hi,
Moz Pro | | rolandvintners
I'm trying MozPro considering using it.
One of the tool which is appealing is the crawl and insights.
After quick use, I really question many of the alerts, for instance, I got a "missing canonical tag" on this url: https://vintners.co/wine/grawu_gto#2020 but when I check my markup, there's clearly a canonical tag: <link rel="canonical" href="https://vintners.co/wine/grawu_gto"> Anybody can explain?
I asked Moz Pro staff when being onboarded but didn't get an answer...
Honestly, I'm questioning the value of these crawls, or may be I miss something?0 -
Should I set blog category/tag pages as "noindex"? If so, how do I prevent "meta noindex" Moz crawl errors for those pages?
From what I can tell, SEO experts recommend setting blog category and tag pages (ie. "http://site.com/blog/tag/some-product") as "noindex, follow" in order to keep the page quality of indexable pages high. However, I just received a slew of critical crawl warnings from Moz for having these pages set to "noindex." Should the pages be indexed? If not, why am I receiving critical crawl warnings from Moz and how do I prevent this?
Moz Pro | | NichGunn0 -
Moz Crawl Test error
Moz crawl test show blank report for my website test - guitarcontrol.com. Why??? Please suggest.
Moz Pro | | zoe.wilson170 -
I have a Rel Canonical "notice" in my Crawl Diagnostics report. I'm presuming that means that the spider has detected a rel canonical tag and it is working as opposed to warning about an issue, is this correct?
I know this seems like a really dumb question but the site I'm working on is a BigCommerce one and I've been concerned about canonicalisation issues prior to receiving this report (I'm a SEOmoz pro newbie also!) and I just want to be clear I am reading this notice correctly. I presume this means that the site crawl has detected the rel canonical tag on these pages and it is working correctly. Is this correct?? Any input is much appreciated. Thanks
Moz Pro | | seanpearse0 -
How does SEOMoz crawl sites? Does it follow the sitemap?
I only ask because in my report it returned a few "no follow" links. Was wondering how SEOMoz operates.
Moz Pro | | Pikimal0 -
Is there a way to get the SEO campaign crawl to run from outside the US?
We are working on a international site that uses IP redirection. I am currently trying to crawl and monitor the Australian version of the site, however the pro-campaign crawler is running from the US and only giving me US data. Is there a way to tell the crawler to run through a local proxy so we can track international versions? Thanks!
Moz Pro | | MBASydney0 -
How long does it take for a campaign website crawl to be completed?
Our campaign website crawl has been 'crawling' now for 5 days. Is this a normal phenomenon or is something hanging up?
Moz Pro | | Discountvc0 -
Is there any way to manually initiate a crawl through SEOMoz?
... or do you actually have to wait a week for the next scheduled crawl date on a particular campaign? We've just made a ton of changes to our site, and it would be helpful to know if they will generate any warnings or errors sooner rather than later. Thanks!
Moz Pro | | jadeinteractive1