Advanced Spreadsheet & CSV

Your spreadsheet. Your path to filing.

Map the columns in your own XLSX, XLS, or CSV file, review the result, and launch your import. Keep your source layout and give each field a clear destination.

Free to explore.

  • Flexible column mapping
  • Preview before launch
  • Track import outcomes

A better way to file

Your columns. A clear filing destination.

Use your own file

Start with an export or spreadsheet you already maintain. Custom XLSX, XLS, and CSV files use the advanced mapping workflow.

Choose where fields go

Select a destination filer and form, then map your source columns to recipient details and the form’s fields.

Review before you file

Follow import progress, check outcomes and issues, then review recipient details and form amounts in E-File Magic.

How it works

From your file to working records.

  1. Upload your file

    Choose your spreadsheet. E-File Magic detects its structure and opens the appropriate import workflow.

  2. Choose and map

    Select the filer and form. Review suggested matches and assign source columns to the required fields.

  3. Preview the result

    Review mapped sample rows and the field import plan. Resolve blocking mapping or preview issues.

  4. Launch and track

    Launch Import saves your mapping and starts processing. Follow the import directory and review row outcomes.

A sample preview helps check your mapping. Records are validated during import, so review the completed results too.

See it before you import

See where every column goes.

Put source columns beside their destination fields. Check a sample of the mapped data, then use the import plan to understand what will be included.

  • Map common recipient details and form-specific fields
  • Review required fields and source-column assignments
  • Return to mapping to fix issues before launch

Your latest mapping is saved when you launch. Filing remains a separate step.

Guides & answers

A little guidance goes a long way.

Use the file you already have and learn what to check before bringing your forms into the app.

Browse the knowledge base

Spreadsheet & CSV FAQs

Which file formats can I use?

The advanced spreadsheet path accepts XLSX, XLS, and CSV files. E-File Magic inspects the file and opens custom mapping when it does not recognize an E-File Magic template.

Which file types can I import?
Do I need to rename all my columns?

No. Map your existing column headings to the destination fields in E-File Magic. Review any suggested matches, and complete required fields for the selected form before continuing.

Import a spreadsheet with your own column names
Can one mapping cover every form?

Choose the target form for the import. The available fields follow that form and tax year. Changing the form resets form-specific mappings while preserving common recipient mappings. Use the Excel template path when you want separate form worksheets in one workbook.

Import a spreadsheet with your own column names
What if the preview finds an issue?

Review the reported issue, return to mapping when needed, and preview the changes again. A sample preview does not replace validation of every record during import; check final imported and skipped counts and row details.

Does importing submit my forms?

No. Review your import settings and explicitly launch the import. Follow processing, check the results, and review your recipient records. 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.