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?

Continue reading →

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, Additor allows you to quickly bookmark the PDF you’re reading.

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 Xodo PDF Merger did the best job, by far. The tool is intuitive and easy to use:

  1. Upload PDFs from your computer, Google Drive, or Dropbox.
  2. Click the Merge button and the tool will automatically merge your documents, which you can immediately download to your device.

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.