Print

Print


Hi Andrea,

Have you tried Power Query in Excel, which allows to import from PDF file (Data > From File > From PDF). I imported tables in PDF files to Excel before, but not sure about scans of paper from 70s. 

-Jingjing

-----Original Message-----
From: Code for Libraries <[log in to unmask]> On Behalf Of Medina-Smith, Andrea M. (Fed)
Sent: Tuesday, June 21, 2022 1:47 PM
To: [log in to unmask]
Subject: [CODE4LIB] Converting old tables in PDF to CSV

This email originated outside TTU. Please exercise caution<https://askit.ttu.edu/phishing>!


Hello List,

Has anyone had success converting tables in a PDF to CSV? These are scans of paper from the 70s on forward. I know this isn't a super easy conversion, but I would think it's not impossible either.

Thanks,
Andrea

--

Andrea Medina-Smith
Data Librarian
Information Services Office
National Institute of Standards and Technology [log in to unmask]<mailto:[log in to unmask]>
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Forcid.org%2F0000-0002-1217-701X&amp;data=05%7C01%7Cjingjing.wu%40TTU.EDU%7Cdac1ec35312942078fd108da53b67422%7C178a51bf8b2049ffb65556245d5c173c%7C0%7C0%7C637914340338696924%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=uE6y8ORbe5ukolU5FKjK6UTUfEFalDwaFVj6%2F5nzVhI%3D&amp;reserved=0