{"id":7725,"date":"2017-11-13T16:18:23","date_gmt":"2017-11-13T16:18:23","guid":{"rendered":"https:\/\/www.investintech.com\/resources\/blog\/?p=7725"},"modified":"2018-12-24T11:46:12","modified_gmt":"2018-12-24T11:46:12","slug":"extract-similar-data-from-pdf","status":"publish","type":"post","link":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html","title":{"rendered":"How to Extract Similar Data Fields from PDF Files"},"content":{"rendered":"

\"Extracting<\/p>\n

Every single person that works with PDF files <\/span>has<\/span> probably c<\/span>o<\/span>me across a situation where they needed to extract certain information from PDF to MS Excel. Usually, this extraction process is a walk in the park. However, when you need to extract data that share similar features, the basic <\/span>PDF to Excel<\/span><\/a> conversion won\u2019t cut it.<\/span><\/p>\n

Surely, it will get the job done but still, you will need to manually go through numerous sheets to find the data important to you. And you\u2019ll loop back at the beginning wasting precious time while combing through the pile of numbers.<\/span><\/p>\n

That\u2019s why we decided to introduce you to a timesaving hack that will allow you to stay on top of things while dealing with such tasks. Able2Extract goes beyond the capabilities of a regular PDF tool and enables you to extract only the relevant data fields from a PDF document.<\/span><\/p>\n

This can be quite helpful if you need to work with fields that share some similarities and get a better understanding of the data inside it. For example, you can filter out similar types of information such as people living in the same state or city, people born in the same year or people who donated more than a specific amount of money.<\/span><\/p>\n

Step by Step Extraction<\/span><\/h2>\n

For our example, we will show you how to sift out the contributors that donated more than\u00a0<\/span>$<\/span>1000 in political contributions from the PDF file below. How do we <\/span>zero in and convert<\/span>\u00a0only those <\/span>specific contribution values<\/span>? <\/span><\/p>\n

We are going to use the <\/span>Able2Extract<\/span><\/a> Tables feature to extract only the relevant data, in this case, the ones that donated over one thousand dollars. <\/span><\/p>\n

Step 1<\/span><\/h3>\n

First, we need to open the PDF file in Able2Extract Pro 11 and select the relevant part of the PDF table that contains the necessary information.<\/span><\/p>\n

\"Selecting<\/p>\n

Step 2<\/span><\/h3>\n

After the relevant area is selected we need to opt for the custom Excel conversion as seen below.<\/span><\/p>\n

\"PDF<\/p>\n

Step 3<\/span><\/h3>\n

Now, the main trick is to use the <\/span>Add Tables <\/b>feature from the custom Excel side panel and draw the squares around each of the significant contributors.<\/span><\/p>\n

\"Similar<\/p>\n

After that, we just need to finish the conversion process by clicking on the green <\/span>Convert<\/b> button.<\/span><\/p>\n

The result<\/span><\/h3>\n

\"Data<\/p>\n

Simple as that<\/span>,<\/span> we\u2019ve managed to filter out only the relevant people. This is just one of the neat tricks that Able2Extract has up its sleeves. <\/span><\/p>\n

You can download a <\/span>free trial<\/span><\/a> and save yourself a headache the next time you need to sift through a PDF table that has a specific category you need to analyze.<\/span><\/p>\n

If you’ve found this post useful make sure to follow us on <\/span>Twitter<\/span><\/a>, <\/span>Google+<\/span><\/a> and <\/span>Facebook<\/span><\/a> to get new and cool tech tips every Monday. <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Every single person that works with PDF files has probably come across a situation where they needed to extract certain information from PDF to MS Excel. Usually, this extraction process is a walk in the park. However, when you need to extract data that share similar features, the basic PDF to Excel conversion won\u2019t cut … 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":[1,5,16,332],"tags":[50,45,56,135,39,59,122],"class_list":["post-7725","post","type-post","status-publish","format-standard","hentry","category-1-about","category-2-conversion","category-investintech-tips","category-tech-tips-tutorials","tag-able2extract","tag-ms-excel","tag-pdf","tag-pdf-conversion","tag-productivity","tag-tips","tag-tutorial"],"yoast_head":"\nHow to Extract Similar Data Fields from PDF Files<\/title>\n<meta name=\"description\" content=\"Working with PDF tables can be overwhelming. However, this guide shows you how to extract data fields that share similar features.\" \/>\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\/7725-extract-similar-data-from-pdf.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Extract Similar Data Fields from PDF Files\" \/>\n<meta property=\"og:description\" content=\"Working with PDF tables can be overwhelming. However, this guide shows you how to extract data fields that share similar features.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html\" \/>\n<meta property=\"og:site_name\" content=\"PDF Blog | Investintech PDF Solutions\" \/>\n<meta property=\"article:published_time\" content=\"2017-11-13T16:18:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-24T11:46:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2017\/11\/Extract-similar-PDF-data.png\" \/>\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\/7725-extract-similar-data-from-pdf.html#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html\"},\"author\":{\"name\":\"goranka\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/b62f30e5e357f36e69ff2b5f1ba865a1\"},\"headline\":\"How to Extract Similar Data Fields from PDF Files\",\"datePublished\":\"2017-11-13T16:18:23+00:00\",\"dateModified\":\"2018-12-24T11:46:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html\"},\"wordCount\":470,\"publisher\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2017\/11\/Extract-similar-PDF-data.png\",\"keywords\":[\"Able2Extract\",\"MS Excel\",\"PDF\",\"PDF conversion\",\"productivity\",\"tips\",\"tutorial\"],\"articleSection\":[\"About\",\"Conversion\",\"Investintech Tips\",\"Tech Tips and Tutorials\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html\",\"name\":\"How to Extract Similar Data Fields from PDF Files\",\"isPartOf\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2017\/11\/Extract-similar-PDF-data.png\",\"datePublished\":\"2017-11-13T16:18:23+00:00\",\"dateModified\":\"2018-12-24T11:46:12+00:00\",\"description\":\"Working with PDF tables can be overwhelming. However, this guide shows you how to extract data fields that share similar features.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html#primaryimage\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2017\/11\/Extract-similar-PDF-data.png\",\"contentUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2017\/11\/Extract-similar-PDF-data.png\",\"width\":1920,\"height\":1080,\"caption\":\"Extracting similar PDF data\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.investintech.com\/resources\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Extract Similar Data Fields from PDF Files\"}]},{\"@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":"How to Extract Similar Data Fields from PDF Files","description":"Working with PDF tables can be overwhelming. However, this guide shows you how to extract data fields that share similar features.","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\/7725-extract-similar-data-from-pdf.html","og_locale":"en_US","og_type":"article","og_title":"How to Extract Similar Data Fields from PDF Files","og_description":"Working with PDF tables can be overwhelming. However, this guide shows you how to extract data fields that share similar features.","og_url":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html","og_site_name":"PDF Blog | Investintech PDF Solutions","article_published_time":"2017-11-13T16:18:23+00:00","article_modified_time":"2018-12-24T11:46:12+00:00","og_image":[{"url":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2017\/11\/Extract-similar-PDF-data.png","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\/7725-extract-similar-data-from-pdf.html#article","isPartOf":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html"},"author":{"name":"goranka","@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/b62f30e5e357f36e69ff2b5f1ba865a1"},"headline":"How to Extract Similar Data Fields from PDF Files","datePublished":"2017-11-13T16:18:23+00:00","dateModified":"2018-12-24T11:46:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html"},"wordCount":470,"publisher":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#organization"},"image":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html#primaryimage"},"thumbnailUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2017\/11\/Extract-similar-PDF-data.png","keywords":["Able2Extract","MS Excel","PDF","PDF conversion","productivity","tips","tutorial"],"articleSection":["About","Conversion","Investintech Tips","Tech Tips and Tutorials"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html","url":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html","name":"How to Extract Similar Data Fields from PDF Files","isPartOf":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html#primaryimage"},"image":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html#primaryimage"},"thumbnailUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2017\/11\/Extract-similar-PDF-data.png","datePublished":"2017-11-13T16:18:23+00:00","dateModified":"2018-12-24T11:46:12+00:00","description":"Working with PDF tables can be overwhelming. However, this guide shows you how to extract data fields that share similar features.","breadcrumb":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html#primaryimage","url":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2017\/11\/Extract-similar-PDF-data.png","contentUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2017\/11\/Extract-similar-PDF-data.png","width":1920,"height":1080,"caption":"Extracting similar PDF data"},{"@type":"BreadcrumbList","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7725-extract-similar-data-from-pdf.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.investintech.com\/resources\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Extract Similar Data Fields from PDF Files"}]},{"@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\/7725","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=7725"}],"version-history":[{"count":4,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/7725\/revisions"}],"predecessor-version":[{"id":8489,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/7725\/revisions\/8489"}],"wp:attachment":[{"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/media?parent=7725"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/categories?post=7725"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/tags?post=7725"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}