jump to navigation

Pulling Data from a Scanned PDF into Excel July 1, 2015

Posted by carolhagen in Bluebeam Revu, Construction Industry - Software.
Tags: , , , ,
trackback

When printed materials are distributed at your next seminar or meeting, or your find a magazine that contains a table that you find valuable, most people scan the document to PDF to save it for later.  Sometimes you want this data entered into a database or added to spreadsheet.  If you can get it to a spreadsheet you can usually import into a database but who wants to key in all that data?  There’s a better way if you have Bluebeam Revu Extreme.

In today’s Bluebeam tip I’ll step you thru scanning a page from an Owner’s Manual and export the part numbers to Excel.

For those who do not want to watch a video, there are two basic steps:

1. Scanning the Document to PDF

File | Create and choose From Scanner or Camera then follow the prompts displayed to select your scanner or camera, page size and document attributes (Black & White, Grayscale, etc)

Bluebeam Revu Create PDF from Scanner

 

2. Export to an Excel Workbook

File | Export and choose Excel WorkbookPage Region and then draw a rectangle around the data, including the column headings. Bluebeam Extreme does the rest!

How to extract data from a scanned document to a spreadsheet

 

 

Here are a few other ideas of how you could use this:

Accounting: Import the expenses from a credit card statement so you can sort by expense type and subtotal in Excel.

Business Development: Grab the top business lists from local publications for leads and their phone numbers.

What other ideas will you come up with to export to Excel?

 

Advertisements

Comments»

No comments yet — be the first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: