Cellulose nanofibril (CNF) materials are candidates for the sustainable development of high mechanical performance nanomaterials. Due to inherent hydrophilicity and limited functionality range, most applications require chemical modification of CNF. However, targeted transformations directly on CNF are cumbersome due to the propensity of CNF to aggregate in non-aqueous solvents at high concentrations, complicating the choice of suitable reagents and requiring tedious separations of the final product. This work addresses this challenge by developing a general, entirely water-based, and experimentally simple methodology for functionalizing CNF, providing aliphatic, allylic, propargylic, azobenzylic, and substituted benzylic functional groups. The first step is NaIO4 oxidation to dialdehyde-CNF in the wet cake state, followed by oxime ligation with O-substituted hydroxylamines. The increased hydrolytic stability of oximes removes the need for reductive stabilization as often required for the analogous imines where aldehyde groups react with amines in water. Overall, the process provides a tailored degree of nanofibril functionalization (2-4.5 mmol/g) with the possible reversible detachment of the functionality under mildly acidic conditions, resulting in the reformation of dialdehyde CNF. The modified CNF materials were assessed for potential applications in green electronics and triboelectric nanogenerators. Water is a standing challenge in the chemical modification of cellulose nanofibrils. Here, authors employ oxime-ligation to solve this by direct covalent chemistry on dialdehyde-CNF in water and assess the material for potential applications in green electronics and triboelectric nanogenerators.