1099FIRE
Import. Print. eFile.

Order Online or Call (480) 460-9311.

 

 

 



Quick Activation! Use the 1099 software today.

 

 1099 software > Support > Import

Import Data

You have data in Excel or some type of spreadsheet and you want to import that data into the 1099Fire software.  Its easy to do.  Our 1099FIRE software has the ability to import up to 2.5 million records per file directly from Excel (.xls, .xlsx), which is the largest file size acceptable to the IRS.  You can also import from CSV file format.

1099FIRE supports Excel 97-2003 binary formats (xls) and Excel 2007/2010 xml formats (xlsx). Supports Unicode and 64-bit platforms.

If you are importing an Excel file, the first row should be the column headers.  The software will automatically detect and count how many rows of data you are using and proceed to import starting from the second row. If you are importing a CSV file, the first row should be the total number of records.  The second row begins your data.

The order of the data for each module along with sample Excel and CSV file formats can be downloaded below.  If you have any questions or difficulty importing, please call support at (608) 444-6575 or by email at support@1099fire.com.

Order of Data CSV, TXT XLS XLSX
1042-S   1042-S (xls) 1042-S (xlsx)
1097-BTC   1097-BTC (xls)  
1098 1098 (csv, txt) 1098 (xls) 1098 (xlsx)
1098-C      
1098-E 1098-E (csv, txt) 1098-E (xls) 1098E (xlsx)
1098-T 1098-T (csv, txt) 1098-T (xls) 1098-T (xlsx)
1099-A      
1099-B 1099-B (csv, txt) 1099-B (xls) 1099-B (xlsx)
1099-C 1099-C (csv, txt) 1099-C (xls) 1099-C (xlsx)
1099-CAP      
1099-DIV 1099-DIV (csv, txt) 1099-DIV (xls) 1099-DIV (xlsx)
1099-G 1099-G (csv, txt) 1099-G (xls) 1099-G (xlsx)
1099-H      
1099-INT 1099-INT (csv, txt) 1099-INT (xls) 1099-INT (xlsx)
1099-K 1099-K (csv, txt) 1099-K (xls) 1099-K (xlsx)
1099-LTC      
1099-MISC 1099-MISC (csv, txt) 1099-MISC (xls) 1099-MISC (xlsx)
1099-OID      
1099-PATR 1099-PATR (csv, txt) 1099-PATR (xls) 1099-PATR (xlsx)
1099-Q      
1099-R 1099-R (csv, txt) 1099-R (xls) 1099-R (xlsx)
1099-S 1099-S (csv, txt) 1099-S (xls) 1099-S (xlsx)
1099-SA 1099-SA (csv, txt) 1099-SA (xls)  
3921 3921 (csv, txt) 3921 (xls) 3921 (xlsx)
3922 3922 (csv, txt) 3922 (xls) 3922 (xlsx)
5498 5498 (csv, txt) 5498 (xls)  
5498-ESA 5498-ESA (csv, txt) 5498-ESA (xls)  
5498-SA 5498-SA (csv, txt) 5498-SA (xls)  
8027 8027 (csv, txt) 8027 (xls) 8027 (xlsx)
8955-SSA 8955-SSA (csv, txt) 8955-SSA (xls) 8955-SSA (xlsx)
W-2G   W-2G (xls)  
W-2 W-2 (csv, txt) W-2 (xls) W-2 (xlsx)
W-2C W-2C (csv, txt) W-2C (xls) W-2C (xlsx)
CA 592   CA 592 (xls) CA 592 (xlsx)

Frequently used abbreviations and codes are as follows:

Common questions with solutions are below:

Excel Questions

CSV Questions

Technical Support

If you still have any problem importing your data into our software, please email or call technical support.  Technical support can be reached by email at support@1099fire.com or by phone at (608) 444-6575.

Please send an e-mail to info@1099fire.com with any comments you might have.

 
Top
Copyright 2006-2013 1099Fire
A partnership with National Software Incorporated.

1099FIRE
7 North Pinckney Street, Suite 240
Madison, Wisconsin  53703
(608) 444-6575