AutoCount Excel vs Universal Import Plugin
Which approach is a better fit for your business? Compare spreadsheet preparation, import methods and column mapping before bringing data into AutoCount.

Choose the import method that suits your source data
Both methods help move prepared data into AutoCount. Your best starting point depends on whether the spreadsheet already follows the required format or needs mapping to AutoCount fields.
AutoCount Excel
Useful when your team can prepare rows and columns in the structure required by the available Excel import function.
- Copy and paste prepared spreadsheet data
- Follow required column formats and values
- Confirm import types supported by your version
Universal Import Plugin
Useful when source headers need a configurable mapping to supported AutoCount fields or the workflow uses file-based importing.
- Load Excel files using configured mappings
- Match source column headers to destination fields
- Use supported lookup rules where configured
AutoCount Excel vs Universal Import Plugin: differences

| What matters | AutoCount Excel | Universal Import Plugin |
|---|---|---|
| Import method | Copy and paste prepared data | Load an Excel file using configured import mapping |
| Column preparation | Use required spreadsheet column structure | Map source headers to destination fields |
| Import coverage | Available master-data and financial import options | Master-data and transaction imports, subject to supported types |
| Lookup requirements | Prepare required codes and values before importing | Configured column searching can help resolve supported references |
| Setup | Confirm template and required fields | Configure and test mappings; advanced lookups may require assistance |
| Good starting point | Data already organised into the required format | Source files requiring more flexible mapping |

Prepare your spreadsheet before importing
Match fields: Align source headings with the corresponding AutoCount fields.
Check references: Review customer, item and other master-data identifiers.
Test samples: Import a small test dataset before committing to a larger file.
Review outcomes: Compare imported data against the source and investigate any errors.
From Excel columns to AutoCount records
These existing screenshots show spreadsheet preparation and the Universal Import interface. Select an image to view the original details.
Watch both import approaches in action
Preserved from the original article: a demonstration of Excel importing and a Universal Import walkthrough.
Import data by Excel
Universal Import Plugin
Questions before you import
Which import tool is better for my company?
Start with your document types and source file format. AutoCount Excel can suit structured data; Universal Import is worth exploring when configured column mapping is important.
Can I reuse my existing Excel file?
Possibly. Check the required fields and values first. Universal Import mapping may connect different source headers, but the data still needs to meet destination requirements.
Will Universal Import correct wrong data automatically?
No. Mapping matches fields; it does not automatically fix incorrect customer codes, dates or amounts. Review samples before importing a full file.
Can AutoCount imports be scheduled automatically?
Scheduling is a separate requirement. Discuss the AutoCount Integrator Plugin and the compatibility of your specific workflow with your consultant.
Choose a practical AutoCount import workflow
Review the Excel import guide and Universal Import guide before selecting a process for your company.
Import checklist
Prepare the source file, confirm supported document types, test mappings and reconcile the results.

