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
-
Problem to log into moz
Every time the moz logs me out from the account and then I can not log in. It shows on the left side my name like I am logged in and then when I want go to community suddenly I am not logged in. It offen shows 502 error. It was first doing on firefox, then I manage to log in chrome and now I had to log in private browsing.
Moz Pro | | Rebeca12 -
Hoe to crawl specific subfolders
I tried to create a campaign to crawl the subfolders of my site, but it stops at just 1 folder. Basically what I want to do is crawl everything after folder1: www.domain.com/web/folder1/* I tried to create 2 campaigns: Subfolder Campaign 1: www.domain.com/web/folder1/*
Moz Pro | | gofluent
Subfolder Campaign 2: www.domain.com/web/folder1/ In both cases, it did not crawl and folders after the last /. Can you help me ?0 -
Where has the old seomoz crawl tool gone? I can't seem to find it
I'm looking for the (SEO)moz crawl tool - but can't find it. Where has it gone?
Moz Pro | | SearchMotion0 -
Why does SEOMoz only crawl 1 page of my site?
My site is: www.thetravelingdutchman.com. It has quite a few pages, but for some reason SEOMoz only crawls one. Please advise. Thanks, Jasper
Moz Pro | | Japking0 -
Keyword Difficulty Tool Problems?
I was just using the keyword difficulty tool and for some reason, some of the keywords show "not enough data"...I'm not sure why this is the case because a few days ago, there was data... Anyway, is this because it take time for the tool to gather data each month, or is it because there's an issue with the GoogleAPI? Thanks a lot for your help!
Moz Pro | | simonmhchiu870 -
Seo moz crawl is not updating
When I check our seo campaign I can see that the report was not updated. It still show that the next crawl is Nov 1 but it is already Nov 3.
Moz Pro | | shebinhassan0 -
Why is Roger crawling pages that are disallowed in my robots.txt file?
I have specified the following in my robots.txt file: Disallow: /catalog/product_compare/ Yet Roger is crawling these pages = 1,357 errors. Is this a bug or am I missing something in my robots.txt file? Here's one of the URLs that Roger pulled: <colgroup><col width="312"></colgroup>
Moz Pro | | MeltButterySpread
| example.com/catalog/product_compare/add/product/19241/uenc/aHR0cDovL2ZyZXNocHJvZHVjZWNsb3RoZXMuY29tL3RvcHMvYWxsLXRvcHM_cD02/ Please let me know if my problem is in robots.txt or if Roger spaced this one. Thanks! |0 -
The Site Explorer crawl shows errors for files/folders that do not exist.
I'm fairly certain there is ultimately something amiss on our server but the Site Explorer report on my website (www.kpmginstitutes.com) is showing thousands of folders that do not exist. Example: For my "About Us" page (www.kpmginstitutes.com/about-us.aspx), the report shows a link: www.kpmginstitutes.com/rss/industries/404-institute/404-institute/about-us.aspx. We do have "rss", "industries", "404-institute" folders but they are parallel in the architecture, not sequential as indicated in the error url. Has anyone else seen these types of error in your Site Explorer reports?
Moz Pro | | dturkington0