|
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:
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.
|
