Halfpricesoft Halfpricesoft
Support Search Cart Sign In
 

1099-misc Form Printing: How to Import Data from .csv file

ezW2 software can print 1099-misc and 1096 forms for recipients on white paper. Red forms are needed for IRS copies. ezW2 can import data from .csv file and print form quickly.
  • If your data is saved in Excel file, you can convert it easily by clicking Excel top menu "File", then click "Save As" to save it as .csv (comma delimited) file.

  • If you saved data in access, sql server or other database, you can export data to .csv file first.

    Sample Files to Test Import Function

    If you need some data to test this import function, you can click here to download 1099 sample data file. You need to unzip the data before testing the import function.

    Followings are the steps to import data

    Step 1: Start ezW2 software.

    Start ezW2 software. If you have not installed it, you are welcome to download the trial version and test drive it with no obligation.
    W2 software

    ezW2 software: SSA Approved. Trusted By Thousands for Two Decades.

  • Print and eFile Form W2, W3, 1099-NEC & 1096 in House.
  • Unlimited Company Accounts! Unlimited Forms!
  • Compatible with Windows 11, 10, 8.1, 8, 7, Vista, XP and other Windows computers.

    • Try it free today. No obligation. No credit card required.

            


    Step 2: Open import data screen

    You can access this screen by clicking the top menu Current Company->Import 1099.


    Step 3: Import data

    If your data file is opened by other application (ie: Excel) now, please close it before you import data with ezW2 software. You cannot open the same file with two applications.


    Follow the instructions on screen step by step and import 1099-misc form data.

    3.1- Select the data file

    3.2 - Map the field for tab I



    3.3 - Map the field for tab II (optional)



    3.4 - Click the "Test Parse" button to validate data

    3.5 - Click the "Import" button to save data into database

    This 1099 data import feature is not available with ezW2 small business version and trial version. If you purchased the small business version, you can contact us to upgrade your version.

    Note

    1. Form 1096 will be generate automatically based on form 1099 information

    2. ezW2 allows user to set up unlimited companies with one flat rate. So if you have multiple companies or you are an accountant, you can add new company by clicking top menu "Company Management->New company"

    3. The .csv file data import feature, PDF print feature and efile feature are available with Enterprise version and Multiple-user version. They are not available with small business version. Click here to view ezW2 feature list)

    Trouble Shooting

    1. Access Violation Error
    Solution: If your data file is opened by other application (ie: Excel) now, please close it before you import data with ezW2 software. You cannot open the same file with two applications. Please restart ezW2 and try it again.

    2. Other errors
    Solution:
    1. Please download our sample data files and test the import function.

    2. If our sample data file works, you can add a few rows of your data and import data again.

    3. Then add more data the file and import data

    Still have questions?

    help image If you have still have questions, you can also check the FAQs page or contact us at support page. We are glad to assist you as soon as possible.

    Related Links

    W2 W3

    1099-nec, 1096 (For ezW2 latest version)

    W2C, W3c

    More Forms