Speed Up Your PDF to Excel Conversion With Custom Excel Templates

Excel Spreadsheet Diagram

When working to convert PDF data into Excel, you can be swamped with the repetitive task of converting the same data everyday.

For handling large groups of PDFs, there’s the batch conversion feature in Able2Extract. Yet, this option is only ideal for full and automatic conversions.

What about multiple PDF to Excel conversions that need a bit of customization or scanned PDFs that can’t be converted in batch mode, but have the same layout per page?

You can use the Custom PDF to Excel feature to tailor your conversion. But as you can guess, it will get tedious to set up the same row and column structure each time.

Fortunately, in the Able2Extract universe, there’s a feature that makes the process easier: Able2Extract’s Custom Excel Templates. How?

Say you receive a PDF document with the same table structure on the same pages every week. Think invoices, inventory lists, regular data reports, and ledgers. These PDFs are always formatted in the same way. If you only ever work with data from one column in a weekly PDF inventory list, for example, you can use a Custom Excel Template to quickly pull out only that one column of data each time.

To show you, we’re taking a closer look. You can conquer the repetitive PDF to Excel conversions that need to be customized with this feature. Here’s what you should know.

1. Templates Are Easy to Set Up

A Custom Excel Template is simple to create. In fact, you can create your template as you set up your custom PDF to Excel conversion.  To start:

a) Open your PDF file in Able2Extract.

b) Select your content to convert.

c) Click on the Excel button on the toolbar.

d) In the Convert to Excel dialog that appears, select Define under the Custom option.

Selecting Custom Excel Conversion Option

e) Customize your PDF to Excel conversion by using different options from the Custom Excel panel. Don’t forget to preview your conversion results!

Setting Up Custom Conversion


f) Once everything is set, go to File> Save Custom Excel Template As ….

Saving Custom Excel Templates

g) Name your template file and select the location to save your Excel template in.

And that’s it. You just created a Custom Excel Template you can use.  From there, you can continue with your conversion by clicking on Convert.

2. Templates Are Easy to Use

When you have a template saved, you simply load it in the application. The template can be applied to a PDF that is similar to the file for which the template was originally created. This means a PDF that has the same layout on the same pages as that first PDF.

a) In Able2Extract, open the PDF on which you’d like to apply your Custom Excel template.

b) Go to File > Load Custom Excel Template…

Loading Custom Excel Templates

c) Browse for and click on the template you saved. It will have a .pcvt file extension. Click on Open.

Selecting Able2Extract Excel Template

 3. Templates Let You Selectively Convert Data Instantly

When converting with Custom Excel Templates, you can selectively extract the data you need across tables or across pages. From multiple sections of a table to a few lines in a ledger, a Custom Excel template will let you skip any unnecessary pages or tables you don’t need.

Creating Custom Excel Templates

4. Templates Aren’t Automatic

One thing to note about this features is that you can’t automatically create or load templates. But all this means is that you gain control over the content and templates you want to convert and use at any given time as you just saw above.

5. You Can Modify your Template Conversion on the Spot

If a PDF file you wish to convert has more pages than the template you’ve created for it and all those pages have the same layout per page as the previous pages, you can use the “Extend” option to add more pages to the table structure.

a) When your template is uploaded and the Custom Excel panel appears, click on Extend…

Extending Custom Excel Page Range

b) In the dialog that appears, enter the desired page number in the To field.

Extending Page Range In Able2Extract

c) Click on Convert.

d) In the Save As dialog, select a location where the resulting Excel file be saved and give it a name. Click on OK.

As you can see, there’s always a way to speed things up. Next time you’re stuck with transferring the same PDF data into Excel all day, give this feature a try.

How To Insert A Title Block?

Part 13 of 13 in our How To Use AutoCAD series

Because AutoCAD projects are highly detailed and require accuracy, being organized with how you work is important. Imagine dealing with a dozen CAD design files with detailed information outlining a single part. If you aren’t organized in how you label each drawing for printing, then recipients won’t have the necessary information for them.

This is why inserting a Title Block in your AutoCAD drawing is essential for plotting (printing) your drawings, especially in a production environment. A Title Block is used to name the drawing part, time and author. Essentially, it provides important information for when the document is printed.

Creating AutoCAD Title Block

In AutoCAD, you can create your own Title Block template or import a premade template.  To insert a title block, follow these steps:

