I trade alot of options and used excel to determine my capital gains can i just add that number to the tax forms or do they need to see every trade?

[taxnano]

You can just use the total. If they request more information you can send you spreadsheet to them.