{"id":8115,"date":"2018-05-14T15:32:54","date_gmt":"2018-05-14T15:32:54","guid":{"rendered":"https:\/\/www.investintech.com\/resources\/blog\/?p=8115"},"modified":"2021-12-24T15:53:54","modified_gmt":"2021-12-24T15:53:54","slug":"pdf-tables-excel-exclude-text","status":"publish","type":"post","link":"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html","title":{"rendered":"PDF to Excel: How to Exclude Text Surrounding Tables"},"content":{"rendered":"<p><a href=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/PDF-Tables-Excel-Exclude-Text.jpeg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8116 size-large\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/PDF-Tables-Excel-Exclude-Text-1024x536.jpeg\" alt=\"Person doing spreadsheet analysis\" width=\"640\" height=\"335\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/PDF-Tables-Excel-Exclude-Text-1024x536.jpeg 1024w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/PDF-Tables-Excel-Exclude-Text-300x157.jpeg 300w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/PDF-Tables-Excel-Exclude-Text-768x402.jpeg 768w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/PDF-Tables-Excel-Exclude-Text.jpeg 1200w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">Despite <\/span><span style=\"font-weight: 400;\">the <\/span><span style=\"font-weight: 400;\">many advantages of Portable Document Format, users find PDFs inconvenient for reusing the embedded content. To accurately convert <\/span><span style=\"font-weight: 400;\">PDF to Excel<\/span><span style=\"font-weight: 400;\">, and more specifically &#8211; just PDF tables surrounded by text and other types of content &#8211; <\/span><span style=\"font-weight: 400;\">you <\/span><span style=\"font-weight: 400;\">need a professional PDF tool such as Able2Extract.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Excel is probably the best known and most used spreadsheet software in the world. It\u2019s an essential productivity tool that automates many tasks when it comes to analyzing large quantit<\/span><span style=\"font-weight: 400;\">ies<\/span><span style=\"font-weight: 400;\"> of numeric data.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Performing <\/span><a href=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/5916-excel-tips-for-data-analysts.html\"><span style=\"font-weight: 400;\">data analysis in Excel<\/span><\/a><span style=\"font-weight: 400;\"> tables is the best way to decipher the information relevant to your personal and business goals that are usually hidden behind the numbers. Nevertheless, presenting those conclusions in an easy-to-comprehend and meaningful way requires textual explanations, graphs, and other various types of content. The end result of an analysis is a properly structured document containing titles and subtitles, text, images, graphs, tables, etc.<\/span><!--more--><\/p>\n<p><span style=\"font-weight: 400;\">The<\/span><span style=\"font-weight: 400;\"> Portable Document Format (PDF) is the first choice for exporting such reports because of its abilities to:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">secure and password protect data from unauthorized copying and printing<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">display content on any device and platform in the way it was intended by the creator<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">maintain document layout for consistent printing output<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">If you want to get the best out of both worlds and not worry about your PDF data being locked down from further processing, <\/span><span style=\"font-weight: 400;\">Able2Extract Pro 12<\/span><span style=\"font-weight: 400;\"> is the tool you need to have in your productivity arsenal. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">Even though <\/span><span style=\"font-weight: 400;\">its <\/span><span style=\"font-weight: 400;\"><a href=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html\">Custom PDF to Excel<\/a> feature is packed with customization options for achieving the most accurate and personalized conversion results, <\/span><span style=\"font-weight: 400;\">the<\/span><span style=\"font-weight: 400;\"> Automatic PDF to Excel feature also has some useful, time-saving tricks up its sleeve. Let&#8217;s discover one of them together.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Here\u2019s how to exclude text surrounding tables using a settings tweak in <\/span><span style=\"font-weight: 400;\">the <\/span><span style=\"font-weight: 400;\">Automatic PDF to Excel feature.<\/span><\/p>\n<h2><strong>Tutorial<\/strong><\/h2>\n<p><span style=\"font-weight: 400;\">For this tutorial, we\u2019ll use a PDF example with two tables<\/span><span style=\"font-weight: 400;\"> surrounded by<\/span><span style=\"font-weight: 400;\"> text before, after, and in between:<\/span><\/p>\n<p><a href=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/PDF-Excel-Tables-Example.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8117 size-full\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/PDF-Excel-Tables-Example.png\" alt=\"Sample PDF with two tables surrounded by text\" width=\"649\" height=\"842\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/PDF-Excel-Tables-Example.png 649w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/PDF-Excel-Tables-Example-231x300.png 231w\" sizes=\"auto, (max-width: 649px) 100vw, 649px\" \/><\/a><\/p>\n<p><b>Step 1:<\/b><span style=\"font-weight: 400;\"> Open the PDF by clicking on the <\/span><b>Open<\/b><span style=\"font-weight: 400;\"> button in the Command toolbar and choose the file.<\/span><\/p>\n<p><b>Step 2:<\/b><span style=\"font-weight: 400;\"> Click on the<\/span><b> All<\/b><span style=\"font-weight: 400;\"> button under <\/span>the<b> Select section<\/b><span style=\"font-weight: 400;\"> of the Command toolbar to select the whole document. If you would like to convert just a part of the document, click on the <\/span><b>Area<\/b><span style=\"font-weight: 400;\"> button and click and drag over the content to make the desired selection.<\/span><\/p>\n<p><a href=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/Open-Select-Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8118 size-full\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/Open-Select-Excel.png\" alt=\"Able2Extract's PDF to Excel conversion guide\" width=\"702\" height=\"535\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/Open-Select-Excel.png 702w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/Open-Select-Excel-300x229.png 300w\" sizes=\"auto, (max-width: 702px) 100vw, 702px\" \/><\/a><\/p>\n<p><b>Step 3:<\/b><span style=\"font-weight: 400;\"> Click on the <\/span><b>Excel<\/b><span style=\"font-weight: 400;\"> button under <\/span><b>Convert to File Type<\/b><span style=\"font-weight: 400;\"> section of the Command toolbar. In the bottom left corner of the <\/span><b>Convert to Excel<\/b><span style=\"font-weight: 400;\"> dialog click on the <\/span><b>gear icon<\/b><span style=\"font-weight: 400;\"> and you\u2019ll be presented with the <\/span><b>Settings<\/b><span style=\"font-weight: 400;\"> dialog window.<\/span><\/p>\n<p><b>Step 4:<\/b><span style=\"font-weight: 400;\"> In the Settings dialog, check the <\/span><b>Extract Tables Only<\/b><span style=\"font-weight: 400;\"> box and click <\/span><b>OK<\/b><span style=\"font-weight: 400;\"> to confirm changes.<\/span><\/p>\n<p><b>Step 5:<\/b><span style=\"font-weight: 400;\"> You\u2019ll be taken back to the Convert to Excel dialog. Finally, click on the <\/span><b>Convert <\/b><span style=\"font-weight: 400;\">button under the <\/span><b>Automatic<\/b><span style=\"font-weight: 400;\"> option and wait for the conversion process to complete.<\/span><\/p>\n<p><a href=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/Extract-Tables-Only.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8119 size-full\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/Extract-Tables-Only.png\" alt=\"How to make Able2Extract extract tables only\" width=\"630\" height=\"643\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/Extract-Tables-Only.png 630w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/Extract-Tables-Only-294x300.png 294w\" sizes=\"auto, (max-width: 630px) 100vw, 630px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">After your PDF tables have been extracted to Excel spreadsheet, your new file will open up automatically. Here\u2019s the result:<\/span><\/p>\n<p><a href=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/Excel-Output.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8120 size-large\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/Excel-Output-1024x550.png\" alt=\"Conversion output result in Excel\" width=\"640\" height=\"344\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/Excel-Output-1024x550.png 1024w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/Excel-Output-300x161.png 300w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/Excel-Output-768x412.png 768w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/Excel-Output.png 1073w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">As you can see, the text surrounding the tables is excluded from the output Excel file with just a few clicks thanks to Able2Extract\u2019s powerful <a href=\"https:\/\/www.investintech.com\/pdf-to-excel\/\">PDF to Excel<\/a> engine.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Bottom line: if you receive a lot of PDFs in your line of work and need them in Excel format to analyze <\/span><span style=\"font-weight: 400;\">the <\/span><span style=\"font-weight: 400;\">tabu<\/span><span style=\"font-weight: 400;\">lar<\/span><span style=\"font-weight: 400;\"> data, Able2Extract can easily extract just <\/span><span style=\"font-weight: 400;\">the <\/span><span style=\"font-weight: 400;\">tables from<\/span><span style=\"font-weight: 400;\"> documents that are a thousand pages long <\/span><span style=\"font-weight: 400;\">and simply ignore all the other content.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Download Able2Extract for free <\/span><a href=\"https:\/\/www.investintech.com\/prod_downloadsa2e.htm\"><span style=\"font-weight: 400;\">here<\/span><\/a><span style=\"font-weight: 400;\"> and discover how it can help you in your PDF-related <\/span><span style=\"font-weight: 400;\">task<\/span><span style=\"font-weight: 400;\">s. If you have any suggestions on how we can improve our product even further, don\u2019t hesitate to leave a comment below or contact us directly on Facebook, Twitter, or Google+.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Until next time, have a productive day everyone! \ud83d\ude42<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Despite the many advantages of Portable Document Format, users find PDFs inconvenient for reusing the embedded content. To accurately convert PDF to Excel, and more specifically &#8211; just PDF tables surrounded by text and other types of content &#8211; you need a professional PDF tool such as Able2Extract. Excel is probably the best known and &#8230; <a title=\"PDF to Excel: How to Exclude Text Surrounding Tables\" class=\"read-more\" href=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html\" aria-label=\"More on PDF to Excel: How to Exclude Text Surrounding Tables\">Continue reading \u2192<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,16],"tags":[321,135,85,116,122],"class_list":["post-8115","post","type-post","status-publish","format-standard","hentry","category-2-conversion","category-investintech-tips","tag-data-extraction","tag-pdf-conversion","tag-pdf-to-excel","tag-spreadsheets","tag-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PDF to Excel: How to Exclude Text Surrounding Tables<\/title>\n<meta name=\"description\" content=\"Learn how to convert PDF tables to Excel and exclude text surrounding them. No matter how long or complex your document is, with just a simple tweak in settings Able2Extract will let you isolate PDF tables and accurately extract them for analysis in Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PDF to Excel: How to Exclude Text Surrounding Tables\" \/>\n<meta property=\"og:description\" content=\"Learn how to convert PDF tables to Excel and exclude text surrounding them. No matter how long or complex your document is, with just a simple tweak in settings Able2Extract will let you isolate PDF tables and accurately extract them for analysis in Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html\" \/>\n<meta property=\"og:site_name\" content=\"PDF Blog | Investintech PDF Solutions\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-14T15:32:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-24T15:53:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/PDF-Tables-Excel-Exclude-Text-1024x536.jpeg\" \/>\n<meta name=\"author\" content=\"goranka\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@able2extract\" \/>\n<meta name=\"twitter:site\" content=\"@able2extract\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html\"},\"author\":{\"name\":\"goranka\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/b62f30e5e357f36e69ff2b5f1ba865a1\"},\"headline\":\"PDF to Excel: How to Exclude Text Surrounding Tables\",\"datePublished\":\"2018-05-14T15:32:54+00:00\",\"dateModified\":\"2021-12-24T15:53:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html\"},\"wordCount\":646,\"publisher\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/PDF-Tables-Excel-Exclude-Text-1024x536.jpeg\",\"keywords\":[\"data extraction\",\"PDF conversion\",\"PDF to Excel\",\"spreadsheets\",\"tutorial\"],\"articleSection\":[\"Conversion\",\"Investintech Tips\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html\",\"name\":\"PDF to Excel: How to Exclude Text Surrounding Tables\",\"isPartOf\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/PDF-Tables-Excel-Exclude-Text-1024x536.jpeg\",\"datePublished\":\"2018-05-14T15:32:54+00:00\",\"dateModified\":\"2021-12-24T15:53:54+00:00\",\"description\":\"Learn how to convert PDF tables to Excel and exclude text surrounding them. No matter how long or complex your document is, with just a simple tweak in settings Able2Extract will let you isolate PDF tables and accurately extract them for analysis in Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html#primaryimage\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/PDF-Tables-Excel-Exclude-Text.jpeg\",\"contentUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/PDF-Tables-Excel-Exclude-Text.jpeg\",\"width\":1200,\"height\":628,\"caption\":\"Doing spreadsheet analysis\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.investintech.com\/resources\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PDF to Excel: How to Exclude Text Surrounding Tables\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#website\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/\",\"name\":\"PDF Blog | Investintech PDF Solutions\",\"description\":\"Everything PDF\",\"publisher\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.investintech.com\/resources\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#organization\",\"name\":\"PDF Blog | Investintech PDF Solutions\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2024\/12\/Investintech-apryse-logo-w270.webp\",\"contentUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2024\/12\/Investintech-apryse-logo-w270.webp\",\"width\":270,\"height\":40,\"caption\":\"PDF Blog | Investintech PDF Solutions\"},\"image\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/able2extract\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/b62f30e5e357f36e69ff2b5f1ba865a1\",\"name\":\"goranka\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4c46028f439415c3fd954b54d65ee15b30501cd52b4e9830c1b0413e1b7fde0b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4c46028f439415c3fd954b54d65ee15b30501cd52b4e9830c1b0413e1b7fde0b?s=96&d=mm&r=g\",\"caption\":\"goranka\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PDF to Excel: How to Exclude Text Surrounding Tables","description":"Learn how to convert PDF tables to Excel and exclude text surrounding them. No matter how long or complex your document is, with just a simple tweak in settings Able2Extract will let you isolate PDF tables and accurately extract them for analysis in Excel.","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:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html","og_locale":"en_US","og_type":"article","og_title":"PDF to Excel: How to Exclude Text Surrounding Tables","og_description":"Learn how to convert PDF tables to Excel and exclude text surrounding them. No matter how long or complex your document is, with just a simple tweak in settings Able2Extract will let you isolate PDF tables and accurately extract them for analysis in Excel.","og_url":"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html","og_site_name":"PDF Blog | Investintech PDF Solutions","article_published_time":"2018-05-14T15:32:54+00:00","article_modified_time":"2021-12-24T15:53:54+00:00","og_image":[{"url":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/PDF-Tables-Excel-Exclude-Text-1024x536.jpeg","type":"","width":"","height":""}],"author":"goranka","twitter_card":"summary_large_image","twitter_creator":"@able2extract","twitter_site":"@able2extract","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html#article","isPartOf":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html"},"author":{"name":"goranka","@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/b62f30e5e357f36e69ff2b5f1ba865a1"},"headline":"PDF to Excel: How to Exclude Text Surrounding Tables","datePublished":"2018-05-14T15:32:54+00:00","dateModified":"2021-12-24T15:53:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html"},"wordCount":646,"publisher":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#organization"},"image":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html#primaryimage"},"thumbnailUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/PDF-Tables-Excel-Exclude-Text-1024x536.jpeg","keywords":["data extraction","PDF conversion","PDF to Excel","spreadsheets","tutorial"],"articleSection":["Conversion","Investintech Tips"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html","url":"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html","name":"PDF to Excel: How to Exclude Text Surrounding Tables","isPartOf":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html#primaryimage"},"image":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html#primaryimage"},"thumbnailUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/PDF-Tables-Excel-Exclude-Text-1024x536.jpeg","datePublished":"2018-05-14T15:32:54+00:00","dateModified":"2021-12-24T15:53:54+00:00","description":"Learn how to convert PDF tables to Excel and exclude text surrounding them. No matter how long or complex your document is, with just a simple tweak in settings Able2Extract will let you isolate PDF tables and accurately extract them for analysis in Excel.","breadcrumb":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html#primaryimage","url":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/PDF-Tables-Excel-Exclude-Text.jpeg","contentUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/05\/PDF-Tables-Excel-Exclude-Text.jpeg","width":1200,"height":628,"caption":"Doing spreadsheet analysis"},{"@type":"BreadcrumbList","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/8115-pdf-tables-excel-exclude-text.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.investintech.com\/resources\/blog\/"},{"@type":"ListItem","position":2,"name":"PDF to Excel: How to Exclude Text Surrounding Tables"}]},{"@type":"WebSite","@id":"https:\/\/www.investintech.com\/resources\/blog\/#website","url":"https:\/\/www.investintech.com\/resources\/blog\/","name":"PDF Blog | Investintech PDF Solutions","description":"Everything PDF","publisher":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.investintech.com\/resources\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.investintech.com\/resources\/blog\/#organization","name":"PDF Blog | Investintech PDF Solutions","url":"https:\/\/www.investintech.com\/resources\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2024\/12\/Investintech-apryse-logo-w270.webp","contentUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2024\/12\/Investintech-apryse-logo-w270.webp","width":270,"height":40,"caption":"PDF Blog | Investintech PDF Solutions"},"image":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/able2extract"]},{"@type":"Person","@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/b62f30e5e357f36e69ff2b5f1ba865a1","name":"goranka","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4c46028f439415c3fd954b54d65ee15b30501cd52b4e9830c1b0413e1b7fde0b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4c46028f439415c3fd954b54d65ee15b30501cd52b4e9830c1b0413e1b7fde0b?s=96&d=mm&r=g","caption":"goranka"}}]}},"_links":{"self":[{"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/8115","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/comments?post=8115"}],"version-history":[{"count":6,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/8115\/revisions"}],"predecessor-version":[{"id":10421,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/8115\/revisions\/10421"}],"wp:attachment":[{"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/media?parent=8115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/categories?post=8115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/tags?post=8115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}