I want to create a report of only de duplicate content pages as a csv file so i can create a script to canonicalize them.

[nvs.nim]

I want to create a report of only de duplicate content pages as a csv file so i can create a script to canonicalize them. So i get something like:

http://example.com/page1, http://example.com/page2, http://example.com/page3, http://example.com/page4,

Because I now have to open each in "Issue: Duplicate Page Content", and this takes a lot of time.

The same for duplicate page title.

[jdclerck]

Hi nvs.nim,

could you tell me what you did differently? I also get an empty AF column.

[nvs.nim]

Thanks! Because excel didn't seperate the fields right i didn't have the column AF. But i got it now! Thanks a lot!

[Matt-Williamson]

Josh is right - when you export as CSV there should be a column in the spreadsheet -

|

duplicate_page_content

This column contains all the URLS that are considered duplicates

|

[JoshPugh]

Yes it does, in column AF there is a list of Duplicate Page Content URLs

[nvs.nim]

It doesn't tell me what other pages are identical. Only that there are identical pages.

[JoshPugh]

Well.. SEOMoz Pro does it! Just check out the Crawl Diagnostics -> Duplicate Page Content then go to the top right and Export as CSV!