1. First, locate or download a Title Block template. There are some basic templates that are already included in the AutoCAD. As the good folks at AutoDesk Knowledge note, the Title Block templates are usually the template files starting with “Tutorial-”.

2. Open up a blank drawing and click on the “Layout” tab on the bottom left corner. As you can see by the looks of it, the Layout tab is used for the plotting stage of the production. Right click on the Layout 1 and select Page Setup Manager.

AutoCAD Layout Tabs

3. Click “Modify” and you will be presented with a pop up window. The most important thing you should pay attention to is the paper size. By default, this is set at (8.5 x 11 inches), so be sure to set it up so that it matches the size of the Title Block template.  Select “Landscape” on the Drawing Orientation panel and hit “OK”. We’re now ready to import the template.

4. Click on the “Insert” tab and then on the “Insert” button on the far left side.

AutoCAD Insert Block Option

From the pop up menu, click on Browse and select your template. Leave the check boxes as they are – only check the “Specify on screen” box. Hit “OK”.

AutoCAD Title Block Dialog

5. Position the Title Block and left-click to put it in place. Note that the dashed line represents the print border, so keep in mind to position the Title Block within it.

From here you can further edit the individual Title Block elements by entering the “Block Editor” on the Insert tab. This can be extremely useful for repurposing existing title block templates and even customizing your own.

5 PDF Tasks You Didn’t Know Could Be Done Through A Web Browser

Web browsers have come a long way. There was a time when finally being able to view a PDF natively inside Firefox or Chrome got everyone excited. Now, viewing PDFs is the most basic PDF task you can perform.

Aside from viewing PDFs in your browser, you now know more than a handful of PDF tasks you can accomplish online. But we’ll bet that there are still a few PDF web tricks you didn’t know about. Here are 5 you probably didn’t know about.

1. Translate PDF Text

Because you know that PDFs are hard to edit, it’s natural that you wouldn’t peg the format as one you could translate into different languages. However, it is possible to do so without converting your file and manually translating it word for word with Google Translate.

The online translator  is a popular tool for anyone who needs a quick reference. But in case you didn’t notice, it also has an option where you can upload a document to be translated–PDFs included! Obviously, just as the translations for manual text entries may not be 100%, the translations for documents can be slightly inaccurate, as well. So use this tool with that caveat in mind.

2. Convert PDF to JPEG, Excel and PowerPoint

You’re strapped for time. You need to make some final analysis on tabular data. You need to prep approved images for publication.  You need to make some tweaks to a presentation you’re giving in a few hours. Any of these sound familiar? These scenarios are all too common, and in each case, a PDF file can be involved, making that single PDF task even tougher.

Convert PDF To JPG Online

In cases like these, online conversion tools can be a lifesaver. We know the constraints of time, money and resources. That’s why we’ve made it easy for you to get that PDF to JPEG, PDF to Excel and PDF to PowerPoint conversion done. No installation needed. No registration required. Just upload your file, enter your email and click on Convert. Your file will be emailed to you, free of charge.

3. Read a PDF File Out Loud 

Anyone who needs to review, research or do some reading can especially hate the task if it involves doing so with a PDF document and a busy schedule. Not only does it mean having to read a screen, but, if you’re on the go, it also means having to do it on a mobile device. Something a bit cumbersome for a 5-7 inch gadget. And that’s why SpokenText  makes this list.

This tool is an online text to audio converter that comes with the ability to convert text in documents to audio files (.mp3, .m4b) you can take with you. You literally turn your reading task into a listening one. It can convert Word documents, plain text files and PDF documents, just to name a few. This online tool has paid and trial accounts with a few customizable features that makes it worth checking out.

4. Bookmark Your Page In A PDF

Reading lengthy PDF files in Chrome is common and it can be pretty frustrating at times.  You close your PDF, lose your page and then open the file later on, only to scroll through the entire PDF  to find the one place where you left off.

The Chrome extension, PDF Bookmarker, eliminates this hassle if you’re reading a PDF in Google Docs. Once the extension is installed, you can bookmark the PDF page you’re reading. Just click on the bookmark button on the thumbnail icon. The extension will open up to the page you bookmarked the next time you open the file.

5. Sign PDF Documents

Signing PDFs is one of those tasks that you don’t want to do. It sounds tedious and difficult. So it may surprise you that it can accomplished online and with Chrome, no less. Of course, this capability is done through a Chrome extension: HelloSign.

