If you are having problems with the ‘Copy Spreadsheet’ utility, it is likely because you are running 64 bit Revit or you have recently updated Revit. If you haven’t heard of this tool, it is a simple program made in Autohotkey, and it automates the ‘copying’ of data from a spreadsheet into a Revit schedule. The Revit schedule will need to be a key schedule, and you will need to add the columns and rows before starting the utility.
Head over to http://forums.augi.com/showpost.php?p=950435&postcount=1 for the updated version.
You may need to login to AUGI to access the above.