%3CLINGO-SUB%20id%3D%22lingo-sub-1569202%22%20slang%3D%22en-US%22%3EAnnouncing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1569202%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20excited%20to%20announce%20a%20new%20and%20exciting%20update%20to%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fgtxl2016%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EGet%20%26amp%3B%20Transform%20Data%20capabilities%3C%2FA%3E%20in%20Excel%20%E2%80%93%20PDF%20data%20connector!%20This%20has%20been%20one%20of%20the%20top%20requests%20from%20you%20and%20we%20heard%20you.%20With%20the%20new%20%3CSTRONG%3EFrom%20PDF%3C%2FSTRONG%3E%20connector%20you%20can%20connect%20to%20PDF%20files%2C%20and%20use%20the%20included%20data%20from%20the%20file%2C%20just%20like%20any%20other%20data%20source%20in%20Excel.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20new%20%3CSTRONG%3EFrom%20PDF%3C%2FSTRONG%3E%20connector%20is%20available%20as%20part%20of%20an%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fproducts.office.com%2Fbuy%2Fcompare-microsoft-office-products%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EOffice%20365%20subscription%3C%2FA%3E.%20If%20you%20are%20an%20Office%20365%20subscriber%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Foffice%2Fda36192c-58b9-4bc9-8d51-bb6eed468516%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Efind%20out%20how%20to%20get%20the%20latest%20updates%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20following%20sections%20describe%20how%20to%20connect%20to%20a%20PDF%20file%2C%20select%20data%2C%20and%20bring%20that%20data%20into%20Excel.%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--1296138611%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%20id%3D%22toc-hId--1296138391%22%3EConnect%20to%20a%20PDF%20file%3C%2FH2%3E%0A%3CP%3ETo%20connect%20to%20a%20PDF%20file%2C%20open%20the%20Get%20Data%20menu%20from%20the%20Data%20tab%20on%20the%20ribbon.%20Select%20From%20File%20and%20click%20%3CSTRONG%3EFrom%20PDF%3C%2FSTRONG%3E.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Picture1.png%22%20style%3D%22width%3A%20367px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F210503iDAA60BB9452BD463%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Picture1.png%22%20alt%3D%22Picture1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EYou%20are%20prompted%20to%20provide%20the%20location%20of%20the%20PDF%20file%20you%20want%20to%20use.%20Once%20you%20provide%20the%20file%20location%20and%20the%20PDF%20file%20loads%2C%20a%20Navigator%20window%20appears%20and%20displays%20the%20list%20of%20tables%20and%20pages%20in%20the%20document%20that%20you%20can%20import%20the%20data%20from.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Picture2.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F210504i77E3659F6896562D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Picture2.png%22%20alt%3D%22Picture2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EYou%20can%20browse%20through%20the%20PDF%20document%20data%20and%20select%20one%20or%20multiple%20elements%20to%20import%20into%20Excel.%20When%20you%20are%20ready%20to%20import%2C%20select%20the%20Load%20button%20to%20bring%20the%20data%20into%20Excel%2C%20or%20Transform%20Data%20to%20clean%20your%20data%20and%20prepare%20it%20for%20analysis%20with%20Power%20Query%20Editor.%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1191374222%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%20id%3D%22toc-hId-1191374442%22%3EAdvanced%20scenarios%3C%2FH2%3E%0A%3CP%3EIn%20some%20cases%2C%20you%20may%20want%20to%20import%20a%20range%20of%20pages%20from%20a%20PDF%20document%20at%20once.%20For%20this%2C%20you%20can%20specify%20the%20Start%20page%20and%20End%20Page%20as%20optional%20parameters%20for%20your%20PDF%20connection%20in%20the%20underlying%20M%20formula%20from%20the%20Power%20Query%20Editor%3A%3C%2FP%3E%0A%3CPRE%3EPdf.Tables(File.Contents(%22C%3A%5CSample.pdf%22)%2C%20%5BStartPage%3D5%2C%20EndPage%3D10%5D)%3C%2FPRE%3E%0A%3CP%3EFor%20more%20information%2C%20refer%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fpowerquery-m%2Fpdf-tables%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPdf.Tables%20M%20function%20documentation%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20hope%20you%20will%20like%20this%20new%20addition%20to%20Excel%20and%20we%E2%80%99d%20love%20to%20hear%20what%20you%20think%20about%20it.%20Please%20click%20%3CSTRONG%3EFile%20%26gt%3B%20Feedback%3C%2FSTRONG%3E%20and%20let%20us%20know.%20We%E2%80%99re%20excited%20to%20hear%20from%20you!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGuy%20Hunkin%3C%2FP%3E%0A%3CP%3E%E2%80%93%20Excel%20Team%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1569202%22%20slang%3D%22en-US%22%3E%3CP%3EWith%20the%20new%20From%20PDF%20connector%20in%20Excel%20you%20can%20now%20import%20and%20shape%20data%20from%20your%20PDF%20documents%2C%20just%20like%20from%20any%20other%20data%20source.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1569202%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBlog%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EGet%20%26amp%3B%20Transform%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EGet%20%26amp%3B%20Transform%20Data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EGet%20%26amp%3B%20Transform%20Data%20(Power%20Query)%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Query%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1569297%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1569297%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F25060%22%20target%3D%22_blank%22%3E%40Guy%20Hunkin%3C%2FA%3E%26nbsp%3B%2C%20thank%20you.%20Is%20it%20for%20all%20channels%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1569314%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1569314%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%2C%20it%20is%20for%20the%20Current%20Channel%20as%20we%20do%20with%20other%20new%20features%20in%20Excel.%20It%20will%20go%20to%20other%20channels%20according%20to%20the%20update%20cadence%20of%20a%20particular%20channel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1569324%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1569324%22%20slang%3D%22en-US%22%3E%3CP%3ENice.%20Sadly%20some%20of%20the%20data%20we%20need%20only%20comes%20to%20us%20via%20PDF.%20This%20will%20avoid%20a%20lot%20of%20manual%20keying%20or%20copying%20and%20reformatting%20text%20out%20of%20PDF%20files.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1569474%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1569474%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20development%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1569950%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1569950%22%20slang%3D%22en-US%22%3E%3CP%3EAwesome!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1570010%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570010%22%20slang%3D%22en-US%22%3E%3CP%3EGreat!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1570843%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1570843%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20really%20super.%20I'll%20be%20the%20king%20of%20accounting%20inside%203%20months%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1571977%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1571977%22%20slang%3D%22en-US%22%3E%3CP%3EGreat!%20Excel%20still%20getting%20functions%20to%20keep%20up%20relevant%20to%20companies%20innovation!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAm%20I%20dreaming%20to%20see%20OCR%20(optical%20character%20recognition)%20to%20come%20in%20the%20future%20for%20excel%3F%20VBA%20automating%20a%20collection%20of%20images%20%2F%20pictures%20%2F%20scanned%20images%20to%20retrieve%20data%3F%3C%2FP%3E%3CP%3E%26nbsp%3BOCR%3F%3C%2FP%3E%3CP%3EOptical%20handwritten%20recognition%3F%3C%2FP%3E%3CP%3ENice!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1572248%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1572248%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F324114%22%20target%3D%22_blank%22%3E%40EduardoGS%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20suggest%20you%20submit%20these%20ideas%20via%20Excel%20User%20Voice.%20It%20helps%20us%20to%20prioritize%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2F.%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGuy%3C%2FP%3E%0A%3CP%3E-%20Excel%20Team%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1572832%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1572832%22%20slang%3D%22en-US%22%3E%3CP%3EFrom%20File%20in%20Excel%20now%20%3D%20From%20File%20in%20Power%20BI%20Desktop%20-%20Kudos%20to%20the%20Excel%20Team%20-%20Just%205%20More%20to%20go%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%20Sam%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1580675%22%20slang%3D%22de-DE%22%3ESubject%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1580675%22%20slang%3D%22de-DE%22%3E%3CP%3EGreat!!!%3C%2FP%3E%3CP%3ELong-awaited%20opportunity%2C%20hope%20that%20this%20will%20be%20further%20developed.%20Like%20how%20to%20convert%20Java%20scripts%20into%20Excel%20formulas%20or%20VBA%2C%20which%20could%20be%20a%20great%20opportunity%20for%20Excel%20(Formulas%20or%2Fand%20VBA)%20over%20Java.%20Fantasy%20around%20a%20bit%2C%20the%20solution%20seduced%20me%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1601963%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601963%22%20slang%3D%22en-US%22%3E%3CP%3ELove%20it!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1612283%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612283%22%20slang%3D%22en-US%22%3E%3CP%3EI%20tested%20this%20new%20functionality%20today%20on%20some%20PDFs%20at%20work.%26nbsp%3B%20For%20some%20PDFs%20it%20had%20no%20problem%20identifying%20pages%20that%20contained%20data%20in%20table%20formats.%26nbsp%3B%20For%20other%20documents%20where%20the%20data%20layout%20looks%20like%20it%20was%20originally%20a%20spreadsheet%2C%20Excel%20thought%20the%20pages%20were%20blank.%26nbsp%3B%20Is%20there%20a%20reason%2C%20this%20new%20functionality%20would%20recognize%20data%20on%20a%20page(s)%20when%20there%20is%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1673225%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1673225%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F771145%22%20target%3D%22_blank%22%3E%40Mark_Kusek%3C%2FA%3E%26nbsp%3BCan%20you%20please%20share%20the%20problematic%20PDFs%20with%20me%20(just%20make%20sure%20that%20you%20are%20not%20sharing%20any%20private%20or%20sensitive%20information)%20and%20point%20me%20to%20the%20problematic%20tables%2Fpages%3F%20This%20will%20help%20me%20to%20reproduce%20the%20problem%20locally%20and%20investigate.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGuy%3C%2FP%3E%0A%3CP%3E-%20Excel%20Team%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1707185%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1707185%22%20slang%3D%22en-US%22%3E%3CP%3EKeen%20to%20use%20this%20-%20built%20some%20amazing%20solutions%20with%20it%20for%20Power%20BI%20already.%26nbsp%3B%20But%20it's%20not%20showing%20up%20in%20my%20menu%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20running%20Excel%20%22Subscription%20Product%2C%20Microsoft%20365%20Apps%20for%20enterprise%22.%20Current%20Channel.%20Just%20updated.%20Build%2016.0.13127.20502.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1716172%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1716172%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F25060%22%20target%3D%22_blank%22%3E%40Guy%20Hunkin%3C%2FA%3EI%20can't%20share%20the%20problematic%20PDF%20b%2Fc%20it%20contains%20personal%20identifiable%20information%20(PII).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1783429%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1783429%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F771145%22%20target%3D%22_blank%22%3E%40Mark_Kusek%3C%2FA%3E%2C%20the%20only%20way%20for%20me%20to%20check%20this%20is%20by%20testing%20it%20with%20the%20problematic%20PDF%20locally%20in%20our%20lab.%20If%20you%20are%20able%20to%20reproduce%20it%20on%20a%20PDF%20document%20that%20doesn't%20contain%20any%20sensitive%20data%20-%20please%20let%20me%20know.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGuy%3C%2FP%3E%0A%3CP%3E-%20Excel%20Team%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1783597%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1783597%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408377%22%20target%3D%22_blank%22%3E%40Mike_Honey%3C%2FA%3E%26nbsp%3B%2C%20the%20PDF%20connector%20should%20be%20available%20for%20you%20under%20the%20Data%20tab%20on%20the%20ribbon%20%26gt%3B%20Get%20Data%20%26gt%3B%20From%20File%20%26gt%3B%20From%20PDF.%20Please%20restart%20Excel%20and%20let%20me%20know%20if%20the%20connector%20appears%20for%20you%20as%20needed.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGuy%3C%2FP%3E%0A%3CP%3E-%20Excel%20Team%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1786431%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1786431%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F25060%22%20target%3D%22_blank%22%3E%40Guy%20Hunkin%3C%2FA%3E%26nbsp%3B-%20yes%20that%20worked%20-%20thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1789061%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1789061%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F25060%22%20target%3D%22_blank%22%3E%40Guy%20Hunkin%3C%2FA%3E%26nbsp%3Bthank%20you%20for%20your%20post!%20I%20have%20Microsoft%20Office%20365%20ProPlus%20and%20%22From%20PDF%22%20function%20is%20not%20available.%20Is%20it%20only%20available%20on%20Beta%20channel%3F%20If%20yes%2C%20when%20it%20will%20be%20available%20on%20all%20Office%20365%20channels%3F%20Many%20thanks!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1792567%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1792567%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F25060%22%20target%3D%22_blank%22%3E%40Guy%20Hunkin%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%20I%20just%20discovered%20this%20feature%2C%20and%20I%20love%20it.%20It%20is%20working%20as%20it%20should.%20I%20use%20it%20in%20Power%20BI%20as%20well%20in%20Excel.%20It%20helps%20me%20a%20lot%20to%20organize%20my%20marketing%20data%20sources%2C%20from%20which%2C%20unfortunately%2C%20some%20are%20published%20like%20PDFs.%20I%20am%20also%20using%20many%20third-party%20data%20sources%2C%20and%20those%20connectors%20are%20starting%20to%20work%20better%20and%20better%2C%20fortunately.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1792772%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1792772%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F835268%22%20target%3D%22_blank%22%3E%40karakhan%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPDF%20connector%20is%20available%20to%20all%20customers%20running%20Excel%20for%20Office%20365%20on%20the%20Current%20Update%20Channel.%20What's%20your%20Excel%20version%20please%3F%20Go%20to%20File%20%26gt%3B%20Account%20%26gt%3B%20and%20you%20will%20see%20your%20Excel%20version%20next%20to%20the%20About%20Excel%20button.%20It%20should%20look%20something%20like%20this%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%221.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F227439i0BC77C0B23949F00%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%221.png%22%20alt%3D%221.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGuy%3C%2FP%3E%0A%3CP%3E-%20Excel%20Team%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1792792%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1792792%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F25060%22%20target%3D%22_blank%22%3E%40Guy%20Hunkin%3C%2FA%3E%26nbsp%3Bthank%20you%20for%20quick%20reply.%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Untitled.jpg%22%20style%3D%22width%3A%20511px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F227440iD7FC6FB3D3713D20%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Untitled.jpg%22%20alt%3D%22Untitled.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20see%20your%20Excel%20version%20is%202011.%20How%20can%20I%20get%20latest%20version%20of%20Excel%3F%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1792800%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1792800%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F835268%22%20target%3D%22_blank%22%3E%40karakhan%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20PDF%20connector%20is%20currently%20available%20for%20Current%20Channel%20customers%20only.%20It%20will%20be%20coming%20to%20Semi-Annual%20soon.%20In%20a%20meantime%2C%20you%20can%20try%20switching%20to%20Current%20Channel%20as%20described%20at%20the%20following%20link%3A%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fdeployoffice%2Fchange-update-channels%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fdeployoffice%2Fchange-update-channels%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMy%20version%20is%20much%20newer%20than%20yours%20since%20I%20am%20a%20Microsoft%20worker%20and%20I%20am%20kind%20of%20a%20Beta%20tester%20of%20the%20new%20Excel%20versions%20before%20they%20are%20released%20to%20customers.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGuy%3C%2FP%3E%0A%3CP%3E-%20Excel%20Team%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1837249%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1837249%22%20slang%3D%22en-US%22%3E%3CP%3EUnfortunately%2C%20we%20are%20on%20an%20older%20version%20of%20Excel%20(2008)%20so%20I%20cannot%20test%20this%20new%20feature.%26nbsp%3B%20Before%20I%20submit%20a%20request%20to%20our%20IT%20dept%20to%20upgrade%2C%20can%20someone%20confirm%20whether%20the%20PDF%20connector%20will%20read%20data%20from%20form%20fields.%26nbsp%3B%20We%20conduct%20inspections%20in%20the%20field%20on%20mobile%20devices%20using%20PDF%20editable%20forms%20but%20the%20data%20becomes%20trapped%20in%20the%20form.%26nbsp%3B%20I'm%20hoping%20this%20connector%20will%20allow%20us%20to%20start%20mining%20data%20from%20key%20fields%20on%20the%20form.%26nbsp%3B%20Please%20advise.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1837310%22%20slang%3D%22en-US%22%3ERe%3A%20Announcing%20data%20import%20from%20PDF%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1837310%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F399809%22%20target%3D%22_blank%22%3E%40Fred_BIRD%3C%2FA%3E%26nbsp%3BI%20just%20tried%20to%20convert%20from%20PDF%20fields%2C%20but%20they%20are%20not%20visible.%20But%20I%20can%20not%20confirm%20for%20sure%20that%20it%20is%20not%20working.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

