Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
Cooking Tips
ExcelTips (menu)
ExcelTips (ribbon)
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
School Tips
Wedding Tips
WordTips (menu)
WordTips (ribbon)

Advertise on the
ExcelTips Site

Newest Tips

Showing Filter Criteria on a Printout

Duplicating Drawing Objects

Spreading Out a Table

Renaming a File

Filling References to Another Workbook

Saving Common Formulas

Easily Changing Links

 

Converting from SuperCalc

Summary: The scrapheap of computing history is littered with programs that had their moment in the sun and then fell by the wayside. One such program is SuperCalc, a popular early spreadsheet program. This tip explains different ways you can retrieve data stored in old SuperCalc files. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Those who remember SuperCalc have automatic membership in the "I Remember When" club. SuperCalc was a spreadsheet program designed by Gary Balleisen and published in the early 1980s by a company called Sorcim. (The first edition was for the CP/M operating system.) In 1984 the product was purchased by Computer Associates, and they published it for several years. SuperCalc predates Excel by quite bit.

Many companies and individuals used SuperCalc, and have subsequently standardized on using Excel. If you have some old SuperCalc spreadsheet files laying around, you may be wondering how to convert them to Excel. Current versions of Excel don't include SuperCalc filters; they were last included in Excel 95.

Converting files if you still have SuperCalc installed on a system is a snap--all you need to do is export the SuperCalc workbook in Lotus 1-2-3 format, and then you can import it into Excel. Lotus filters are much more common in the Excel world than many other filters. You could also, if you have Excel 95 installed on an old system, try to do the conversion using that version of Excel, and then load the converted Excel file into a newer version of Excel.

If you have a very valuable file you need to convert, or if you have quite a few files to convert, you might give some thought to using a third-party company to do the conversion. A quick Google search for "SuperCalc conversion" turns up quite a few potential resources for this approach.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2443) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Got the Time? Understanding the ins and outs of working with times and dates can be confusing. Remove the confusion--ExcelTips: Times and Dates is an invaluable resource for learning how best to work with times and dates.
 
Check out ExcelTips: Times and Dates today!