It means that it causes a lot of fear to the point of making your hair stand on end. It means that it produces dread, that it is overwhelming, shocking, frightening, chilling.
That makes your hair stand on end, especially out of fear. See spook, replenish.
That creepy, that shudders, that horrifies, that causes fright.