Disclosure: Some of the links below are affiliate links, meaning, at no additional cost to you, I will earn a commission if you click through and make a purchase. This is particularly helpful if you need to clean a data set for analysis or importing names into a sales database. The data is comprised of over names with multiple columns. Open the PDF that contains the data.
Convert PDF files to Excel.
Open Excel. Click on Blank Workbook.
Select Delimited then Next in the dialog box. Check the Treat Consecutive Delimiters as One box because there are multiple periods between the text. Select None in the Text Qualifier drop down, then click Next. You will have to adjust the data format for each column depending on the data being imported.
How to Convert PDF to Excel
In this case, we are importing text so General is fine. Review the output in the Data Preview window then click on Finish when satisfied.
Touch-ups will have to be made once t he data is imported. This will consist of reviewing the data and ensuring data resides in the appropriate columns.
Depending on the quantity, this may be time consuming. To separate city and state into their own columns, select the data in the column that contains city and state and then select Text to columns in the Data tab of the ribbon.
Follow the same process to the name column to separate First and Last name.
This function will save significant time. It will be easier to gather information to analyze or upload into a CRM.
Be sure to bookmark blueReefAdvisor for other tips on Excel and other Office applications. Hopefully you found this tutorial useful.
If there is something specific you would like to see in a tutorial format, just let me know.