In Excel 2010, click the "File" tab, click "Save As," and choose "CSV" as the file type. This method will save the topmost worksheet as a comma-separated values file.

Automated Data Entry in Excel. One way businesses can save time and money is using Excel spreadsheets as data tables in which to store customer information, inventory details or other important data.