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.

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

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 import data from a text file into Microsoft Excel, follow this step-by-step guide: First, create a blank spreadsheet in Microsoft Excel and ensure you have the .txt file on your PC.

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.