I am not sure why this seems so hard – there must be a good reason that I don’t understand, but upon a copy/paste to and from Excel, it is seems oddly strange that AutoCAD does not auto-translate into the standard that is common across the whole world. I know one can link and some other shortcuts, but mostly , designers want to just get info in and out of AutoCAD.
Anyways, here are some links that I followed to to make routines to copy/paste to and from Excel easily.