1099FIRE
Import. Print. eFile.

Order Online or Call (480) 460-9311.

 

 

Contact Us |  About Us  |  Blog

  View Cart! | Learning Center Support

Quick Activation! Use the software today.

 

 Home > 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, rather than type it in by hand.  Its easy to do.  Our 1099FIRE software has the ability to import up to 2.5 million records per file, which is the largest file size acceptable to the IRS.

The order of the data for each module along with sample Excel and CSV file formats can be downloaded below:

Order of Data Sample Import (Excel) Sample Import (CSV Format)
1042-S    
1098 1098 Sample.xls 1098 Sample
1098-E 1098-E Sample.xls 1098-E Sample
1098-T 1098-T Sample.xls 1098-T Sample
1099-B   1099-B Sample
1099-C   1099-C Sample
1099-CAP    
1099-DIV   1099-DIV Sample
1099-G    
1099-H    
1099-INT   1099-INT Sample
1099-LTC    
1099-MISC   1099-MISC Sample
1099-PATR    
1099-Q    
1099-R    
1099-S   1099-S Sample
1099-SA    
3921    
3922    
5498    
5498-ESA    
5498-SA    
W-2G    
W-2   W-2 Sample.csv

The state abbreviations used are as follows:

CSV File Format

The data file has to be in a quote encapsulated, comma separated CSV file format.  Common questions with solutions are as follows:

Creating a CSV file is very simple to do using Microsoft Excel.

  • Open your spreadsheet document and go to the File pull-down menu and choose Save As....
  • Change the "Save as type" or "Format" field to read: "CSV (Comma delimited)".
  • Enter a name for the document and click Save.
  • To check the validity of your CSV file, open the new file from a plain-text reading program such as Notepad.

2. The first line is the total number of entries and is NOT contained in quotes.

4. Click Import to read in each line of data.  If you have a really large file, be patient and let the software finishing importing before doing anything new.

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

 
Top

Copyright © 2006-2010 1099Fire
A partnership with National LawForms, Inc. :: LawFirmSoftware :: MedClaimSoftware :: 1003Software