This dataset includes measured DOC concentration, and modelled DOC concentration derived from UV-visible absorbance spectra. We also include measured chlorophyll concentration, pH and conductivity. The natural water samples were collected from freshwater ecosystems in the UK, and site names and locations. Samples were also collected at set intervals throughout the year, from mesocosm experiments simulating natural lake ecosystems. Data on measured and modelled DOC concentration, chlorophyll concentration, pH and conductivity for the mesocosms sampled, are also included. Full details about this dataset can be found at https://doi.org/10.5285/6abbc357-1b69-49b4-be28-a77eb7bc6c7f