The guide provides insight into how to use the hidden “FILES” function in Excel, a legacy macro function that lists all files in a specified folder.

How to Create Pipe Delimited Files in Excel 2010. Microsoft Excel allows you to export spreadsheet data to a number of common formats for use with other applications.

How to create a CSV file. You can create CSV files in a few different ways. From an Excel spreadsheet. 1. Open your Excel document and click on the File tab. In the menu that appears, select Save ...