Donor sperm is used in treatments like IUI or IVF when male partner sperm is unavailable or has severe issues. It enables conception by fertilizing the egg with healthy donor sperm, helping single women, same-sex couples, or couples with male infertility.