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.

  1. Get your template

    Start with the E-File Magic workbook for your tax year. Use its Read Me and Field Guide for help.

  2. Add your data

    Fill in the worksheets for your forms. Keep the headings and leave unused sheets and rows blank.

  3. Review the import

    Upload your file. Choose or create a filer, confirm the year, and review detected forms and sample rows.

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

Browse the knowledge base

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 workbook
Can 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 names
Can 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 workbook
Will 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 delivery

Still have a question? Talk to Support

Prepare with confidence

Your next filing starts with your data.

Start online, or talk with our team about your import.