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.

Simply convert the input range to a table and Excel will control data input as above – simply press Tab to move from cell to cell, within the table range.