1<html lang="en"> 2 3<head> 4 <meta charset="utf-8"> 5 <meta http-equiv="X-UA-Compatible" content="IE=edge"> 6 <meta name="viewport" content="width=device-width,initial-scale=1"> 7 <meta name="application-name" content="extracttable.com"> 8 <meta name="robots" content="index, follow"> 9 <meta name="keywords" content="extract table, parse table, image table, pdf table"/> 10 <title>ImageToExcel - API Tutorial to convert image to excel, JPG to excel</title> 11 <link rel="icon" href="../img/favicon.png"> 12 13 <meta name="title" content="ImageToExcel - API Tutorial to convert image to excel, JPG to excel"> 14 <meta name="description" content="Easiest way to convert image to excel, JPG to excel, convert PDF to excel without worrying about the table coordinates. Highly accurate, Lowest $/credit"> 15 <meta name="application-name" content="ImageToExcel - API Tutorial to convert image to excel, JPG to excel"/> 16 17 <!-- Open Graph / Facebook --> 18 <meta property="og:type" content="website"> 19 <meta property="og:url" content="https://imagetoexcel.com/"> 20 <meta property="og:title" content="ImageToExcel - Tutorial"> 21 <meta property="og:description" content="Easiest way to extract tabular data from images, PDF to excelwithout worrying about the table coordinates. Highly accurate, Lowest $/credit"> 22 <meta property="og:image" content="https://imagetoexcel.com/img/preview.png"> 23 <meta property="og:image:alt" content="https://imagetoexcel.com"/> 24 <meta property="og:updated_time" content="1566780178"/> 25 <!-- Twitter --> 26 <meta property="twitter:card" content="summary"> 27 <meta property="twitter:url" content="https://imagetoexcel.com/"> 28 <meta property="twitter:title" content="ImageToExcel - API Tutorial to convert image to excel, JPG to excel"> 29 <meta property="twitter:description" content="Easiest way to extract tabular data from images, PDF to excelwithout worrying about the table coordinates. Highly accurate, Lowest $/credit"> 30 <meta property="twitter:image" content="https://imagetoexcel.com/img/preview.png"> 31 <meta property="twitter:site" content="@extracttable" /> 32 33 <meta name="language" content="English"> 34 <meta name="url" content="https://imagetoexcel.com"> 35 <meta name="msapplication-TileColor" content="#ffffff"> 36 <meta name="msapplication-TileImage" content="img/favicon.png"> 37 <meta name="theme-color" content="#ffffff"> 38 39 <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha256-YLGeXaapI0/5IgZopewRJcFXomhRMlYYjugPLSyNjTY=" crossorigin="anonymous" /> 40 <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Chivo&display=swap" media="none" onload="if(media!='all')media='all'"> 41 <link rel="stylesheet" href="../css/dilinger.css"/> 42 <link rel="stylesheet" href="../css/header.css"/> 43
43<script type="application/ld+json">{"@context":"http://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Tutorial to convert image to excel, JPG to excel","item":"https://imagetoexcel.com/tutorial.html"},{"@type":"ListItem","position":2,"name":"How to Convert PDF to excel","item":"https://extracttable.github.io/ExtractTable-py"},{"@type":"ListItem","position":3,"name":"convert image to excel, JPG to excel","item":"https://imagetoexcel.com/convert-image-to-excel.html"}]}</script>
43 44
44<script type="application/ld+json" data-schema="product">{"@context":"https://schema.org/","@type":"Product","name":"Image to excel converter","category":"Productivity","image":["https://imagetoexcel.com/img/logo.png","https://imagetoexcel.com/img/cover-pic-small.png"],"description":"Best free online image to excel convertor, scan PDF to excel","brand":{"@type":"Thing","name":"ExtractTable.com"},"review":{"@type":"Review","reviewRating":{"@type":"Rating","ratingValue":"4","bestRating":"5"},"author":{"@type":"Person","name":"Saradhi"}},"aggregateRating":{"@type":"AggregateRating","ratingValue":"4.7","ratingCount":"197","worstRating":"1","bestRating":"5"}}</script>
44 45
45<script type="application/ld+json">{"@context":"http://schema.org","@type":"BlogPosting","isPartOf":{"@type":"Blog","name":"extracttable Blog","url":"https://imagetoexcel.com/resources","inLanguage":"en","publisher":{"@type":"Organization","name":"extracttable","url":"https://imagetoexcel.com"}},"mainEntityOfPage":"https://imagetoexcel.com/resources/tutorial.html","headline":"convert image to excel, JPG to excel","author":{"@type":"Person","name":"Saradhi","jobTitle":"Founder, Developer","image":{"@type":"imageObject","encodingFormat":"image/png","url":"https://imagetoexcel.com/img/cover-pic-small.png","width":612,"height":356}},"datePublished":"2020-02-11T00:00-04:00","dateModified":"2019-02-11T00:00-04:00","image":{"@type":"imageObject","encodingFormat":"image/png","url":"https://imagetoexcel.com/img/cover-pic.png","width":967,"height":317},"publisher":{"@type":"Organization","name":"extracttable","url":"https://imagetoexcel.com","logo":{"@type":"imageObject","url":"https://imagetoexcel.com/img/logo.png"}}}</script>
45 46 <!-- Global site tag (gtag.js) - Google Analytics -->
vendor: 66 bytes, lines 46-47
46 47 <script async src="https://www.googletagmanager.com/gtag/js?id=
47UA-170448544-1
vendor: 14 bytes, lines 47-48
47"></script> 48
48<script>
vendor: 124 bytes, line 48
48window.dataLayer = window.dataLayer || [];function gtag(){dataLayer.push(arguments);}gtag('js', new Date());gtag('config', '
48UA-170448544-1
vendor: 3 bytes, line 48
48');
48</script>
48 49</head> 50 51<body id="home"> 52 <header class="constant-bg"> 53 <nav class="navbar navbar-expand-lg navbar-light bg-light"> 54 <div class="container"> 55 <a class="navbar-brand" href="../index.html"> 56 <img src="../img/logo.svg" alt="image to excel logo" class="logo">ImageToExcel 57 </a> 58 <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNavDropdown" aria-controls="navbarNavDropdown" aria-expanded="false" aria-label="Toggle navigation"><span class="navbar-toggler-icon"></span> 59 </button> 60 <div class="collapse navbar-collapse" id="navbarNavDropdown"> 61 <ul class="navbar-nav mx-auto"> 62 <li class="nav-item" data-toggle="collapse" data-target=".navbar-collapse.show"><a class="nav-link js-scroll-trigger" href="..#features">Why Us</a></li> 63 <li class="nav-item" data-toggle="collapse" data-target=".navbar-collapse.show"><a class="nav-link js-scroll-trigger" href="..#pricing">Pricing</a></li> 64 <li class="nav-item dropdown"> 65 <a class="nav-link js-scroll-trigger" href="#" id="navbarDropdownMenuLink" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Resources▾</a> 66 <ul class="dropdown-menu" aria-labelledby="navbarDropdownMenuLink"> 67 <li><a class="dropdown-item" href="tutorial.html" target="_blank" title="Tutorial on API access">Tutorial</a></li> 68 <li class="dropdown-divider"></li> 69 <li><a class="dropdown-item" href="https://documenter.getpostman.com/view/6396033/SVfMS9xu" rel="noopener" target="_blank">API Document</a></li> 70 <li><a class="dropdown-item" href="https://extracttable.github.io/ExtractTable-py" title="Official Python library to convert PDF to excel, extract tables from image">ExtractTable-py</a></li> 71 <li><a class="dropdown-item" href="https://extracttable.github.io/camelotpro" title="Python Wrapper"rel="noreferrer">CamelotPro</a></li> 72 <li><a class="dropdown-item" href="https://gsuite.google.com/marketplace/app/extracttable_for_spreadsheet/387162865168" title="Google Spreadsheet Addon to extract image tables to spreadsheet" rel="noopener" target="_blank">GSuite Addon</a></li> 73 </ul> 74 </li> 75 <li class="nav-item" data-toggle="collapse" data-target=".navbar-collapse.show"><a class="nav-link js-scroll-trigger" href="#pt-faq">FAQ</a></li> 76 <li class="nav-item" data-toggle="collapse" data-target=".navbar-collapse.show"><a class="nav-link js-scroll-trigger" href="#" data-toggle="modal" data-target="#contactModal">Contact</a></li> 77 </ul> 78 <div class="navbar-nav ml-auto"> 79 <a class="nav-item" data-toggle="collapse" data-target=".navbar-collapse.show"> 80 <button href="#" data-toggle="modal" data-target="#proUIModal" class="btn btn-warning">Web-PRO</button> 81 </a> 82 </div> 83 </div> 84 </div> 85 </nav> 86 </header> 87 <section id="slider"> 88 <div class="container"> 89 <h1 class="code-line" data-line-start=0 data-line-end=1><a id="Tutorial_to_Extract_tabular_data_from_images_or_PDFs_0"></a>Tutorial to extract tabular data from images or PDFs</h1> 90 <p class="has-line-data" data-line-start="1" data-line-end="2">ExtractTable API allows extracting tabular data from <strong>an image or a PDF</strong>. The motivation is to make it easier for developers - not to worry about the table area, column or row coordinates, rotation et al in the input.</p> 91 <h1 class="code-line" data-line-start=3 data-line-end=4><a id="1_Prerequisite_3"></a>1. Prerequisite</h1> 92 <p class="has-line-data" data-line-start="4" data-line-end="5"><strong>API Key</strong>: A developer, you, must need a valid API key to use <a href="http://extracttable.com">extracttable.com</a> API. Get some <a href="https://imagetoexcel.com/trail.html">FREE credits here</a>. We dominate the service with greate accuracy and lowest $/credit and credits expiration. You are most welcomed to <a href="https://imagetoexcel.com/#pricing">BUY credits here</a> or email me at <a href="mailto:[email protected]">[email protected]</a> for assistance.</p> 93 <!--Feel free to move to competitors if they are any better, but drop us an email to see who it is ;) --> 94 <h1 class="code-line" data-line-start=6 data-line-end=7><a id="2_Things_to_know_6"></a>2. Things to know</h1> 95 <p class="has-line-data" data-line-start="7" data-line-end="8">This section will help to give you a glance on an overview that helps you to troubleshoot issues when coding.</p> 96 <h2 class="code-line" data-line-start=9 data-line-end=10><a id="21_Endpoints_9"></a>2.1 Endpoints</h2> 97 <p class="has-line-data" data-line-start="10" data-line-end="11">Firstly, note that there are 3 different API endpoints - all endpoints must need a valid <strong>API Key passed in header as âx-api-keyâ</strong> 98 </p> 99 <table class="table table-striped table-bordered"> 100 <thead> 101 <tr> 102 <th>Usage</th> 103 <th>Endpoint</th> 104 <th>Request Methods</th> 105 <th>Must contain</th> 106 <th>Common Mistakes</th> 107 </tr> 108 </thead> 109 <tbody> 110 <tr> 111 <td>Validate API Key</td> 112 <td>https://validator.extracttable.com/</td> 113 <td>GET</td> 114 <td>a valid API Key passed in the request header as âx-api-keyâ</td> 115 <td>missing API key in request headers</td> 116 </tr> 117 <tr> 118 <td>Trigger a request</td> 119 <td>https://trigger.extracttable.com/</td> 120 <td>POST</td> 121 <td>file data (not file location) in <strong>body</strong> as âinputâ of <strong>multipart/form-data</strong> 122 </td> 123 <td>requesting as x-www-form-urlencoded</td> 124 </tr> 125 <tr> 126 <td>Retrieve the result</td> 127 <td>https://getresult.extracttable.com/</td> 128 <td>GET</td> 129 <td><strong>JobId</strong>
129- recieved in the trigger response</td> 130 <td>Invalid JobId / POST instead of GET</td> 131 </tr> 132 </tbody> 133 </table> 134 <h2 class="code-line" data-line-start=18 data-line-end=19><a id="22_Stepwise_procedure_18"></a>2.2 Step-wise procedure</h2> 135 <p class="has-line-data" data-line-start="19" data-line-end="22">i. Check if your API Key is valid and get the usage details of it 136 <br>ii. Trigger a Job to process the file 137 <br>iii. Retrieve the result of the triggered job - <strong>always</strong> check for <code>JobStatus</code> in the response which indicates the status of the job, described as below</p> 138 <ul> 139 <li class="has-line-data" data-line-start="22" data-line-end="23"><strong>Processing</strong>: The file is still being processed (happens on PDF file). <strong>Wait</strong> for 15-20 seconds and <strong>retry until the JobStatus is NOT âProcessingâ</strong> 140 </li> 141 <li class="has-line-data" data-line-start="23" data-line-end="24"><strong>Success</strong>: The table extraction is completed. Check for an array of âTabularJsonâ in âTablesâ of the response. Helpful resources to convert the API response to CSV</li> 142 <li class="has-line-data" data-line-start="24" data-line-end="25"><strong>Failed</strong>: The process failed in doing the job. Also, credits are not deducted</li> 143 <li class="has-line-data" data-line-start="25" data-line-end="27"><strong>Incomplete</strong>: Only few pages of the PDF are processed. You should be seeing tables extracted from succesffully processed pages</li> 144 </ul> 145 <h1 class="code-line" data-line-start=27 data-line-end=28><a id="3_Code_Samples_27"></a>3. Code Samples</h1> 146 <p class="has-line-data" data-line-start="28" data-line-end="29">Below are some code samples in differnt programming languages with differnt libraries developed internally or shared by our customers for public</p> 147 <ul> 148 <li class="has-line-data" data-line-start="30" data-line-end="34">Python 149 <ul> 150 <li class="has-line-data" data-line-start="31" data-line-end="32"><a href="https://github.com/ExtractTable/ExtractTable-py/blob/master/example-code.ipynb">ImageToExcel - using the core ExtractTable library</a> 151 </li> 152 <li class="has-line-data" data-line-start="32" data-line-end="33"><a href="https://github.com/ExtractTable/camelotpro/blob/master/example-code.ipynb">CamelotPro - Wrapped on Camelot-Py to make it easier for regular camelot-py users</a> 153 </li> 154 </ul> 155 </li> 156 <li class="has-line-data" data-line-start="34" data-line-end="36">R 157 <ul> 158 <li class="has-line-data" data-line-start="35" data-line-end="36"><a href="https://github.com/ExtractTable/ExtractTable-R/blob/master/main.R">Complete Code</a> 159 </li> 160 </ul> 161 </li> 162 <li class="has-line-data" data-line-start="36" data-line-end="38">Other Programming Languages 163 <ul> 164 <li class="has-line-data" data-line-start="37" data-line-end="38">Refer to the <a href="https://documenter.getpostman.com/view/6396033/SVfMS9xu?version=latest">API documentation here</a> 165 </li> 166 </ul> 167 </li> 168 </ul> 169 </div> 170 </section> 171 <hr> 172 <br> 173 <br> 174 <br> 175</body> 176 177</html>
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.