Quickly review Error Report by parsing Element ID in spreadsheet

I find the Error Report - Warning - Select by ID process to be a little unwieldy in Revit (at the moment).

Here is a little process that may speed things up for you when reviewing a Error Report in Revit.

1. Save Error Report to HTML


2. Open HTML Error Report


3. Copy data to Excel spreadsheet.


4. Use RIGHT formula to extract only the id number to a new column.
   eg =RIGHT(C3,7)


5. Copy the cell containing the id number to the 'Select Elements by ID' dialog in Revit.