Your web browser is not supported You're using Internet Explorer, some features might not work. Please switch to another browser like Chrome, Firefox, or Edge for a better experience.


An official website of the United States government Here's how you know
 **Official websites use .gov**
            
            A **.gov** website belongs to an official government organization in the United States.
 **Secure .gov websites use HTTPS**
            
            A **lock** ( A locked padlock ) or **https://** means you've safely connected to the .gov website. Share sensitive information only on official, secure websites.


Federal Election Commission | United States of America Calendar
           Glossary
          Search
              Search


Menu
      Home
      Campaign finance data
        All data
            Raising
            Spending
            Loans and debts
            Filings and reports
            Candidates
            Committees
            Bulk data
            Campaign finance statistics
        Find elections. Search by state or ZIP code
          Look up contributions from specific individuals
      Help for candidates and committees
        All compliance resources
            Guides
            Forms
            Dates and deadlines
            Trainings
        Learn about electronic filing
          Find and contact your committee's analyst
      Legal resources
        All legal resources
            Advisory opinions
            Enforcement
            Statutes
            Legislation
            Regulations
            Court cases
            Policy and other guidance
        Search across all legal resources
          Search guidance documents
      About
        All about the FEC
            News and announcements
            Commission meetings
            Mission and history
            Leadership and structure
            Reports about the FEC
            Careers
            Working with the FEC
            Contact
        Introduction to campaign finance and elections


- Home
- ›
        Help for candidates and committees
- ›
        Filing candidate reports
- ›
      Data conversion tools

Data conversion tools 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 Download the 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.
 Need help? Get help from the FEC by phone or email


This information is not intended to replace the law or to change its meaning, nor does this information create or confer any rights for or on any person or bind the Federal Election Commission or the public. The reader is encouraged also to consult the Federal Election Campaign Act of 1971, as amended (52 U.S.C. 30101 et seq.), Commission regulations (Title 11 of the Code of Federal Regulations), Commission advisory opinions and applicable court decisions.


About
          Careers
          Press
          Contact
   Privacy and security policy
          Plain language
          No FEAR Act
          Strategy, budget and performance
 Open government
          Protected Voices
          USA.gov
          Inspector General
          FOIA
 OpenFEC API
          GitHub repository
          Release notes
          FEC.gov status


Federal Election Commission
 The FEC's Twitter page
            The FEC's YouTube page Sign up for FECMail


Hide glossary Glossary Search terms