We are excited to announce a new and exciting update to Get & Transform Data capabilities in Excel – PDF data connector! This has been one of the top requests from you and we heard you. With the new From PDF connector you can connect to PDF files, and use the included data from the file, just like any other data source in Excel.

 

The new From PDF connector is available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get the latest updates.

 

The following sections describe how to connect to a PDF file, select data, and bring that data into Excel.

 

Connect to a PDF file

To connect to a PDF file, open the Get Data menu from the Data tab on the ribbon. Select From File and click From PDF.

Picture1.png

You are prompted to provide the location of the PDF file you want to use. Once you provide the file location and the PDF file loads, a Navigator window appears and displays the list of tables and pages in the document that you can import the data from.

Picture2.png

You can browse through the PDF document data and select one or multiple elements to import into Excel. When you are ready to import, select the Load button to bring the data into Excel, or Transform Data to clean your data and prepare it for analysis with Power Query Editor.

 

Advanced scenarios

In some cases, you may want to import a range of pages from a PDF document at once. For this, you can specify the Start page and End Page as optional parameters for your PDF connection in the underlying M formula from the Power Query Editor:

Pdf.Tables(File.Contents("C:\Sample.pdf"), [StartPage=5, EndPage=10])

For more information, refer to the Pdf.Tables M function documentation.

 

We hope you will like this new addition to Excel and we’d love to hear what you think about it. Please click File > Feedback and let us know. We’re excited to hear from you!

 

Guy Hunkin

– Excel Team

26 Comments

@Guy Hunkin , thank you. Is it for all channels?

Microsoft

@Sergei Baklan , it is for the Current Channel as we do with other new features in Excel. It will go to other channels according to the update cadence of a particular channel.

Frequent Contributor

Nice. Sadly some of the data we need only comes to us via PDF. This will avoid a lot of manual keying or copying and reformatting text out of PDF files.

Good development

Contributor

Awesome!

Contributor

Great!

Senior Member

This is really super. I'll be the king of accounting inside 3 months

Visitor

Great! Excel still getting functions to keep up relevant to companies innovation!

 

Am I dreaming to see OCR (optical character recognition) to come in the future for excel? VBA automating a collection of images / pictures / scanned images to retrieve data?

 OCR?

Optical handwritten recognition?

Nice!

Microsoft

@EduardoGS ,

 

I suggest you submit these ideas via Excel User Voice. It helps us to prioritize - https://excel.uservoice.com/.

 

Guy

- Excel Team

 

New Contributor

From File in Excel now = From File in Power BI Desktop - Kudos to the Excel Team - Just 5 More to go 

 

