I have downloaded an excel sheet from "Links to your site" option of Google Webmaster Tools.

Now how to identify which links are dead and which are nofollow.
There is any way to find dead links from the list becuase there are many links in the excel sheet and very hard to find few dead links from them.