Keying multiple objects at once?

So I have like 200 objects and I need to animate the viewport and render visibility on all of them simultaneously. I don’t want to have to go through each one and hit the I key perpetually in the outliner. I just want to be able to hit the I key once. I have played around with keying sets and that was a dead end. I also tried animating the group visibility but Blender won’t let me do that for some reason… solutions?

I hope spreadsheet(like xsi) is added to blender !!!:smiley: