Extract PDF Data into Excel Accurately and Selectively

It’s been noted that document conversion from PDF into Excel can heavily disappoint, especially when dealing with spreadsheets overflowing with various data. After trying to convert PDF into Excel, people report all sorts of formatting issues, such as extracting all data from a PDF into a single Excel cell, inaccurate conversion of wrapped text cells, unwanted merged cells that make it very difficult to use aggregate functions, etc.

In order to avoid that, data analysts, accountants and other Microsoft Excel users should find a reliable PDF to Excel conversion solution that will save their valuable time and allow them to easily manipulate data locked in PDF.

Following on that, Excel users may want to try out Able2Extract Professional 9, which is developed precisely with PDF and Microsoft Excel users in mind. It enables users to customize and view their PDF tabular data prior to extracting it into MS Excel spreadsheet format. Additional benefit of using Able2Extract Pro is that it uses OCR technology, thus allowing users to extract information from paper and scanned PDFs well.

There are two ways to use Able2Extract’s PDF to Excel conversion option: automatic and custom. Automatic conversion enables users to let the PDF converter do its work based on the standard settings and needs. There are no requirements from users except to follow the straightforward 1-2-3 step conversion process.

However, the real power of the tool’s PDF to Excel conversion option lies in its capability to convert only selected parts of PDF tables pinpointed by the software's user. This way Excel users can choose exact data they need to process and prepare for reporting with less editing and personal work. Although this selective PDF conversion sounds like it requires advanced user skills, it’s actually very simple - like selecting any other electronic content. Here’s a brief guide to demonstrate how easy it is to instantly extract PDF to Excel accurately and also to actually extract only columns, rows or other parts of PDF that you need:

- Open PDF in Able2Extract:

- Use the Select “Area” option to choose an area for conversion. If converting the whole document, choose “All”.

- Click on “Excel”.

- If you need a fast conversion and don’t have special demands regarding your output file, go ahead and do the automatic conversion.

- If the document contains a lot of data and you want to make sure you get precise results and proper formatting in Excel, click on “Custom”.

- The following box with options will appear:

These options will allow you to tweak your column and row structure, eliminate headers and footers, preview your output file, etc.

If you want to see whether Able2Extract Pro meets your requirements for PDF to Excel conversion, you can download the free trial version here.

Google offers free QuickOffice on iOS and Android

Google trumps Microsoft offering its free office suite on iOS and Android for customers of Google Apps for Business.  While the mobile version of Microsoft Office is not forthcoming, Google decided to fill a void. It offers users of smartphones and tablets running Android and iOS using this free office suite. The only condition, size, is that this offer is only available to customers of Google Apps for Business.

Google has acquired this application in June 2012. Initially, it appeared as a mobile solution for users of the Microsoft Office suite. Quick Office makes it possible to edit on mobile devices files created with Word, Excel or PowerPoint.

In making this offer, Google frontal attack the father of Windows. Rumors evoked the launch of a mobile version of Office for March 2013. In 2012, tests were even mentioned. The Redmond company has quickly denied the rumors. This decision was strongly criticized by financial analysts believe that Microsoft missed an estimated $ 2.5 billion per year income. One of these observers believed there is little that this strategy is a costly mistake.

Excel 2007 convert columns to rows

I am going to share another timesaving tip for Excel. Many time we need to present our data in different way. As a developer I find Excel very convenient to create sample data for my projects and then insert it into the Database. What if we want to re arrange the data which is coming in columns to rows?. Yes, you can easily change data representation row-wise. To do this, copy the data after highlighting it.  After this, right click on the cell where you want to show it.

 

From the shortcut menu select Paste Special , this will show you a dialog box  similar to below image :

Select  Transpose  and press ok button. You will find you column data is arranged row-wise.

You can follow similar steps to convert row data into column layout. This trick should also work with Excel 2010 version.

Software to Export Outlook 2007 contacts, email,tasks appointments etc.

Outlook Data Export is an open source software which allows you to export different kind of data in various formats from Microsoft Outlook 2007.

It allows you to export mails, contacts, appointments, tasks and notes to several file formats (MSG, unicode MSG, RTF, TXT, CSV, ICS, vCard, HTML, XML). You can export a complete folder with subfolders or only selected items. Outlook Data Export works as an Add-In for Outlook 2007.

Download Outlook Data Export

Standalone Word 2007/2010 viewer

