Converting Blocked Company List from PDF to CSV for Enriched Data Extraction

I have a mega list of 80 pages of companies. It is a Govt. issued list in PDF form. I have converted to excel but it has blocked about 20 companies in each cell (to make it more difficult to scrape I suspect). How can I convert this to a CSV with each company on each line so I can use Clay to find the enriched data I need?

✅1

7 comments

Sue D.
·
·
This is the list I need to convert to CSV so I can use:
Sue D.
·
·
https://www.righttoknow.org.au/request/9252/response/27621/attach/4/fa%20220800560%20document%20released.pdf?cookie_passthrough=1
Sue D.
·
·
And this is the excel list
Eric N.
·
·
ask chat gpt
:thumbsup_all:1
Sue D.
·
·
https://workingin.sharepoint.com/:x:/s/Recruitment/EfuFZ5HltVFMu2qsHqjaZjYBgCdDuYb8M-AK6sDPssH_og?e=iTOd5s
Clay Team
APP
·
·
Hey Sue, just checking in here to see if you were able to get that list with the help of chatGPT. Let us know!
Sue D.
·
·
ChatGPT gave me some code but that didn't work. Ended up using Power Toys to convert, which was a little laborious but got the job done. 😅