How to Import 1099-NEC Data from Spreadsheet with ezW2 Software
With ezW2 software, you can import 1099 NEC form data from the external .csv file in a few clicks.
If your data is saved as 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.
Step 1: Download the sample data files(optional)
If you need some data to test this import function, you can click here to download 1099-NEC data. You need to unzip the data before testing the import function.
Start ezW2 software. If you have not installed it, you are welcome to download the trial version and test drive it with no obligation.
Step 3: Clear 1099-NEC form List (Optional)
If you have test data, please remove it before you import data data.
Step 4: Import data
You can access this screen by clicking the top menu Current Company->Import W2.
Follow the instructions on screen step by step and import 1099 data.
4.1 Open data file
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.
4.2 Map Part I data
4.3 Map Part II data
4.4 Click the "Test Parse" button to validate data
4.5 Import Data
Step 5: Refresh 1099-NEC list to view, edit and print forms
Troubleshooting
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.
