When LEGO acquired Bricklink, I thought they would standardize their color nomenclature, but two things happened in 2022 that made me realize it will never happen:
BL renamed "metal blue" to "pearl sand blue" while LEGO kept the old name "metallic sand blue"
LEGO has introduced two new colors, "vibrant yellow", which on BL has been called "neon yellow", and “warm tan” - “medium tan”.
Basically three missed opportunities to try to have a single color list.
Therefore I have completed a table that includes all the colors that LEGO has ever created (except for the exclusive ones DUPLO, Bionicle and Fabuland), prefixing the name of the corresponding color on Bricklink.