PDF Data Connector from Microsoft will help you import and use PDF data into Microsoft Excel spreadsheets. Learn how to use it.

Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.

If you want to extract highlighted text from PDF file as a plain text file, then this post covers some good free PDF Highlight Extractor software to do that.