Cheers Sam

Trusted Contributor

Great!!!

Long-awaited opportunity, hope that this will also be further developed. Like how to convert Java scripts into Excel formulas or VBA, which could be a great opportunity for Excel (Formeln oder/und VBA) over Java. Fantasy around a bit, the solution seduced me

Senior Member

Love it! 

Visitor

I tested this new functionality today on some PDFs at work.  For some PDFs it had no problem identifying pages that contained data in table formats.  For other documents where the data layout looks like it was originally a spreadsheet, Excel thought the pages were blank.  Is there a reason, this new functionality would recognize data on a page(s) when there is? 

Microsoft

@Mark_Kusek Can you please share the problematic PDFs with me (just make sure that you are not sharing any private or sensitive information) and point me to the problematic tables/pages? This will help me to reproduce the problem locally and investigate.

 

Guy

- Excel Team

New Contributor

Keen to use this - built some amazing solutions with it for Power BI already.  But it's not showing up in my menu?

I'm running Excel "Subscription Product, Microsoft 365 Apps for enterprise". Current Channel. Just updated. Build 16.0.13127.20502.

Visitor

@Guy HunkinI can't share the problematic PDF b/c it contains personal identifiable information (PII).

Microsoft

@Mark_Kusek, the only way for me to check this is by testing it with the problematic PDF locally in our lab. If you are able to reproduce it on a PDF document that doesn't contain any sensitive data - please let me know.

 

