Spider Plants love bright natural light, but too much direct sun will cause burn.  They'll survive in lower light but won't grow much. This can also cause the foliage to turn pale and weak. Like many indoor plants, a location with indirect sunlight is their sweet spot.