After January 3, 2008, all electronically filed reports uploaded to the FEC contain the ASCII 28 value as the field delimiter. The FEC Convert Tools have been created to facilitate the viewing of these reports. The tools provided on this page contain an excel macro (ViewFECfiling.xls) for converting uploaded .fec reports to a MS Excel spreadsheet and a conversion executable file (fs2comma.exe) to convert .fec reports to a comma separated variable (.csv) file.
Downloading data conversion tools
Downloading will open a download session window. Click Save, select the desired location for saving the file (such as your desktop) and start the download.
Using data conversion tools
Viewing ASCII 28 FEC files in Excel
- Ensure Excel Macro Security is set to Medium under Tools : Options : Security Tab : Macro Security from the menu bar.
- Double click the ViewFECfiling.xls file.
- Click the Enable Macro button. A window titled Open will appear.
- Browse for the FEC filing to view within Excel and select it.
- Click the Open button.
- The FEC filing will open in Excel separating the fields into different columns based on the new delimiter (ASCII Character 28).
Note: To save the filing in another format, click the File : Save as option on the menu bar.
Converting ASCII 28 FEC files to .csv files
To convert FEC filings delimited from the ASCII 28 delimiter to .csv file:
- Drag and drop any V6.1 FEC filing onto the fs2comma.exe and a .csv file will be generated.
- Command line usage: fs2comma 123.fec [out.csv]. If the second parameter is specified, that will be used as the output. if not, 123.csv will be the output.