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.

To return the new values to Excel, so you can work with them at the sheet level, click Close & Load in the Close group on the File tab. You can see the new table in Figure H.