DocX Viewer is a handy and convenient tool which can be used to view Word 2007,2010 document without any need of MS Word. This tool is helpful especially when there is no Ms-Word installed on a system and you need to view the content of a docx file.

Features of Docx viewer:

1. Portable. This tool need no installation, you can take it wherever you need to view docx file.
2. Light. This 600KB program can view the files as MS WordViewer which is 50MB of size does.
3. Fast. With Wonder Studio's Direct DocX technology, it works ten times faster than OpenXML Viewer(on Firefox) and much faster than any other docx viewer.
4. Accurate. You will see much more accurate layout and appearance than Google's "view as HTML" and OpenXML Viewer.

Download MS-Word 2007/2010 standalone viewer

How to backup outlook 2007 rules

Outlook rules and alerts are also very important settings which makes your life easy and saves your time.

You can follow below steps to backup outlook 2007 rules:

1. Go to tools menu, click Rules and Alerts
2. This will show up Rules and Alerts Dialog similar to image below.
3. Now, click options button at the top of the dialog.
4. This will show another dialog “Options”.
5. From options dialog click “Export Rules” button.
6. A file save dialog will be displayed to save the exported file. Enter a valid file name and path which you can remember and save it.
7. If you want the rules to be compatible with earlier versions of Outlook, you can select option to do so from “save as type” dropdown. It displays below options :
   • Outlook 2002 Compatible Rules Wizard rules
   • Outlook 2000 Compatible Rules Wizard rules
   • Outlook 98 Compatible Rules Wizard rules
   When you export rules, they are saved in a file with an .rwz extension.
8. You can take backup of this file to a pen drive or whichever medium you prefer. One another option which I use is to email myself into my Gmail account.

 

Picture 1 – Rules and Alerts dialog

Picture 2 – Export Options dialog

Picture 3 – Rules Save dialog

Microsoft Outlook Duplicate Email and Folder Search Add-In

Hana Outlook Folder Search is a free Microsoft Outlook application to help you organize emails. Especially, if you receive many emails and maintain extensive list of email folders, this software will help you find the folder name quickly and reduce the time to manage your emails.

There is another feature ‘Duplicate Email Check and Delete'. So by enabling this function, HOFS will automatically check for duplication whenever there is a new email by checking the Message-ID header and compare it to the other emails in the Inbox received during the last 48 hours. You can easily distinguish and delete such email.

Download Hana Outlook Folder Search v0.2

Sync Gmail contacts with Outlook

SynContact is a free software which can be used to Synchronize contacts between Outlook 2007 and multiple Gmail accounts.  Once you install it, add your gmail target accounts via Tools>Contact Synchorinzation>Sync Settings. Use "Sync Now" to do the contact sync. Additionally there is Resolve Duplicate option to remove duplicates.

Download SynContact : Sync Gmail contacts with Outlook

Automatic backup of Microsoft Outlook Emails

Personal Folders Backup is an Outlook Add-in which can be used to take automatic backup of .PST files. Each .PST file contains all of your Outlook folders, including the Inbox, Calendar, and Contacts.

Backing up your Microsoft Outlook information is quicker and easier with the Personal Folders Backup utility. This add-in supports Outlook Outlook 2007,,2003 and 2002 .

Download  Outlook Backup Add-in for 2007/2003/2002

Open "Open Office" documents with Microsoft Office using ODF plugin

Microsoft Office users can now import and export to Open Document Format. The Sun ODF Plugin for Microsoft Office gives users of Microsoft Office Word, Excel and PowerPoint the ability to read, edit and save to the ISO-standard Open Document Format (ODF).

ODF plugin works with Microsoft Office 2007 (Service Pack 1 or higher), Microsoft Office 2003, XP and Microsoft Office 2000. The ODF Plugin seamlessly integrates with the Load and Save As dialog and the Save (Ctrl+S) shortcut of Microsoft Office Word. A new toolbar in Microsoft Office Excel and Microsoft Office PowerPoint simplifies the import and export of ODF documents.

Download ODF plugin

Turn off Office 2007 Ribbon Menu and Switch to Office 2003 Menu

Most of the people who have just migrated to Office 2007 may feel uncomfortable while using new Office 2007 Ribben menu. So .. Is there a way to switch back to Office 2003 style menu?

Yes ..you can, while using Office 2007 you can have comfort and ease of Office 2003. UbitMenu is a free add-in for MS Office 2007 which provides the option to use MS Office 2003-style interface alongside Office 2007’s "Ribbons" style interface. It is installed as an additional menu in Office 2007 applications (Excel, Word, and PowerPoint), allowing for switching back and forth at will between the older and newer style interfaces.

