Saturday, November 19, 2011

How to Convert Lotus to Excel 2007


1. Open the file you need to convert in Lotus. Click on the 'File' menu button in the top bar then click on 'Save As.' This will open up a save dialog box.
2. In the dialog box, browse folders until you find the location you want to save the file in and rename the file. Click on the drop down menu next to 'Save as Type' and save the file as a .wk1, .wks, or .123 file. These are earlier versions of Lotus files.
3. Download the OpenOffice suite at openoffice.org. OpenOffice is a free set of office productivity programs which includes a word processor, spreadsheet, presentation, database, drawing program and a calculator.
4. Double click on the OpenOffice icon to bring up the launch screen. Click on the button 'Spreadsheet' to open the spreadsheet program.
5. Click on the 'Open' button in the top menu bar (it looks like an file folder). Search for the file you saved, click on it to select it, and then click 'Open' to open the file in OpenOffice.
6. Click on the 'File' menu in the top bar to open a drop down menu. Click on 'Save As' to open the 'Save File' dialog box.
7. Browse though the folders to determine where you would like this file to be saved and rename the file. Click on the drop down menu next to 'Save as type' to bring up a list of acceptable file types. Click on 'Microsoft Excel (.xls).' Click on 'Save.'
8. Open Excel 2007. Click on the Windows icon at the top left of the screen and click on 'Open.' Browse through the folders until you find the file you saved in OpenOffice, click on it to select it, and click on 'Open' to open it in Excel.

Blogger news