In Charge Coupled Device (CCD) detectors the electrons excited upon absorption of a single x-ray photon quickly diffuse and generate charge-spots often larger than pixel dimensions. In the soft x-ray range this phenomenon drastically limits the effective spatial resolution to approximately 25\mu m, irrespective of the pixel size. For very low fluence the charge-cloud centroid determination can be used, on each individual spot, to estimate the actual photon impact position with sub-pixel precision. The readout noise and speed, together with the charge and spatial undersampling, are the main factors limiting the accuracy of this procedure in commercial devices. We have developed and extensively tested an algorithm for efficient centroid reconstruction on images acquired by low noise detectors not designed for single photon counting. We have thus measured a position uncertainty of 6-7\mu m in CCDs with 13.5\mu m and 20.0\mu m pixel size, around 1 keV photon energy. We have analyzed the centroid calculation performances by modelling the spot generation process. We show how the resolution is affected by both random uncertainty, mainly ascribed to the readout noise, and systematic error, due to the undersampling of the charge spot. This study was motivated by the growing need of of high-resolution high-sensitivity 2D position sensitive detectors in resonant inelastic (soft) x-ray scattering (RIXS), an emergent synchrotron radiation based spectroscopy.