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
- ›
      Importing data into FECFile

Importing data into FECFile The FECFile import feature allows user to import the following data sets into the software: Individuals and organizations (IND/ORG)Schedule A transactions (SA)Schedule B transactions (SB)Schedule H4 transactions (H4) To successfully import a data set, the data set must be formatted properly into an "import format" — an ASCII character (28) delimited text file.
 Download the FECFile import and data format converter. The download will open a download session window. Click Save, select the desired location for saving the file and start the download.Once the zipped file has downloaded and the files extracted, open MSExcel and click File from the menu. Click Open, browse to find the import format spreadsheet in the location where you saved it, and open. The workbook contains a format for the IND/ORG, SchA, SchB, SchH4 and worksheets for each. The workbook also contains a legend (title tabs are on the bottom).Note: One of the files extracted from the zipped download is the Data Converter. Using this tool is explained in the next section.Enter your data into the worksheet. Take note of what fields are importable and what fields are required.Once your data entry is complete, delete the header line in the worksheet. Click File then Save As, and save the worksheet as a comma separated variable (.csv) file.  For example, myfile.csv.
 Converting data to ASCII 28 FECFile requires a special delimiter to separate data fields.  The following steps will convert a .csv text file into an ASCII 28 delimited file. Left click, drag and drop the .csv file onto the Data Converter. Release the mouse button.A new file will appear with the same name, only the extension will be changed to .fs (For example, myfile.fs). This is the ASCII 28 converted file. The file is now ready to be imported by FECFile.
 Importing your ASCII 28 file into FECFile The procedures for importing information from Schedules A, B and H4 differ from importing the individuals and organizations database. Importing Schedules (A, B, and H4) Open the software, load the .dcf file, and click on the Reports icon.Click the report into which the transaction data will be imported. All transactions dates must fall within the selected report’s coverage date range.At the top left of the screen, select Tools then Import Transactions. An Import From window will appear.Locate the import file; highlight it by clicking. Select Open. The Import Window will appear. The import file will have the .fs extention.Click the Startbutton, and your data will import into the software.Note: If your file has duplicate individual or organization entries the Mergewindow will appear. The Mergefeature is discussed in more detail in the FECFile user manual. In short, this tool allows you to merge two like records into one. You can merge the entire record or individual fields. Click the Mergebutton and the left record will be added.Click Ok and take note of the status logging that appears now in your Import Window. Click the Close button and click on the FECFile Save icon to save the imported data and the database. Status logging shows: Import resultsNumber of transactions importedAny errors that occurred during the import process Any transaction that failed the import process must be fixed in the MSExcel .csv file, re-converted to the ASCII .fs file, and re-imported. You must also delete any transactions that were previously imported, as they will create duplicates when re-imported. If a large data set contains many errors, it may be easier to close down FECFile without saving the import and start the import process over once you have corrected the data in the .csv file. Importing individuals and organizations Open the software and load the database.At the top left of the screen, select Tools then Import Names. An Import Names From window will appear.Locate your import file; highlight it by clicking the left mouse button and select Open.  The import file will have the .fs extension.If the file has duplicate entries, the Merge window will appear. The Merge feature is discussed in more detail in the FECFile User Manual. In short, this tool allows you to merge two like records into one.Click the Merge button and the left record will be added. Upon the last entry, the import process is finished, and the Merge window disappears.  The Continue button in the Merge window allows you to skip a particular record and move to the next without the merge occurring.The Individuals/Organizations window should now be open in the software. Confirm that the new entities have been imported. TheIndividuals/Organizations window contains all of the profiles in alphabetical order.Click on the FECFile Save icon to save the imported data and the database. If a large data set contains many errors, it may be easier to close FECFile without saving the import and start the import process over once you have corrected the data in the .csv file. If you have questions regarding importing, please contact the Electronic Filing Office.
 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