How to make a Crawl Report readable?

[HetCommunicatielokaal]

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

[calalouf]

Hi Lonneke

It depends on your version of Excel, but it sounds to me like you are opening a file that is CSV (comma separated values) and excel isn't seeing the comma as a delimiter.

When you first open the file, there should be a wizard that lets you specify that it is a delimited (not fixed) file and that your delimiter is a comma. That should fix your problem....

Carole

[HetCommunicatielokaal]

Hi Carole,

Thank you for your help. Before I can use a pivot table, I first need to split the columns with the data to different columns. How do I do that? I now have things like 'no,no no no no no, in one cel..

Lonneke

[calalouf]

Hi L.B.,

Your best bet is to use Pivot Tables in Excel. With pivot tables, you'll be able to aggregate, sort, and filter the data, which will then become extremely valuable!

Carole