Download UbitMenu

How to open .WPS file on Mac

.WPS file is created by Microsoft Works. If you do not have Microsoft Office installed you can use Open Office for Mac. Open Office is compatible for almost all the main document types created by Mictosoft Office.

To download OpenOffice for Mac Visit http://www.openoffice.org/index.html

If you are using Windows OS and you do not have Microsoft Office installed, there is a free viewer Word Viewer 2007 available for download from Microsoft website.

Save as PDF or XPS Add-in For Ms-Office 2007

"Save as PDF or XPS" - This Add-in allows you to save Ms-Office documents to PDF or XPS files. It also allows you to send as e-mail attachment in the PDF and XPS formats in a subset of these programs.

The Add-in is designed to work with below eight Office Programs

• Microsoft Office Access 2007
• Microsoft Office Excel 2007
• Microsoft Office InfoPath 2007
• Microsoft Office OneNote 2007
• Microsoft Office PowerPoint 2007
• Microsoft Office Publisher 2007
• Microsoft Office Visio 2007
• Microsoft Office Word 2007
  

Download Save as PDF or XPS Add-in for Ms-Office 2007

** You need to have genuine Microsoft Office 2007 to download this software.

Free PDF -> Doc / PDF -> Word Converter

"PDF to WORD CONVERTER" is a free desktop application which allows you to convert your PDF files to DOC format. This program works with almost all PDF versions ( PDF 1.0 - 1.6.)

Key Features:

• Convert PDF to Word and preserve the original layout of your PDF in an editable Word Document.
• Extract text labels, graphics, shapes from PDF file into Word Doc file.
• Convert all the pages, or partial pages of PDF file to Word file.
• Support Adobe PDF 1.0 - 1.6 formats.
• Can automatically open the output Doc file when the conversion is done.
• Several PDF to Word conversion options are available for a better result.
• Convert in a high speed.
• Easy to use software.
• Totally for Free!
  

Download PDF to WORD CONVERTER

Docx to Doc Converter

What if you need to open .docx file and you have an older version of Microsoft Office XP/2003/2000 installed?

By installing the Compatibility Pack in addition to Microsoft Office 2000, Office XP, or Office 2003, you will be able to open, edit, and save files using the file formats new to Word, Excel, and PowerPoint 2007. The Compatibility Pack can also be used in conjunction with the Microsoft Office Word Viewer 2003, Excel Viewer 2003, and PowerPoint Viewer 2003 to view files saved in these new formats.

Download Office Compatibility Pack

Convert OpenOffice Documents to Ms-Office or PDF or Vice-versa

Mediaconverter.org is an free online service which allows you to convert OpenOffice Documents to Ms-Office or PDF documents, a Vice-versa conversion is also supported i.e. you can also convert Ms-Office documents to PDF or OpenOffice documents.

Supported FileFormats are :

• doc to odt
• doc to PDF
  
• xls to ods
• xls to PDF
  
• ppt to odp
• PPT to PDF
  
• odt to doc
• odt to PDF
  
• ods to xls
• ods to PDF
  
• odp to ppt
• odp to PDF
  

Visit mediaconverter.org

Real time multi-user collaboration with WhiteBoardMeeting

WhiteBoardMeeting is Skype Extra and a real time multi-user collaboration software which allows users to draw vector graphics, insert text and images, edit existing objects. All users see eachother creating and editing objects right away. You can have multiple meetings with different user groups at the same time. You can even invite other users after you have prepared the work offline. And all this in WhiteBoardMeeting Basic without having to pay anything. But of course you can buy WhiteBoardMeeting Pro and collaborate without limits. System Requirements:

• Windows 2000, Windows XP or Windows Vista
• .NET framework 2.0 or later
• 400MHz processor with 256MB RAM
• Skype 3.0 or later
• 5 MB free hard disk space
• Mouse or some other pointing device

Download WhiteBoardMeeting 1.2.1.0 for Windows.

Office Compatibility Pack

You can open Office 2007 file formats(.docx,.xlsx,.pptx) with legacy version of Ms-Office i.e Office XP or Office 2003 with Office Compatibility Pack. Office Compatibility Pack is freely available for download from: http://www.microsoft.com/downloads/details.aspx?FamilyId=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en