How to Convert a Collections Batch Download to a .csv file

After you save the file when downloading, open Excel. Once in Excel, follow these steps:

Import a text file by opening it in Excel

You can open a text file that you created in another program as an Excel workbook by using the Open command. Opening a text file in Excel does not change the format of the file — you can see this in the Excel title bar, where the name of the file retains the text file name extension (for example, .txt or .csv).

1. Go to File > Open and browse to the location that contains the text file.

2. Select Text Files in the file type dropdown list in the Open dialog box.

**Here is a screen shot: https://www.screencast.com/t/5kfCmwVESau

1. Locate and double-click the text file that you want to open.

   • If the file is a text file (.txt), Excel starts the Import Text Wizard. When you are done with the steps, click Finish to complete the import operation. See Text Import Wizard for more information about delimiters and advanced options.

**In the wizard that opens, change to delimited, click next. Change to comma, click next, then finish.