Problem solved, just a tip for others. Short version - make sure the USB cable is fully inserted into Sparki if you are having problems connecting even if some of the LEDs light up.
After installing software I tried connecting Sparki. Power & RGB lights came on but any movement of the cable or Sparki and they would shut off and come on again. I could not upload sketches to Sparki, and the Serial Port selection was greyed out on Windows computer. On a Mac there were Serial Port choices, but all bluetooth and none worked. I installed the software on 4 different computers. Finally on the fourth I shoved the USB cable further in on the Sparki and it started to load the drivers. It’s worked fine since then including going back to the first computer.