{"id":106,"date":"2009-09-02T15:52:00","date_gmt":"2009-09-02T15:52:00","guid":{"rendered":"https:\/\/zofxare.com\/zofxare\/blog\/2009\/09\/02\/how-to-copy-pdf-table-to-excel\/"},"modified":"2009-09-02T15:52:00","modified_gmt":"2009-09-02T15:52:00","slug":"how-to-copy-pdf-table-to-excel","status":"publish","type":"post","link":"https:\/\/zofxare.com\/zofxare\/blog\/2009\/09\/02\/how-to-copy-pdf-table-to-excel\/","title":{"rendered":"How to Copy PDF Table to Excel"},"content":{"rendered":"<p>I have a pdf file with a bunch of tables that I need to grab the content of and paste into an excel spreadsheet. One way to do this is to upgrade to Adobe Acrobat Professional and use the copy as table command. Who wants, or is able, to pay $450 for that though? Certainly not me.<br \/>\nAdobe Reader is free and came installed on my computer, so I was poking around a bit and discovered a work around. In Adobe Reader 7.0, first make sure the select tool is chosen. Next, move the cursor over the column header until a rectangle appears. Then highlight the column elements and press Ctrl+C to copy the column elements, paste into Excel with Ctrl+V.<br \/>\nIf you are using Adobe Reader 9.0, press Ctrl+Alt while moving the cursor over the column header until a rectangle appears. Then highlight the column elements and press Ctrl+C to copy the column elements, paste into Excel with Ctrl+V.<br \/>\nCopying each column one at a time isn&#8217;t quite as nice as the copy as table command. It takes a little bit more time, but it is definitely better than spending a couple hundred dollars if you really don&#8217;t need to.<\/p>\n<p>\n<a target=\"_blank\" href=\"http:\/\/www.amazon.com\/s\/ref=as_li_ss_tl?_encoding=UTF8&amp;camp=1789&amp;creative=390957&amp;field-keywords=Adobe%20Acrobat&amp;linkCode=ur2&amp;rh=i%3Aaps%2Ck%3AAdobe%20Acrobat&amp;tag=zofxare-20&amp;url=search-alias%3Daps&amp;linkId=4JXKNPSCP2FU5CN5\" rel=\"noopener\">More Adobe Acrobat<\/a><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ir-na.amazon-adsystem.com\/e\/ir?t=zofxare-20&amp;l=ur2&amp;o=1\" width=\"1\" height=\"1\" border=\"0\" alt=\"\" style=\"border:none !important; margin:0px !important;\" \/><\/p>\n<p><iframe style=\"width:120px;height:240px;\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" frameborder=\"0\" src=\"\/\/ws-na.amazon-adsystem.com\/widgets\/q?ServiceVersion=20070822&#038;OneJS=1&#038;Operation=GetAdHtml&#038;MarketPlace=US&#038;source=ac&#038;ref=tf_til&#038;ad_type=product_link&#038;tracking_id=zofxare-20&#038;marketplace=amazon&#038;region=US&#038;placement=0071752935&#038;asins=0071752935&#038;linkId=VEUXGTBWZDORBSVX&#038;show_border=true&#038;link_opens_in_new_window=true\"><br \/>\n<\/iframe><iframe style=\"width:120px;height:240px;\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" frameborder=\"0\" src=\"\/\/ws-na.amazon-adsystem.com\/widgets\/q?ServiceVersion=20070822&#038;OneJS=1&#038;Operation=GetAdHtml&#038;MarketPlace=US&#038;source=ac&#038;ref=tf_til&#038;ad_type=product_link&#038;tracking_id=zofxare-20&#038;marketplace=amazon&#038;region=US&#038;placement=0596006551&#038;asins=0596006551&#038;linkId=37Z3EY4NXYRAL4ER&#038;show_border=true&#038;link_opens_in_new_window=true\"><br \/>\n<\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have a pdf file with a bunch of tables that I need to grab the content of and paste into an excel spreadsheet. One way to do this is to upgrade to Adobe Acrobat Professional and use the copy as table command. Who wants, or is able, to pay $450 for that though? Certainly [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","om_disable_all_campaigns":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[228,225,229,227,226],"tags":[],"class_list":["post-106","post","type-post","status-publish","format-standard","hentry","category-adobe-acrobat-professional","category-adobe-acrobat-reader","category-how-to-copy-pdf-table-to-excel","category-microsoft-excel","category-spreadsheet"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Copy PDF Table to Excel - Zofxare Blog Home<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/zofxare.com\/zofxare\/blog\/2009\/09\/02\/how-to-copy-pdf-table-to-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Copy PDF Table to Excel - Zofxare Blog Home\" \/>\n<meta property=\"og:description\" content=\"I have a pdf file with a bunch of tables that I need to grab the content of and paste into an excel spreadsheet. One way to do this is to upgrade to Adobe Acrobat Professional and use the copy as table command. Who wants, or is able, to pay $450 for that though? Certainly [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/zofxare.com\/zofxare\/blog\/2009\/09\/02\/how-to-copy-pdf-table-to-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Zofxare Blog Home\" \/>\n<meta property=\"article:published_time\" content=\"2009-09-02T15:52:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ir-na.amazon-adsystem.com\/e\/ir?t=zofxare-20&amp;l=ur2&amp;o=1\" \/>\n<meta name=\"author\" content=\"zofxare\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"zofxare\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/2009\\\/09\\\/02\\\/how-to-copy-pdf-table-to-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/2009\\\/09\\\/02\\\/how-to-copy-pdf-table-to-excel\\\/\"},\"author\":{\"name\":\"zofxare\",\"@id\":\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/#\\\/schema\\\/person\\\/094f5dde70100b9f8fbc63174a2a40ce\"},\"headline\":\"How to Copy PDF Table to Excel\",\"datePublished\":\"2009-09-02T15:52:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/2009\\\/09\\\/02\\\/how-to-copy-pdf-table-to-excel\\\/\"},\"wordCount\":215,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/2009\\\/09\\\/02\\\/how-to-copy-pdf-table-to-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ir-na.amazon-adsystem.com\\\/e\\\/ir?t=zofxare-20&amp;l=ur2&amp;o=1\",\"articleSection\":[\"Adobe Acrobat Professional\",\"Adobe Acrobat Reader\",\"How to Copy PDF Table to Excel\",\"Microsoft Excel\",\"spreadsheet\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/2009\\\/09\\\/02\\\/how-to-copy-pdf-table-to-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/2009\\\/09\\\/02\\\/how-to-copy-pdf-table-to-excel\\\/\",\"url\":\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/2009\\\/09\\\/02\\\/how-to-copy-pdf-table-to-excel\\\/\",\"name\":\"How to Copy PDF Table to Excel - Zofxare Blog Home\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/2009\\\/09\\\/02\\\/how-to-copy-pdf-table-to-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/2009\\\/09\\\/02\\\/how-to-copy-pdf-table-to-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ir-na.amazon-adsystem.com\\\/e\\\/ir?t=zofxare-20&amp;l=ur2&amp;o=1\",\"datePublished\":\"2009-09-02T15:52:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/#\\\/schema\\\/person\\\/094f5dde70100b9f8fbc63174a2a40ce\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/2009\\\/09\\\/02\\\/how-to-copy-pdf-table-to-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/2009\\\/09\\\/02\\\/how-to-copy-pdf-table-to-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/2009\\\/09\\\/02\\\/how-to-copy-pdf-table-to-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/ir-na.amazon-adsystem.com\\\/e\\\/ir?t=zofxare-20&amp;l=ur2&amp;o=1\",\"contentUrl\":\"https:\\\/\\\/ir-na.amazon-adsystem.com\\\/e\\\/ir?t=zofxare-20&amp;l=ur2&amp;o=1\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/2009\\\/09\\\/02\\\/how-to-copy-pdf-table-to-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Copy PDF Table to Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/\",\"name\":\"Zofxare Blog Home\",\"description\":\"The Zofxare blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/#\\\/schema\\\/person\\\/094f5dde70100b9f8fbc63174a2a40ce\",\"name\":\"zofxare\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=retro&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=retro&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=retro&r=g\",\"caption\":\"zofxare\"},\"url\":\"https:\\\/\\\/zofxare.com\\\/zofxare\\\/blog\\\/author\\\/zofxare\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Copy PDF Table to Excel - Zofxare Blog Home","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zofxare.com\/zofxare\/blog\/2009\/09\/02\/how-to-copy-pdf-table-to-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to Copy PDF Table to Excel - Zofxare Blog Home","og_description":"I have a pdf file with a bunch of tables that I need to grab the content of and paste into an excel spreadsheet. One way to do this is to upgrade to Adobe Acrobat Professional and use the copy as table command. Who wants, or is able, to pay $450 for that though? Certainly [&hellip;]","og_url":"https:\/\/zofxare.com\/zofxare\/blog\/2009\/09\/02\/how-to-copy-pdf-table-to-excel\/","og_site_name":"Zofxare Blog Home","article_published_time":"2009-09-02T15:52:00+00:00","og_image":[{"url":"https:\/\/ir-na.amazon-adsystem.com\/e\/ir?t=zofxare-20&amp;l=ur2&amp;o=1","type":"","width":"","height":""}],"author":"zofxare","twitter_card":"summary_large_image","twitter_misc":{"Written by":"zofxare","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/zofxare.com\/zofxare\/blog\/2009\/09\/02\/how-to-copy-pdf-table-to-excel\/#article","isPartOf":{"@id":"https:\/\/zofxare.com\/zofxare\/blog\/2009\/09\/02\/how-to-copy-pdf-table-to-excel\/"},"author":{"name":"zofxare","@id":"https:\/\/zofxare.com\/zofxare\/blog\/#\/schema\/person\/094f5dde70100b9f8fbc63174a2a40ce"},"headline":"How to Copy PDF Table to Excel","datePublished":"2009-09-02T15:52:00+00:00","mainEntityOfPage":{"@id":"https:\/\/zofxare.com\/zofxare\/blog\/2009\/09\/02\/how-to-copy-pdf-table-to-excel\/"},"wordCount":215,"commentCount":0,"image":{"@id":"https:\/\/zofxare.com\/zofxare\/blog\/2009\/09\/02\/how-to-copy-pdf-table-to-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/ir-na.amazon-adsystem.com\/e\/ir?t=zofxare-20&amp;l=ur2&amp;o=1","articleSection":["Adobe Acrobat Professional","Adobe Acrobat Reader","How to Copy PDF Table to Excel","Microsoft Excel","spreadsheet"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/zofxare.com\/zofxare\/blog\/2009\/09\/02\/how-to-copy-pdf-table-to-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/zofxare.com\/zofxare\/blog\/2009\/09\/02\/how-to-copy-pdf-table-to-excel\/","url":"https:\/\/zofxare.com\/zofxare\/blog\/2009\/09\/02\/how-to-copy-pdf-table-to-excel\/","name":"How to Copy PDF Table to Excel - Zofxare Blog Home","isPartOf":{"@id":"https:\/\/zofxare.com\/zofxare\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zofxare.com\/zofxare\/blog\/2009\/09\/02\/how-to-copy-pdf-table-to-excel\/#primaryimage"},"image":{"@id":"https:\/\/zofxare.com\/zofxare\/blog\/2009\/09\/02\/how-to-copy-pdf-table-to-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/ir-na.amazon-adsystem.com\/e\/ir?t=zofxare-20&amp;l=ur2&amp;o=1","datePublished":"2009-09-02T15:52:00+00:00","author":{"@id":"https:\/\/zofxare.com\/zofxare\/blog\/#\/schema\/person\/094f5dde70100b9f8fbc63174a2a40ce"},"breadcrumb":{"@id":"https:\/\/zofxare.com\/zofxare\/blog\/2009\/09\/02\/how-to-copy-pdf-table-to-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zofxare.com\/zofxare\/blog\/2009\/09\/02\/how-to-copy-pdf-table-to-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zofxare.com\/zofxare\/blog\/2009\/09\/02\/how-to-copy-pdf-table-to-excel\/#primaryimage","url":"https:\/\/ir-na.amazon-adsystem.com\/e\/ir?t=zofxare-20&amp;l=ur2&amp;o=1","contentUrl":"https:\/\/ir-na.amazon-adsystem.com\/e\/ir?t=zofxare-20&amp;l=ur2&amp;o=1"},{"@type":"BreadcrumbList","@id":"https:\/\/zofxare.com\/zofxare\/blog\/2009\/09\/02\/how-to-copy-pdf-table-to-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zofxare.com\/zofxare\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Copy PDF Table to Excel"}]},{"@type":"WebSite","@id":"https:\/\/zofxare.com\/zofxare\/blog\/#website","url":"https:\/\/zofxare.com\/zofxare\/blog\/","name":"Zofxare Blog Home","description":"The Zofxare blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zofxare.com\/zofxare\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zofxare.com\/zofxare\/blog\/#\/schema\/person\/094f5dde70100b9f8fbc63174a2a40ce","name":"zofxare","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=retro&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=retro&r=g","caption":"zofxare"},"url":"https:\/\/zofxare.com\/zofxare\/blog\/author\/zofxare\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/zofxare.com\/zofxare\/blog\/wp-json\/wp\/v2\/posts\/106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zofxare.com\/zofxare\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zofxare.com\/zofxare\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zofxare.com\/zofxare\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/zofxare.com\/zofxare\/blog\/wp-json\/wp\/v2\/comments?post=106"}],"version-history":[{"count":0,"href":"https:\/\/zofxare.com\/zofxare\/blog\/wp-json\/wp\/v2\/posts\/106\/revisions"}],"wp:attachment":[{"href":"https:\/\/zofxare.com\/zofxare\/blog\/wp-json\/wp\/v2\/media?parent=106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zofxare.com\/zofxare\/blog\/wp-json\/wp\/v2\/categories?post=106"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zofxare.com\/zofxare\/blog\/wp-json\/wp\/v2\/tags?post=106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}