The header lists which column is which. Actual text is different with each CAD system. One example of the first line of the file:
Designator,Footprint,Mid X,Mid Y,Layer,Rotation,Value
Change this to:
Designator,Footprint,X, Y,Layer,Rotation,Value