How to Convert All Excel Sheets to CSV With Macros. Excel's Save As command lets you save a single worksheet in the CSV (comma seperated value) format, but not an entire workbook. Saving ...

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.