You asked
Is the canon ef 100 400mm f 4 5 5 6l is ii usm good for sports?
Yes, I think it's a sensible pick for a lot of sport. It's a 100-400mm zoom with stabilisation and autofocus, and my reach guide says 100-400mm on full frame is the right range for sport from the sideline. You can check the full spec on the lens page.
The catch is the f/4.5-5.6 aperture. It gets darker as you zoom in, so at 400mm you'll have less light to work with, and indoor sport will push you to higher ISO. On an APS-C body it frames like about 160-640mm, which gives you plenty of reach in a smaller kit.
For starting out, pair it with an APS-C body. For serious sport, my picks point to a full-frame body with a 200-600mm or 150-600mm zoom instead. If you're buying the lens, buying used can save a lot.
Written by Claude from this site's pages.