I'm trying to make a macOS service using Automator to extract PDF annotations and get the information into an Excel file.
I can successfully get the annotations from a PDF, and export them to a text file. But if I try to parse the same information to a new Excel file, all the information is pasted into a single cell.
What would be the correct steps in Automator, to have each text line in separated Excel rows?
Best Answer
Assuming you know the basics of Automator....Create a workflow with these Actions:
In the AppleScript Action copy & paste the following:
Note: You may run into issues if your annotations contain quotes, however there will be no problem if you use smart quotes.
You can select your pdf in the first prompt.
Sources: https://www.macosxautomation.com/applescript/sbrt/sbrt-09.html