Opening your Compustat save

Opening your save file in Excel.
Start up Excel and choose Open.

Make certain that the file type is set tot TXT, and not to cls or clsx (Excel)
Select your file.
The following screen appears.
In the screen there is a list of selectable formats. Choose Windows Ansi or MS DOS (PC-*) being formats from eighties/ nineties.   (see image)

1. Click Next/ volgende



2. Next screen, click Next/ volgende

3. Select the first column en scroll all the way to the right,
Select all columns by giving Shift-Click Command.

Important: Make sure you select the "text box", this prevents Excel from removing any zeros at the beginning or the end of your data.

Press Finish/ voltooien