Technically you are still doing cosine similarity with the dot product in the case of unit vectors. If you look at the formula, the cosine of the angle between vectors is the dot product divided by the product of the lengths of each vector. So in this case the length of each vector is 1, so your denominator is 1. So all you have in the numerator is the dot product. So the cosine of the angle is the dot product!


More discussion and testing here:


@raymonddavey is exactly right. It doesn’t have to be a csv file, but not that it cannot be an xlsx file because the Excel cells can’t hold the vector because the vector is too big. CSV files work really well, though.