{"id":7993,"date":"2018-04-02T15:47:38","date_gmt":"2018-04-02T15:47:38","guid":{"rendered":"https:\/\/www.investintech.com\/resources\/blog\/?p=7993"},"modified":"2021-12-24T15:56:12","modified_gmt":"2021-12-24T15:56:12","slug":"pdf-to-excel-fix-misplaced-column-content","status":"publish","type":"post","link":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html","title":{"rendered":"PDF To Excel Conversion: Fixing Misplaced Column Content"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7994\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/PDF-Excel-conversion-fix-content.png\" alt=\"How to fix misplaced text in PDF to Excel conversion\" width=\"1200\" height=\"628\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/PDF-Excel-conversion-fix-content.png 1200w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/PDF-Excel-conversion-fix-content-300x157.png 300w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/PDF-Excel-conversion-fix-content-768x402.png 768w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/PDF-Excel-conversion-fix-content-1024x536.png 1024w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">PDF to Excel conversion is probably the most problematic conversion of them all. Why? Because PDFs don\u2019t contain formatting or rows &amp; columns unless they\u2019re tagged. Furthermore, chances that you\u2019re dealing with a tagged PDF are really slim, to say the least. \u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Bottom line, you need to accept the fact that you won\u2019t get an accurate PDF to Excel conversion, right? Wrong! We\u2019ll show you how to save yourself from having to clean up hundreds of misaligned and poorly formatted rows and columns as a result of the poor conversion.<\/span><\/p>\n<p><!--more--><\/p>\n<p><a href=\"https:\/\/www.investintech.com\/\"><span style=\"font-weight: 400;\">Able2Extract<\/span><\/a><span style=\"font-weight: 400;\"> can help you get the PDF to Excel conversion that requires minimal clean up if any. In most cases, the Automatic conversion feature will do the trick. However, there are some stubborn PDFs that just won\u2019t give up that easily leaving you with formatting issues such as misplaced column content. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">If you\u2019re having text misplacement troubles after performing the PDF to Excel conversion yourself, we\u2019ve got some good news. You\u2019ve come to the right place. We\u2019ll show you a neat trick that will allow you to get the most accurate output every single time. <\/span><\/p>\n<p style=\"padding: 2px 6px 4px 6px; color: #555555; background-color: #eeeeee; border: #dddddd 2px solid;\"><b>Bonus tip 1<\/b><span style=\"font-weight: 400;\">: <\/span><i><span style=\"font-weight: 400;\">Do you experience other formatting issues when converting PDF to Excel? Learn how Able2Extract can fix all of them <\/span><\/i><a href=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7898-convert-pdf-excel-formatting-issues.html\"><i><span style=\"font-weight: 400;\">here<\/span><\/i><\/a><i><span style=\"font-weight: 400;\">. <\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">Here is where Able2Extract\u2019s <\/span><span style=\"font-weight: 400;\">custom PDF to Excel<\/span><span style=\"font-weight: 400;\"> feature comes into play. Follow the tutorial below and learn how to fix misplaced column words &amp; numbers prior to the conversion. <\/span><\/p>\n<h2><span style=\"font-weight: 400;\">How to Fix Misplaced Column Text <\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Let\u2019s take a look at the PDF example below. <\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7995\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/PDF-with-tables.png\" alt=\"PDF table prior to Excel conversion\" width=\"945\" height=\"783\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/PDF-with-tables.png 945w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/PDF-with-tables-300x249.png 300w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/PDF-with-tables-768x636.png 768w\" sizes=\"auto, (max-width: 945px) 100vw, 945px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">If you perform a regular PDF to Excel conversion on a complex PDF like this one you\u2019ll get some misplaced words that are not located where you would expect them to be. Notice how the words \u201c<\/span><i><span style=\"font-weight: 400;\">Outstanding<\/span><\/i><span style=\"font-weight: 400;\">\u201d (for both 2015 and 2016) in the first table header are not placed in the appropriate columns. <\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7996\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/Excel-spreadsheet-after-conversion.png\" alt=\"Excel spreadsheet with words misplaced in different columns\" width=\"1179\" height=\"361\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/Excel-spreadsheet-after-conversion.png 1179w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/Excel-spreadsheet-after-conversion-300x92.png 300w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/Excel-spreadsheet-after-conversion-768x235.png 768w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/Excel-spreadsheet-after-conversion-1024x314.png 1024w\" sizes=\"auto, (max-width: 1179px) 100vw, 1179px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">You get how tedious it can be to fix multiple issues like this on a day-to-day basis. Here\u2019s how you can solve this prior to the conversion and ensure that you get the most accurate table extraction. Just follow the steps below or watch the short video tutorial at the end. <\/span><\/p>\n<h3><b>Step 1<\/b><span style=\"font-weight: 400;\"> \u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">The first thing you need to do, assuming that you have Able2Extract already installed on your PC, if not you can get a free trial <\/span><a href=\"https:\/\/www.investintech.com\/prod_downloadsa2e.htm\"><span style=\"font-weight: 400;\">here<\/span><\/a><span style=\"font-weight: 400;\">, is to run the program and <\/span><b>open the PDF<\/b><span style=\"font-weight: 400;\"> file you want to convert to Excel. <\/span><\/p>\n<h3><b>Step 2<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Once you\u2019ve opened the PDF select the part of the document you want to convert, click on the <\/span><b>Excel<\/b><span style=\"font-weight: 400;\"> button and opt for <\/span><b>Custom conversion<\/b><span style=\"font-weight: 400;\">. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">Now, in the <\/span><b>Custom Excel window<\/b><span style=\"font-weight: 400;\"> hover the mouse cursor over the vertical line which hits the word \u201cOutstanding\u201d, press the left mouse button and slightly drag the line to the left until it\u2019s in the appropriate position. Repeat the process with the vertical line hitting the other word. <\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7997\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/Adjusting-column-width.png\" alt=\"Manual readjustment of column lines\" width=\"966\" height=\"271\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/Adjusting-column-width.png 966w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/Adjusting-column-width-300x84.png 300w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/Adjusting-column-width-768x215.png 768w\" sizes=\"auto, (max-width: 966px) 100vw, 966px\" \/><\/p>\n<h3><b>Step 3<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">The next step is to select the <\/span><b>Split Only Between Words<\/b><span style=\"font-weight: 400;\"> in the dropdown list located in the Columns frame. <\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7998\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/Custom-Excel-Frame-Options.png\" alt=\"Split Only Between Words option\" width=\"857\" height=\"664\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/Custom-Excel-Frame-Options.png 857w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/Custom-Excel-Frame-Options-300x232.png 300w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/Custom-Excel-Frame-Options-768x595.png 768w\" sizes=\"auto, (max-width: 857px) 100vw, 857px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">All is left do is to start the conversion by hitting the green <\/span><b>Convert<\/b><span style=\"font-weight: 400;\"> button at the bottom. <\/span><\/p>\n<p style=\"padding: 2px 6px 4px 6px; color: #555555; background-color: #eeeeee; border: #dddddd 2px solid;\"><b>Bonus tip 2<\/b><span style=\"font-weight: 400;\">: <\/span><i><span style=\"font-weight: 400;\">Check out our guide on <\/span><\/i><a href=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7802-how-to-excel-pivot-table.html\"><i><span style=\"font-weight: 400;\">how to use a pivot table in Excel<\/span><\/i><\/a><i><span style=\"font-weight: 400;\">. <\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">The result is shown in the image below. As you can see, the words are now placed in the correct column &amp; the spreadsheet doesn\u2019t require any additional work.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8000\" src=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/Excel-spreadsheet-custom-conversion.png\" alt=\"Spreadsheet with accurately aligned words\" width=\"1088\" height=\"289\" srcset=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/Excel-spreadsheet-custom-conversion.png 1088w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/Excel-spreadsheet-custom-conversion-300x80.png 300w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/Excel-spreadsheet-custom-conversion-768x204.png 768w, https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/Excel-spreadsheet-custom-conversion-1024x272.png 1024w\" sizes=\"auto, (max-width: 1088px) 100vw, 1088px\" \/><\/p>\n<p style=\"padding: 2px 6px 4px 6px; color: #555555; background-color: #eeeeee; border: #dddddd 2px solid;\"><b>Bonus tip 3<\/b><span style=\"font-weight: 400;\">: <\/span><i><span style=\"font-weight: 400;\">Do you have to convert PDFs that have the same layout to MS Excel over and over again? Yes? You can speed up the PDF to Excel conversion process with Able2Extract\u2019s <\/span><\/i><a href=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/6482-pdf-conversion-custom-excel-templates.html\"><i><span style=\"font-weight: 400;\">Custom Excel Templates<\/span><\/i><\/a><i><span style=\"font-weight: 400;\"> feature. <\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">That\u2019s it. Just a few clicks &amp; drags and you\u2019ve managed to solve the content misplacement issue for good. If you\u2019ve stumbled upon this blog, you were probably looking for a viable solution for fixing misplaced column words and numbers. <\/span><span style=\"font-weight: 400;\">Hopefully, this tutorial was just the thing you were looking for. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">Do you have any other issues while performing a <a href=\"https:\/\/www.investintech.com\/pdf-to-excel\/\">PDF to Excel<\/a> conversion? If yes, let us know in the comments below. We\u2019ll do our best to cover it in one of our next posts. <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>PDF to Excel conversion is probably the most problematic conversion of them all. Why? Because PDFs don\u2019t contain formatting or rows &amp; columns unless they\u2019re tagged. Furthermore, chances that you\u2019re dealing with a tagged PDF are really slim, to say the least. \u00a0 Bottom line, you need to accept the fact that you won\u2019t get &#8230; <a title=\"PDF To Excel Conversion: Fixing Misplaced Column Content\" class=\"read-more\" href=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html\" aria-label=\"More on PDF To Excel Conversion: Fixing Misplaced Column Content\">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,265,45,56,135,85,39,59,122],"class_list":["post-7993","post","type-post","status-publish","format-standard","hentry","category-1-about","category-2-conversion","category-investintech-tips","category-tech-tips-tutorials","tag-able2extract","tag-able2extract-professional","tag-ms-excel","tag-pdf","tag-pdf-conversion","tag-pdf-to-excel","tag-productivity","tag-tips","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 Conversion: Fixing Misplaced Column Content<\/title>\n<meta name=\"description\" content=\"Having to clean up the misplaced words &amp; numbers after performing a PDF to Excel conversion is tedious. Luckily, Able2Extract can help you fix the misplaced content prior to the conversion.\" \/>\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\/7993-pdf-to-excel-fix-misplaced-column-content.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 Conversion: Fixing Misplaced Column Content\" \/>\n<meta property=\"og:description\" content=\"Having to clean up the misplaced words &amp; numbers after performing a PDF to Excel conversion is tedious. Luckily, Able2Extract can help you fix the misplaced content prior to the conversion.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html\" \/>\n<meta property=\"og:site_name\" content=\"PDF Blog | Investintech PDF Solutions\" \/>\n<meta property=\"article:published_time\" content=\"2018-04-02T15:47:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-24T15:56:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/PDF-Excel-conversion-fix-content.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\/7993-pdf-to-excel-fix-misplaced-column-content.html#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html\"},\"author\":{\"name\":\"goranka\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/b62f30e5e357f36e69ff2b5f1ba865a1\"},\"headline\":\"PDF To Excel Conversion: Fixing Misplaced Column Content\",\"datePublished\":\"2018-04-02T15:47:38+00:00\",\"dateModified\":\"2021-12-24T15:56:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html\"},\"wordCount\":714,\"publisher\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/PDF-Excel-conversion-fix-content.png\",\"keywords\":[\"Able2Extract\",\"Able2Extract Professional\",\"MS Excel\",\"PDF\",\"PDF conversion\",\"PDF to Excel\",\"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\/7993-pdf-to-excel-fix-misplaced-column-content.html\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html\",\"name\":\"PDF To Excel Conversion: Fixing Misplaced Column Content\",\"isPartOf\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/PDF-Excel-conversion-fix-content.png\",\"datePublished\":\"2018-04-02T15:47:38+00:00\",\"dateModified\":\"2021-12-24T15:56:12+00:00\",\"description\":\"Having to clean up the misplaced words & numbers after performing a PDF to Excel conversion is tedious. Luckily, Able2Extract can help you fix the misplaced content prior to the conversion.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html#primaryimage\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/PDF-Excel-conversion-fix-content.png\",\"contentUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/PDF-Excel-conversion-fix-content.png\",\"width\":1200,\"height\":628,\"caption\":\"How to fix misplaced text in PDF to Excel conversion\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.investintech.com\/resources\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PDF To Excel Conversion: Fixing Misplaced Column Content\"}]},{\"@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 Conversion: Fixing Misplaced Column Content","description":"Having to clean up the misplaced words & numbers after performing a PDF to Excel conversion is tedious. Luckily, Able2Extract can help you fix the misplaced content prior to the conversion.","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\/7993-pdf-to-excel-fix-misplaced-column-content.html","og_locale":"en_US","og_type":"article","og_title":"PDF To Excel Conversion: Fixing Misplaced Column Content","og_description":"Having to clean up the misplaced words & numbers after performing a PDF to Excel conversion is tedious. Luckily, Able2Extract can help you fix the misplaced content prior to the conversion.","og_url":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html","og_site_name":"PDF Blog | Investintech PDF Solutions","article_published_time":"2018-04-02T15:47:38+00:00","article_modified_time":"2021-12-24T15:56:12+00:00","og_image":[{"url":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/PDF-Excel-conversion-fix-content.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\/7993-pdf-to-excel-fix-misplaced-column-content.html#article","isPartOf":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html"},"author":{"name":"goranka","@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/b62f30e5e357f36e69ff2b5f1ba865a1"},"headline":"PDF To Excel Conversion: Fixing Misplaced Column Content","datePublished":"2018-04-02T15:47:38+00:00","dateModified":"2021-12-24T15:56:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html"},"wordCount":714,"publisher":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#organization"},"image":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html#primaryimage"},"thumbnailUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/PDF-Excel-conversion-fix-content.png","keywords":["Able2Extract","Able2Extract Professional","MS Excel","PDF","PDF conversion","PDF to Excel","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\/7993-pdf-to-excel-fix-misplaced-column-content.html","url":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html","name":"PDF To Excel Conversion: Fixing Misplaced Column Content","isPartOf":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html#primaryimage"},"image":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html#primaryimage"},"thumbnailUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/PDF-Excel-conversion-fix-content.png","datePublished":"2018-04-02T15:47:38+00:00","dateModified":"2021-12-24T15:56:12+00:00","description":"Having to clean up the misplaced words & numbers after performing a PDF to Excel conversion is tedious. Luckily, Able2Extract can help you fix the misplaced content prior to the conversion.","breadcrumb":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html#primaryimage","url":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/PDF-Excel-conversion-fix-content.png","contentUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2018\/04\/PDF-Excel-conversion-fix-content.png","width":1200,"height":628,"caption":"How to fix misplaced text in PDF to Excel conversion"},{"@type":"BreadcrumbList","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/7993-pdf-to-excel-fix-misplaced-column-content.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.investintech.com\/resources\/blog\/"},{"@type":"ListItem","position":2,"name":"PDF To Excel Conversion: Fixing Misplaced Column Content"}]},{"@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\/7993","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=7993"}],"version-history":[{"count":7,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/7993\/revisions"}],"predecessor-version":[{"id":10425,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/7993\/revisions\/10425"}],"wp:attachment":[{"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/media?parent=7993"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/categories?post=7993"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/tags?post=7993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}