Guy

- Excel Team

Microsoft

@Mike_Honey , the PDF connector should be available for you under the Data tab on the ribbon > Get Data > From File > From PDF. Please restart Excel and let me know if the connector appears for you as needed.

 

Guy

- Excel Team

New Contributor

@Guy Hunkin - yes that worked - thanks!

Occasional Visitor

@Guy Hunkin thank you for your post! I have Microsoft Office 365 ProPlus and "From PDF" function is not available. Is it only available on Beta channel? If yes, when it will be available on all Office 365 channels? Many thanks! 

Visitor

@Guy Hunkin  I just discovered this feature, and I love it. It is working as it should. I use it in Power BI as well in Excel. It helps me a lot to organize my marketing data sources, from which, unfortunately, some are published like PDFs. I am also using many third-party data sources, and those connectors are starting to work better and better, fortunately.

Microsoft

@karakhan ,

 

PDF connector is available to all customers running Excel for Office 365 on the Current Update Channel. What's your Excel version please? Go to File > Account > and you will see your Excel version next to the About Excel button. It should look something like this:

1.png

 

Guy

- Excel Team

 

Occasional Visitor

@Guy Hunkin thank you for quick reply. Untitled.jpg

I see your Excel version is 2011. How can I get latest version of Excel?

Thanks.

Microsoft

@karakhan ,

 

The PDF connector is currently available for Current Channel customers only. It will be coming to Semi-Annual soon. In a meantime, you can try switching to Current Channel as described at the following link:

https://docs.microsoft.com/en-us/deployoffice/change-update-channels

 

My version is much newer than yours since I am a Microsoft worker and I am kind of a Beta tester of the new Excel versions before they are released to customers.

 

Guy

- Excel Team

Visitor

Unfortunately, we are on an older version of Excel (2008) so I cannot test this new feature.  Before I submit a request to our IT dept to upgrade, can someone confirm whether the PDF connector will read data from form fields.  We conduct inspections in the field on mobile devices using PDF editable forms but the data becomes trapped in the form.  I'm hoping this connector will allow us to start mining data from key fields on the form.  Please advise.

 

Visitor

@Fred_BIRD I just tried to convert from PDF fields, but they are not visible. But I can not confirm for sure that it is not working.