E-File Magic

Product information

Prepare an Excel template import

Use the right annual workbook, review its destination and turn spreadsheet rows into filing records.

Illustration of a paper workbook with blank spreadsheet cells, one highlighted column and a blue document tray.
In this guide

Before you start

Match the tax year

Use the annual template for the year you are preparing.

Keep the template structure

Leave sheet names and first-row headings unchanged.

Choose one filer

Standard imports add records to one selected filer.

View all setup requirements
  • This page is available without an account. Upload and launch your workbook inside your signed-in workspace.
  • Use the combined template and set Filing Year in Filer Information. Keep recognized field and form-sheet names; unused sheets and columns can be removed.
  • Standard imports add records to one selected filer. They do not replace existing recipients or submit forms for filing.

From workbook to reviewed records

Follow these five stages, including the separate filing step.

  1. Understand the template workflow

    Select See how it works and read the four steps.

  2. Fill the annual workbook

    Use the combined standard template with the correct Filing Year in Filer Information. Enter one form record per filled row; unused form tabs can be left blank or deleted.

    Keep sheet names and first-row headings unchanged for automatic mapping.

  3. Upload and check the preview

    After signing in, upload the workbook and review the selected or new filer, matching tax year, detected forms, and sample rows.

    Confirm filer and year
    Match the destination filer to the workbook tax year.
    Check detected forms
    Confirm the forms found in the workbook.
    Review sample rows
    Check mapped data before launching.
  4. Launch and review imported records

    Choose Launch Import when ready. Follow progress, check imported counts and any issues, then review the recipient records.

  5. Preview forms and submit separately

    Preview forms and release a filing order separately when the records are ready.

    An import adds records. It does not replace existing recipients or submit forms for filing.

Your workbook has a clear path into reviewed filing records.

Preparing several filers?

Use the separate multi-filer template when each row includes filer details.

Read the multi-filer guide
Page details and controls
Excel templates

Start Filing Now opens account registration. See how it works jumps to the four-step import workflow. The workbook-to-records illustration explains Upload workbook, Review, and Import; enter your data after signing in.

A familiar start

Use one worksheet per form, keep template headings unchanged for automatic mapping, and review imported records in the filing workspace.

From workbook to working records

Use the tax-year template, add data, upload and review the destination and sample rows, then launch and follow progress.

Review before launch

Check the destination filer and year, detected forms, and sample rows. Processing validates records and reports outcomes. Filing requires a separate order.

Guides & answers

Use Recommended reading to open the featured blog guide and two knowledge-base articles selected for this page. Expand Excel templates FAQs for quick answers; follow an article link inside an answer for more detail. Browse the knowledge base opens the full help library, Explore more guides opens the blog, and Talk to Support opens Support. The first question starts open. Each question opens and closes independently with a click or Enter/Space. Related service or import links below the section remain available where shown.

Get started

Start Filing Now opens registration. Talk to Support opens the support page.

Actions and controls
  • Read how the standard template brings form records into one selected filer.
  • Use Start Filing Now to open account registration, or See how it works to jump to the workflow.
  • Open each common question with a click, Enter, or Space; more than one answer can stay open.
  • Follow Spreadsheet & CSV or Multi-Filer Import for a different starting point.
  • Use Talk to Support for help choosing or preparing your import.
  • Use Email support or call 1-877-836-6680 for help choosing an import method. Explore our security opens the security overview.
  • Explore curated blog and knowledge-base articles alongside questions about Excel templates.

If you get stuck

The selected filer has a different tax year.

Select a filer for the workbook year or create a new filer for that year before launching.

My workbook is for several filers.

Select Multi-Filer Import to learn about the separate template with filer details on each row.

I cannot upload on this page.

Select Start Filing Now to create an account, or use Log In in the site header. Upload in your workspace.

More troubleshooting (1)
An answer is hidden.

Select its question. With a keyboard, Tab to the question and press Enter or Space.