Home DOWNLOADS PRICES ORDER Tin Matching Mailers IRS Forms/Pubs Service Bureau Video Help

Excel Imports

To quickly understand Copy and Paste from Excel, download and install the program (it takes 15 seconds, no personal data is requested). Then, open the sample Excel spreadsheet Misc.XLS (located on the C:\ drive in the E200x folder). Copy the top 10 rows of the sample spreadsheet. Bring up 1099Express. Click the Edit Menu then "Paste From Excel by Header Name". Notice the columns are re-arranged to match the 1099 Express grid! For more info, just click Help/Index, Topic 4, inside the 1099Express program.

1099 Express can import 50,000 payee records in less than 1 second. To Copy and Paste from Excel, insert headers in Row 1 to match your columns, like the samples in red below. Headers must be spelled like the 1099Express grid headers. There is no need to re-arrange your spreadsheet manually. Paste by Header Name automatically rearranges your columns to match the 1099 Express grid. For example, both sheets below import the same data, even though the columns are in a different order. If you have a non-used column, just leave the header blank.



1. Select the whole spreadsheet then click Edit/Copy. 
2. Switch to 1099 Express and click Edit/Paste from Excel by Header Name.

This import method works instantly, even with thousands of records. Try this method now. Just download and install 1099 or W-2 Express now (see Help/Index Topic 4, and the sample spreadsheet called Misc.xls).
 1099 Express can import other formats supported by Excel, including Quickbooks, Access, Dbase, fixed and delimited text files, and many other formats that can be opened with Microsoft Excel.

Note: Importing is designed to avoid re-typing data, which can be exported from an accounting or other system. If you plan to type your records from scratch, you may still use Excel. However, you may also use 1099Express which will validate each record as it is typed.


A dba of NetSoft Marketing, Inc.
Copyright © 1099 Express™ 361 884-1500.

Home DOWNLOADS PRICES ORDER Features Laser Forms Service Bureau Contact Us
Excel Imports IRS Forms/Pubs IRS E-File FAQs IRS Quality Certificate Last Year Activate Program Other Links