Selecting Signature Type

HelloSign will let you add form fields and signatures to PDFs that are uploaded to Google Drive. Signed documents come with an audit trail to keep track of them, email notifications to all parties, and the ability to share the signed form. Read our tutorial on how to sign PDF documents. We feature a step by step look at how to use this extension to add a signature to your PDF documents.

With just a few of these tips, you can further enhance how you work with PDF files online. Give them a try and let us know how they work out for you.

How To Trim Objects Quickly?

Part 12 of 13 in our How To Use AutoCAD series

Along with the many object manipulation features AutoCAD provides,  the Trim command is another common feature you’ll need to be familiar with as you modify your CAD drawings.

Trimming objects in AutoCAD is useful for merging objects at the place of their intersection.  The easiest way to trim objects in AutoCAD 2016 is to use the “Trim” command located on the Modify panel.

1.First, select the objects you want to trim. You can click on them individually or you can left click and drag to group the objects.

Trimming AutoCAD Objects

2.Right click on the blank space to finalize the selection.

3.Left click on the lines to trim them. Right click or enter to finalize the trimming.

Trimming AutoCAD Objects

Note that you can only trim the lines that intersect. The best tip for deleting unwanted lines would be to use the “Erase” command, which is also located on the Modify panel.


How to Combine and Merge PDFs — Complete Tutorial

There are numerous reasons why you might want to combine multiple PDF documents into one:

  • Save on storage space
  • Organize your work better
  • Reduce document cluttering
  • Password protect a single PDF instead of 20 of them
  • Put together a report from different sources

Whatever the case may be, one thing is for certain: merging PDF is a good trick to have in your bag for any future document-related work. PDF is here to stay, as it has been for over 20 years.

The big question is, what is the easiest way of combining PDF documents and how much does that cost?

To answer your question, we prepared a comprehensive tutorial on some of the most efficient ways of merging PDF, as well as the tools that we used. We’re leaving the exact choice to you. Let’s take a look.

Merging PDF on Your Desktop

The first thing that comes to most people’s mind when it comes to this is to use a PDF merging software to combine documents. This is really smart and let me tell you why.

In the age of data breaches and low document security, it’s good to try and keep everything local. Document writing, management, conversion and other mandatory work (such as merging) can all be done from the comfort of your desktop, without requiring an Internet connection.

Not just that, but you’ll also be able to manage PDFs of all sizes, from smaller ones that weigh in at just around several KB to the gigantic 100 MB, 300 page documents. Let’s see how you can combine two PDFs on your desktop.

1) Open the first document in Able2Extract. Don’t worry, you can download the software as a 7 day free trial.

Opening PDF In Able2Extract

2) Click on “Edit” and then “Insert from PDF”.

Inserting PDF Pages

3) Select the other PDF document from the pop up and click Open. Specify where you’d like to insert (merge) that new PDF. Click Insert and job done!

Merging PDF Documents

How to Merge PDF Documents Online

Desktop tools are great for for merging classified, larger PDF documents, but what about a quick way to combine smaller files for let’s say emailing purposes? This is where you can resort to online tools for PDF to help you merge PDF quickly and effortlessly.

Online PDF merging tools all have, somewhat, similar characteristics. They are particularly good for smaller and non-classified PDFs, which make the bulk of most people’s documents. However, they do have some downsides, most commonly:

  • They usually have file size limitations. For example, you can upload files up to 5 MB for free and pay for larger files. However, this depends on the individual tool.
  • Lower document security. Every online tool depends on you uploading the file to the company’s servers, which means it kind of gets out of your hands.
  • Workflow is slower. Since everything operates online, your PDF merging speed depends on the internet connection and the PDF file size.

You can find tools for online PDF merging by just Googling it. We tested a bunch of them and found out that PDFMerge! did the best job, by far. The tool is intuitive and easy to use:

  1. Upload PDFs from your computer.
  2. Click the silver Merge button and the tool will automatically merge your documents, which you can immediately download.

This tool doesn’t add any watermarks and even has an https version available, for users concerned about their document privacy.

The Verdict

Which approach you’ll take when combining PDF documents is completely up to you. We advise using a dependable software application for larger and more important documents, as the comfort and speed of working in a local environment are unmatched. On the other hand, there are situations where you’ll need to quickly combine smaller PDFs and email them, which is exactly where you’ll use a reputable online converter.