{"id":758,"date":"2015-02-16T00:26:51","date_gmt":"2015-02-16T07:26:51","guid":{"rendered":"http:\/\/homepages.uc.edu\/~yaozo\/wordpress\/?p=758"},"modified":"2015-02-16T00:26:51","modified_gmt":"2015-02-16T07:26:51","slug":"batch-convert-pdf-to-excel","status":"publish","type":"post","link":"https:\/\/zhuoyao.net\/index.php\/2015\/02\/16\/batch-convert-pdf-to-excel\/","title":{"rendered":"Batch convert pdf to Excel"},"content":{"rendered":"<p>You can use an Action in Adobe Acrobat Pro to convert your PDF files to Excel in one operation. To do that, create a new action (<strong>Tools&gt;Action Wizard&gt;Create new action&#8230;<\/strong>).<\/p>\n<p>Then <strong>add the &#8220;Save&#8221;<\/strong> tool <strong>from Save&amp;Export<\/strong> to your new action.<strong> Click on the &#8220;Specify Settings&#8221;<\/strong>button for your save tool and <strong>check &#8220;Export File(s) to Alternate Format&#8221;<\/strong> <strong>and select your output format.<\/strong><\/p>\n<p>Now you can run this action on a number of files, and all of them will be exported to Excel.<\/p>\n<p>&nbsp;<\/p>\n<div class=\"jive-rendered-content\">\n<p>Certainly in my Win 7, Acrobat 11 I can convert a single pdf file to excell (File-&gt;Save as Other-&gt;spreadsheet).\u00a0 But I have 200+ scanned pdf files to convert &#8211; so I need to load these as a batch to process the whole bunch.\u00a0 I cannot find a batch function for scanned pdf to excel conversion.\u00a0 Any suggestions greatly appreciated.\u00a0 Thanks.<\/p>\n<\/div>\n<div class=\"j-answer-rollup\">\n<div class=\"j-inline-correct-answer\">\n<header class=\"j-author-block\"><span class=\"j-avatar-container\"><a class=\"j-avatar  jiveTT-hover-user\" title=\"dave_m_k\" href=\"https:\/\/forums.adobe.com\/people\/dave_m_k\" data-userid=\"639481\" data-online=\"false\" data-presence=\"null\" data-externalid=\"\" data-avatarid=\"7235\" data-username=\"dave_m_k\"><img loading=\"lazy\" decoding=\"async\" class=\"jive-avatar\" title=\"dave_m_k\" src=\"https:\/\/forums.adobe.com\/people\/dave_m_k\/avatar\/32.png?a=7235\" alt=\"dave_m_k\" width=\"32\" height=\"32\" data-avatarid=\"7235\" data-username=\"dave_m_k\" data-height=\"32\" data-random=\"0ght5nvtebgknvcxr\" \/><\/a><\/span><\/p>\n<div class=\"j-author-info\"><strong class=\"font-color-okay j-line1\">Correct Answer<\/strong><span class=\"font-color-meta j-line2\">by <a class=\"jive-username-link  jiveTT-hover-user  \" href=\"https:\/\/forums.adobe.com\/people\/dave_m_k\" data-username=\"dave_m_k\" data-avatarid=\"7235\" data-userid=\"639481\" data-online=\"false\" data-presence=\"null\" data-externalid=\"\">dave_m_k<\/a> on Jan 21, 2013 12:07 AM<\/span><\/div>\n<\/header>\n<section>\n<div class=\"jive-rendered-content\">\n<p>With Acrobat XI Pro you can use the Action Wizard.<\/p>\n<p>&nbsp;<\/p>\n<p>Use the &#8216;Save&#8217; command from the &#8216;Save &amp; Export&#8217; toolset. Configure the Output Format to Excel as seen here:<\/p>\n<p><a href=\"https:\/\/forums.adobe.com\/servlet\/JiveServlet\/showImage\/2-5009627-283983\/Screen+shot+2013-01-21+at+12.06.11+AM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"jive-image\" src=\"https:\/\/forums.adobe.com\/servlet\/JiveServlet\/downloadImage\/2-5009627-283983\/Screen+shot+2013-01-21+at+12.06.11+AM.png\" alt=\"Screen shot 2013-01-21 at 12.06.11 AM.png\" width=\"363\" height=\"381\" \/><\/a><\/p>\n<\/div>\n<\/section>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>You can use an Action in Adobe Acrobat Pro to convert your PDF files to Excel in one operation. To do that, create a new&hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-758","post","type-post","status-publish","format-standard","hentry","category-notepad"],"_links":{"self":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/posts\/758","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/comments?post=758"}],"version-history":[{"count":0,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/posts\/758\/revisions"}],"wp:attachment":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/media?parent=758"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/categories?post=758"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/tags?post=758"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}