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
-
Is there a tool to crawl website meta tags to locate any in an incorrect language?
Example: I'm interested in crawling a regional site for Brazil to find any meta tags that are still in English with the goal being to fix any localization issues.
Moz Pro | | mattsolar0 -
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
Moz Pro | | HetCommunicatielokaal0 -
Why is my crawl STILL in progress?
I'm a bit new here, but we've had a few crawls done already. They are always finished by Wednesday night. Our website is not large (by any means), but the crawl still says it's in progress now 3 days later. What's the deal here?!?
Moz Pro | | Kibin0 -
El "Crawl Diagnostics Summary" me indica que tengo contenido duplicado
Como El "Crawl Diagnostics Summary"pero la verdad es que son las mismas paginas con el wwww y sin el www. que puedo hacer para quitar esta situacionde error.
Moz Pro | | arteweb20 -
Crawl Test produced only 1 page
Hi, I recently submitted a crawl for www.cirrato.com using SEOMoz Crawl Test Tool. I have a lot of pages, but the crawl result shows only 1 page, which is the front page and nothing else... Does anyone know what this could mean or what the problem is?
Moz Pro | | yusufcirrato0 -
After fixing errors can I re-crawl for diagnostics?
As I am fixing errors will the campaign automatically update to show where I have fixed issues?
Moz Pro | | eidna220 -
Crawl still in progress ...
Hi guys, New crawl on one of my campaigns is still in progress since November 27th, i didn't get new data since November 19th 2011 ... What should i do ?
Moz Pro | | DavidEichholtzer0 -
Potential site architecture problem.
We are experiencing a problem in which category pages do not appear to be passing Page Authority to subcategory pages. See the example below: Home page has PA of 47 http://www.minespress.com/ The next level category page down has a PA of 34 http://www.minespress.com/category/apparel The next sub category down has PA of 1, and shows no links at all in spite of the fact that we got to it from a category link http://www.minespress.com/category/golf-shirts The page in question is crawlable, is indexed and has nothing that we can see that would be prevent it from showing Page Authority and a link profile using your tools. Do we have a site architecture problem?
Moz Pro | | smines0