Crawl Diagnostics : Problem of display in Excell.

[JonathanLeplang]

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

[MarkScully]

Hi Jonathan,

If it's simply Excel displaying the content incorrectly, you can follow these steps -

http://office.microsoft.com/en-us/excel-help/split-names-by-using-the-convert-text-to-columns-wizard-HA010102340.asp

If not, I can see if I can offer any other advice then.

Cheers,

Mark

[JonathanLeplang]

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 |

[MarkScully]

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?

[JonathanLeplang]

It's really kind, thank you for your help.

[JonathanLeplang]

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.

[MarkScully]

Glad you got it sorted Jonathan - Original spreadsheet opened up fine for me in Excel