In a document library, is it possible to create a new column that pulls this data from the files properties? I’ve tried adding 'Author' from existing site columns and creating my own single line of text column with a value of _Author and Author0 with no luck. Any help would be appreciated. Thanks!
Create a single line of text column named "_Author" in the library.
Another alternative, use powershell to upload file: