{"id":7898,"date":"2018-02-12T17:12:57","date_gmt":"2018-02-12T17:12:57","guid":{"rendered":"https:\/\/www.investintech.com\/resources\/blog\/?p=7898"},"modified":"2021-12-24T15:50:38","modified_gmt":"2021-12-24T15:50:38","slug":"convert-pdf-excel-formatting-issues","status":"publish","type":"post","link":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html","title":{"rendered":"How to Convert PDF to Excel: Formatting Issues Solved"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7899 size-large\" src=\"\/resources\/blog\/wp-content\/uploads\/2021\/06\/pdf-to-excel-fixing-formatting-issues.jpg\" alt=\"Custom Formatting PDF to Excel \" width=\"1024\" height=\"536\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Accurate <\/span><span style=\"font-weight: 400;\">PDF to Excel<\/span><span style=\"font-weight: 400;\"> conversion is one of the most difficult tasks for any <a href=\"https:\/\/www.investintech.com\/\">PDF converter<\/a> software. That\u2019s why users often complain that PDF won\u2019t convert correctly to Excel. They think the software is not working properly because they experience formatting issues when converting PDF to Excel.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Online communities are a valuable source of knowledge and a helpful resource when it comes to solving all kinds of computer related problems. Nevertheless, it seems they fall short when questions like these arise:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to convert PDF to Excel without losing formatting?<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to retain formatting when converting PDF to Excel?<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to keep columns and rows when converting PDF to Excel?<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to get values in the correct cells when converting PDF to Excel?<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">How to convert PDF to Excel and get rows and columns to be useful?<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Why is that so? Well, there\u2019s a misconception that all PDF converters work the same way thus giving similar end results when it comes to PDF to Excel conversion.<\/span><\/p>\n<p><!--more--><\/p>\n<h2><span style=\"font-weight: 400;\">Why PDF Won\u2019t Convert to Excel Correctly? \u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">But before we answer all of the questions above, let\u2019s try to understand why so many users are unsatisfied with tables extracted from PDFs.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Portable Document Format files are not like word processing or spreadsheet files, meaning they don\u2019t contain formatting, rows, and columns. In order for the regular PDF to Excel conversion to give accurate results, the PDF file (and any table inside it) needs to be tagged.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Since dealing with a <\/span><a href=\"https:\/\/taggedpdf.com\/what-is-a-tagged-pdf\/\" target=\"_blank\" rel=\"nofollow\"><span style=\"font-weight: 400;\">tagged PDF<\/span><\/a><span style=\"font-weight: 400;\"> is such a rare case that you\u2019ll<\/span> <span style=\"font-weight: 400;\">encounter, the <\/span><span style=\"font-weight: 400;\">most common practice <\/span><span style=\"font-weight: 400;\">is to simply accept the fact that the quality of your conversion results will be poor and to manually clean up the content using the spreadsheet application of your choice afterward.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Fortunately, there\u2019s a better way to go about PDF to Excel conversion formatting problems. Follow along as we explain how to get accurate results and extract tables that will be useful from the get-go by using Able2Extract Professional &#8211; PDF to Excel converter software recommended by professionals from various industries dealing with a massive amount of spreadsheet data locked inside PDFs.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">How to Use Custom Excel Panel in Able2Extract<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">With <\/span><b>Custom PDF to Excel<\/b><span style=\"font-weight: 400;\"> advanced options in Able2Extract Professional, <\/span><span style=\"font-weight: 400;\">you<\/span><span style=\"font-weight: 400;\"> can change up the <\/span><span style=\"font-weight: 400;\">table <\/span><span style=\"font-weight: 400;\">selection, set up table structure, manually edit rows and columns, and preview the end result prior to the conversion. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">These features help you create a tailored conversion layout so you can get the tables and data you need perfectly formatted and set up for your spreadsheet before you even convert the PDF content. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">In the following example<\/span><span style=\"font-weight: 400;\">,<\/span><span style=\"font-weight: 400;\"> we\u2019ll demonstrate how to use the <\/span><b>Custom Excel feature<\/b><span style=\"font-weight: 400;\"> in order to change the layout created automatically by the program.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Notice that the PDF page in this example has two tables surrounded by text.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9912 size-full\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/page.png\" alt=\"PDF page with tables surrounded by text\" width=\"638\" height=\"828\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/page.png 638w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/page-231x300.png 231w\" sizes=\"auto, (max-width: 638px) 100vw, 638px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Performing a regular <\/span><span style=\"font-weight: 400;\"><a href=\"https:\/\/www.investintech.com\/pdf-to-excel\/\">PDF to Excel<\/a> conversion will result in a spreadsheet that needs a lot of follow-up work in order to be useful. Just take a look at the results seen in this image below:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9913 size-large\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/automatic-conversion-1024x673.png\" alt=\"Automatic PDF to Excel conversion resulting spreadsheet\" width=\"1024\" height=\"673\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/automatic-conversion-1024x673.png 1024w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/automatic-conversion-300x197.png 300w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/automatic-conversion-768x505.png 768w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/automatic-conversion.png 1062w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">To analyze the data, you\u2019d need to delete a large part of the text in order for your functions and formulas to work properly. Moreover, you may need a specific portion of that extra text alongside the tables. For instance, what if you want to convert just the first table with <\/span><span style=\"font-weight: 400;\">the <\/span><span style=\"font-weight: 400;\">comment below?<\/span><\/p>\n<p><span style=\"font-weight: 400;\">A solution is to use the feature that differentiate<\/span><span style=\"font-weight: 400;\">s<\/span><span style=\"font-weight: 400;\"> Able2Extract from all other PDF converter tools &#8211; Custom PDF to Excel. <\/span><\/p>\n<h2><span style=\"font-weight: 400;\">Tutorial<\/span><\/h2>\n<ol>\n<li><span style=\"font-weight: 400;\">Click on the<strong> Custom<\/strong> <\/span><b>Excel<\/b><span style=\"font-weight: 400;\"> tab in the Command toolbar.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click on the <\/span><b>Add Table<\/b><span style=\"font-weight: 400;\"> icon under the Custom Excel tab.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>Draw a selection rectangle<\/strong> around the table you&#8217;d like to convert.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Under the Custom Excel tab and on the right-hand side of the Able2Extract interface, you\u2019ll see<\/span><span style=\"font-weight: 400;\"> the<\/span><span style=\"font-weight: 400;\"> Custom Excel advanced options to customize PDF to Excel conversion.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9915 size-full\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/custom-excel-1.png\" alt=\"Custom Excel advanced options\" width=\"1024\" height=\"823\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/custom-excel-1.png 1024w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/custom-excel-1-300x241.png 300w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/custom-excel-1-768x617.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Check <\/span><b>Show Rows<\/b><span style=\"font-weight: 400;\"> and <\/span><b>Manual Row Editing<\/b><span style=\"font-weight: 400;\"> boxes and you\u2019ll be able to add column and row lines, reposition, or erase them. To see what the final output will look like, check the <\/span><b>Show Preview<\/b><span style=\"font-weight: 400;\"> box at the bottom.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Let\u2019s see how the table layout for the conversion looked like before the manual customization:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9916 size-large\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/define-automatic-1024x281.png\" alt=\"Automatic PDF to Excel table selection\" width=\"1024\" height=\"281\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/define-automatic-1024x281.png 1024w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/define-automatic-300x82.png 300w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/define-automatic-768x211.png 768w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/define-automatic.png 1104w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">As you can see above, there are a lot of unnecessary row lines and poorly placed column lines, as well as the graph on the right included into a table structure, <\/span><span style=\"font-weight: 400;\">that will affect<\/span> <span style=\"font-weight: 400;\">the <\/span><span style=\"font-weight: 400;\">output result.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Here\u2019s how the table layout looks like after being manually customized:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9917 size-large\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/define-manual-1024x283.png\" alt=\"Custom Excel advanced table selection\" width=\"1024\" height=\"283\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/define-manual-1024x283.png 1024w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/define-manual-300x83.png 300w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/define-manual-768x212.png 768w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/define-manual.png 1110w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">What if you want to convert the second table on the page as well? <\/span><\/p>\n<p><span style=\"font-weight: 400;\">No problem &#8211; just click on the <\/span><b>Add<\/b><span style=\"font-weight: 400;\"><strong> Table<\/strong> button under the <\/span><b>Custom Excel tab<\/b><span style=\"font-weight: 400;\"> and draw a rectangle around the second table. After that, you can further customize the layout.<\/span><\/p>\n<p><b>Bonus tip<\/b><span style=\"font-weight: 400;\">: Learn how to use <\/span><a href=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/6482-pdf-conversion-custom-excel-templates.html\"><span style=\"font-weight: 400;\">Custom Excel Templates<\/span><\/a><span style=\"font-weight: 400;\"> to further speed up <\/span><span style=\"font-weight: 400;\">your <\/span><span style=\"font-weight: 400;\">PDF to Excel conversion.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">When you\u2019re satisfied with the selection and the layout for your Custom PDF to Excel conversion, click on the <\/span><b>Convert<\/b><span style=\"font-weight: 400;\"><strong> To Excel<\/strong> button in the toolbar (under the Custom Excel tab).<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Check out the final result with both PDF tables converted to Excel:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9921 size-full\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/final-output-custom-excel.png\" alt=\"Custom Excel resulting spreadsheet\" width=\"751\" height=\"712\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/final-output-custom-excel.png 751w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/final-output-custom-excel-300x284.png 300w\" sizes=\"auto, (max-width: 751px) 100vw, 751px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">As shown in this example, PDF to Excel conversion results don\u2019t need to be hampered with formatting issues if you have the right PDF converter software at your disposal.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Invest your efforts in mastering all the advanced options available in <\/span><strong><a href=\"https:\/\/www.investintech.com\/prod_a2e.htm\">Able2Extract Professional <\/a><\/strong><span style=\"font-weight: 400;\"><strong>Custom Excel<\/strong> feature and you\u2019ll save hours of your precious time for tasks that are far more important than cleaning up <\/span><span style=\"font-weight: 400;\">the<\/span><span style=\"font-weight: 400;\"> output spreadsheet layout in Excel.<\/span><\/p>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Accurate PDF to Excel conversion is one of the most difficult tasks for any PDF converter software. That\u2019s why users often complain that PDF won\u2019t convert correctly to Excel. They think the software is not working properly because they experience formatting issues when converting PDF to Excel. Online communities are a valuable source of knowledge &#8230; <a title=\"How to Convert PDF to Excel: Formatting Issues Solved\" class=\"read-more\" href=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html\" aria-label=\"More on How to Convert PDF to Excel: Formatting Issues Solved\">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,332],"tags":[50,45,135,85,39,122],"class_list":["post-7898","post","type-post","status-publish","format-standard","hentry","category-2-conversion","category-tech-tips-tutorials","tag-able2extract","tag-ms-excel","tag-pdf-conversion","tag-pdf-to-excel","tag-productivity","tag-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Convert PDF to Excel: Formatting Issues Solved<\/title>\n<meta name=\"description\" content=\"Learn how you can manually edit rows and columns with Able2Extract Pro 12 PDF to Excel advanced conversion options to get the desired results.\" \/>\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\/7898-convert-pdf-excel-formatting-issues.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Convert PDF to Excel: Formatting Issues Solved\" \/>\n<meta property=\"og:description\" content=\"Learn how you can manually edit rows and columns with Able2Extract Pro 12 PDF to Excel advanced conversion options to get the desired results.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html\" \/>\n<meta property=\"og:site_name\" content=\"PDF Blog | Investintech PDF Solutions\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-12T17:12:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-24T15:50:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/page.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\/7898-convert-pdf-excel-formatting-issues.html#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html\"},\"author\":{\"name\":\"goranka\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/b62f30e5e357f36e69ff2b5f1ba865a1\"},\"headline\":\"How to Convert PDF to Excel: Formatting Issues Solved\",\"datePublished\":\"2018-02-12T17:12:57+00:00\",\"dateModified\":\"2021-12-24T15:50:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html\"},\"wordCount\":948,\"publisher\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/page.png\",\"keywords\":[\"Able2Extract\",\"MS Excel\",\"PDF conversion\",\"PDF to Excel\",\"productivity\",\"tutorial\"],\"articleSection\":[\"Conversion\",\"Tech Tips and Tutorials\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html\",\"name\":\"How to Convert PDF to Excel: Formatting Issues Solved\",\"isPartOf\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/page.png\",\"datePublished\":\"2018-02-12T17:12:57+00:00\",\"dateModified\":\"2021-12-24T15:50:38+00:00\",\"description\":\"Learn how you can manually edit rows and columns with Able2Extract Pro 12 PDF to Excel advanced conversion options to get the desired results.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html#primaryimage\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/page.png\",\"contentUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/page.png\",\"width\":638,\"height\":828,\"caption\":\"PDF page with tables surrounded by text\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.investintech.com\/resources\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Convert PDF to Excel: Formatting Issues Solved\"}]},{\"@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 Convert PDF to Excel: Formatting Issues Solved","description":"Learn how you can manually edit rows and columns with Able2Extract Pro 12 PDF to Excel advanced conversion options to get the desired results.","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\/7898-convert-pdf-excel-formatting-issues.html","og_locale":"en_US","og_type":"article","og_title":"How to Convert PDF to Excel: Formatting Issues Solved","og_description":"Learn how you can manually edit rows and columns with Able2Extract Pro 12 PDF to Excel advanced conversion options to get the desired results.","og_url":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html","og_site_name":"PDF Blog | Investintech PDF Solutions","article_published_time":"2018-02-12T17:12:57+00:00","article_modified_time":"2021-12-24T15:50:38+00:00","og_image":[{"url":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/page.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\/7898-convert-pdf-excel-formatting-issues.html#article","isPartOf":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html"},"author":{"name":"goranka","@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/b62f30e5e357f36e69ff2b5f1ba865a1"},"headline":"How to Convert PDF to Excel: Formatting Issues Solved","datePublished":"2018-02-12T17:12:57+00:00","dateModified":"2021-12-24T15:50:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html"},"wordCount":948,"publisher":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#organization"},"image":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html#primaryimage"},"thumbnailUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/page.png","keywords":["Able2Extract","MS Excel","PDF conversion","PDF to Excel","productivity","tutorial"],"articleSection":["Conversion","Tech Tips and Tutorials"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html","url":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html","name":"How to Convert PDF to Excel: Formatting Issues Solved","isPartOf":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html#primaryimage"},"image":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html#primaryimage"},"thumbnailUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/page.png","datePublished":"2018-02-12T17:12:57+00:00","dateModified":"2021-12-24T15:50:38+00:00","description":"Learn how you can manually edit rows and columns with Able2Extract Pro 12 PDF to Excel advanced conversion options to get the desired results.","breadcrumb":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html#primaryimage","url":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/page.png","contentUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/02\/page.png","width":638,"height":828,"caption":"PDF page with tables surrounded by text"},{"@type":"BreadcrumbList","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.investintech.com\/resources\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Convert PDF to Excel: Formatting Issues Solved"}]},{"@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\/7898","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=7898"}],"version-history":[{"count":14,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/7898\/revisions"}],"predecessor-version":[{"id":10418,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/7898\/revisions\/10418"}],"wp:attachment":[{"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/media?parent=7898"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/categories?post=7898"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/tags?post=7898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}