I need some help pricing pokemon on excel

I have a semi large collection of bulk pokemon that I want to put into one giant excel sheet but I am having a hard time figuring out how to import pricing so when I add a card in it registers it and takes TCG’s pricing and connects it to the card. Any help? Is this actually possible? I have no prior experience or anything