Software - Desktop

Software - Desktop

  • Adobe - Optical Character Recognition & Exporting to Excel

    When you create an Acrobat Document (PDF) from Word, the actual text of what was written is stored in that document.  This allows the user to select text so it can copied and pasted into another document.  It also allows newer versions of Microsoft Word to open that file so you can edit it.  (Side note: While this works, Word doesn’t do a great job of preserving the formatting).  However, when paper documents are scanned into a computer, the PDF file is created using an image, without the actual text. 

    Without the embedded text, the you can’t copy and paste, you can’t open the file in Word for editing and, perhaps most importantly, the document can’t be searched.  Fortunately, Acrobat can analyze the picture, recognize the text and add it to the document. 

    Here’s how…..

    We’ll use a sample document that was printed out and scanned in.  The PDF document has been embedded so you can try it yourself. 

    pdfadobe-sample.pdf

    Open the file and you’ll see the chart of numbers below.  If you try to select the text you’ll find that you can’t…..

    {slider Optical Character Recognition (OCR)}

    Scan Text with OCR (Optimal Character Recognition)

    adobe-sample-img-1.png

    Click Tools and then Scan & OCR

    adobe image2

    Now click Recognize Text and then In this File:

    adobe image3

    Then click the Recognize Text Button

    adobe image4

    Acrobat will then recognize the text.  Try highlighting, copying and pasting the text.  You’ll see that now, you can!

    Since this is a chart of numbers you might want to paste it into Excel. 

    Go ahead….Try it.  You’ll get something that looks like the picture below, which isn’t all that useful.

    adobe image5

    {slider Export Data into Excel}

    Export Data into Excel

    Fortunately, Acrobat has a better way to get your document into excel.

    In Acrobat, if you choose File > Export To > Spreadsheet > Microsoft Excel Workbook, you’ll be able to save the contents as a spreadsheet and open it in Excel.

    As you can see, the result is much more useful:

    adobe image6

    One caveat that you should be aware of is that this process isn’t perfect.  Acrobat is “reading” the text by looking at the lines in the document.  If the scan isn’t clear, has smudges, watermarks or is distorted in any way, the software can read the document incorrectly.  When working with text, this typically isn’t a big problem because spell check will catch most of the errors.  However, when working with numbers, it’s important to verify that everything worked properly.

    {/sliders}

  • Consulting & Advising Services

  • How do I re-activate Office for an off-campus machine?

    Microsoft Office 2016 must be activated using a license key obtained from https://software.rutgers.edu

    Connect to Rutgers VPN: 

    VPN Installation and Configuration Instructions

    Order License Key

    1. Log on to: https://software.rutgers.edu
    2. Under "License Types" to the left, click on "Microsoft EES Software"
    3. Select the appropriate version of Microsoft Office
    4. Click the "Items" tab at the bottom
    5. Click Add to Cart
    6. For "Delivery Method" select "Download"
    7. Click Checkout
    8. Verify your email and click Next
    9. Click Submit Order
    10. Select My Software from the main menu at the top
    11. Select Microsoft Office 2016
    12. Click License
    13. Find the 25-character key from the "License Info" field

    Activate Office

    1. Open any Microsoft Office application (e.g. Excel, PowerPoint, or Word)
    2. Click "File"
    3. Click "Account"
    4. Click "Change Product Key"
    5. Enter the 25-character key from the "License Info" field found under "My Software" on software.rutgers.edu (see above)
    6. After entering the key, click "Install"
    7. Click Activate
    8. Click "Yes" to allow "Windows Activation" to make changes to your device.

    If you are still receiving messages that Office is no longer activated, please SUBMIT REQUEST.

  • How do I re-activate Windows for an off-campus machine?

    Microsoft Windows 10 must be activated using a license key obtained from https://software.rutgers.edu

    Microsoft Office 2016 activation steps are here.

    Connect to Rutgers VPN: 

    VPN Installation and Configuration Instructions

    Order License Key

    1. Log on to: https://software.rutgers.edu
    2. Under "Operating System," click on Windows
    3. Click the link for "Microsoft Windows 10 Enterprise Upgrade 32/64bitProduct Activation Required EES Agreement Rutgers-Owned Equipment Only"
    4. Click the "Items" tab at the bottom
    5. Click Add to Cart
    6. For "Delivery Method" select "Download"
    7. Click Checkout
    8. Verify your email and click Next
    9. Click Submit Order
    10. Select My Software from the main menu at the top
    11. Under "Microsoft Windows 10," click License
    12. Find the 25-character key from the "License Info" field

    Activate Windows

    1. Go to System control panel (Windows Key + Pause/Break)
    2. Under "Windows activation," click Change product key
    3. Click Yes to allow "Windows Activation" to make changes to your device.
    4. Enter the 25-character key from the "License Info" field found under "My Software" on software.rutgers.edu (see above)
    5. After entering the key, click Next
    6. Click Activate

    If you are still receiving messages that Windows is no longer activated, please SUBMIT REQUEST.