Excel Templates
From Excel to
1099 filing.
Use an E-File Magic workbook to bring recipient and form data into one review, filing, and delivery workflow.
Free to explore.
Automatic template mapping
Your template structure is recognized.
Review before import
Check the destination and preview rows.
One filing workspace
Prepare, file, and deliver from one place.
A better way to file
A familiar start. A more organized finish.
Built for your forms
Use the worksheet for each form you need, including 1099-NEC, 1099-MISC, and more. Each filled row is one form record.
Less manual mapping
Keep the template’s sheet names and column headings. E-File Magic recognizes the layout and maps those fields for you.
Review in one place
After import, check recipient details, form amounts, and validation issues in your filing workspace before releasing an order.
How it works
From workbook to working records.
Get your template
Start with the E-File Magic workbook for your tax year. Use its Read Me and Field Guide for help.
Add your data
Fill in the worksheets for your forms. Keep the headings and leave unused sheets and rows blank.
Review the import
Upload your file. Choose or create a filer, confirm the year, and review detected forms and sample rows.
Launch and follow progress
Choose Launch Import. Follow processing in the import directory, then review imported records and any issues.
Use the template for the tax year you are filing. The workbook and destination filer must use the same year.
Review with confidence
Review the details. Then launch your import.
Confirm where your data will go before processing starts. The preview helps you check the workbook; validation continues as records are imported.
- Confirm your destination filer and tax year
- Check detected forms and sample recipient rows
- Follow imported counts and records needing attention
Guides & answers
A little guidance goes a long way.
Get your workbook ready and understand how templates bring your records into E-File Magic.
Recommended reading

Article
1099 CSV Import Errors: Fix Formatting Without Changing Tax Data
Prepare dates, identifiers and amounts without changing the meaning of your data.
Read the guide- Knowledge baseImport recipients from an Excel workbook
- Knowledge baseImport forms for several businesses from one workbook
Excel templates FAQs
Which tax year should I use?
Use the E-File Magic template for the tax year you are preparing. An existing destination filer must have the same tax year as the workbook. You can also create a new filer from the import review and complete its required details before launching.
Import recipients from an Excel workbookCan I use my own spreadsheet?
Yes. The Advanced Spreadsheet & CSV path lets you map columns in your own XLSX, XLS, or CSV file. For automatic template mapping, keep the E-File Magic worksheet names and first-row headings unchanged.
Import a spreadsheet with your own column namesCan I import for several filers?
The standard Excel template imports into one selected filer. Use the separate Multi-Filer Import template when your workbook includes filer information alongside recipient and form data on each row.
Import forms for several businesses from one workbookWill importing replace my existing recipients?
No. This template import adds recipient records; it does not replace existing recipients. Check your destination and the records you have already imported before launching the same data again.
Will importing a revised spreadsheet replace my saved forms?Will uploading a file submit my forms?
No. Uploading opens the import review. You choose Launch Import to begin processing, then follow progress and review imported records or issues. Previewing forms and releasing an order for filing and delivery are separate steps.
Submit your forms for filing and deliveryStill have a question? Talk to Support
More ways to bring your records
Prepare with confidence
Your next filing starts with your data.
Start online, or talk with our team about your import.