Taking information from a PDF and creating a spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-3544834%22%20slang%3D%22en-US%22%3ETaking%20information%20from%20a%20PDF%20and%20creating%20a%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3544834%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20take%20information%20from%20a%20uniformly%20formatted%20pdf%20document%20(%3CA%20href%3D%22https%3A%2F%2Fhnldoc.ehawaii.gov%2Fhnldoc%2Fdocument-download%3Fid%3D11478%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fhnldoc.ehawaii.gov%2Fhnldoc%2Fdocument-download%3Fid%3D11478%3C%2FA%3E)%20and%20convert%20it%20to%20a%20spreadsheet.%20Ideally%2C%20I%20need%20fields%20for%20Name%2C%20Phone%2C%20Email%2C%20Meeting%20Date%2C%20Position%20on%20the%20Matter%2C%20and%20the%20Written%20Testimony.%20The%20pdf%20is%20300%2B%20pages%20and%20it%20would%20be%20nice%20to%20standardize%20the%20data%20entry%20if%20it%20is%20possible%20on%20excel.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mayadesh_0-1656008113025.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22mayadesh_0-1656008113025.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F383126i83237A3898397F5C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22mayadesh_0-1656008113025.png%22%20alt%3D%22mayadesh_0-1656008113025.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3544834%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Is there a way to take information from a uniformly formatted pdf document (https://hnldoc.ehawaii.gov/hnldoc/document-download?id=11478) and convert it to a spreadsheet. Ideally, I need fields for Name, Phone, Email, Meeting Date, Position on the Matter, and the Written Testimony. The pdf is 300+ pages and it would be nice to standardize the data entry if it is possible on excel. 

mayadesh_0-1656008113025.png

 

0 Replies