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.
Upload your file
Choose your spreadsheet. E-File Magic detects its structure and opens the appropriate import workflow.
Choose and map
Select the filer and form. Review suggested matches and assign source columns to the required fields.
Preview the result
Review mapped sample rows and the field import plan. Resolve blocking mapping or preview issues.
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.
Recommended reading

Article
1099 CSV Import Errors: Fix Formatting Without Changing Tax Data
Avoid common CSV and spreadsheet formatting problems before you import.
Read the guide- Knowledge baseImport a spreadsheet with your own column names
- Knowledge baseKeep leading zeros in ZIP codes and identifiers
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 namesCan 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 namesWhat 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 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.