Keep the original and identify what the workbook depends on
Start with a separate copy. Identify the worksheets, formulas, tables, validations and external dependencies that matter to the result. If the workbook contains VBA, embedded objects or external workbook links, keep the original and prepare a plain XLSX copy without those unsupported features.
Model does not run imported macros. Do not remove a dependency merely to make a file importable without first checking how that changes the calculation.
Use the import report as a decision point
Model supports up to 20 worksheets, 10,000 rows, 256 columns and 50,000 populated cells. The uploaded workbook has a 12 MB limit and additional expanded-archive and saved-document limits. A small compressed file can still exceed a supported limit.
Review every reported conversion or omission. Supported structures include bounded named ranges, table references, literal-value filters, numeric filter comparisons and constant date/time validation. Supported formula-based validation uses the Model calculation engine. External workbook validation, arbitrary named formulas and unsupported Excel objects need a different workflow.
Compare calculations and visibility separately
Check representative inputs, formula text, error cells and the totals used by your report. Confirm that text identifiers retain leading zeroes. Compare date interpretation and number formats where the distinction matters.
A filter hides nonmatching rows without deleting them. SUM includes hidden values. SUBTOTAL excludes filtered rows, and codes 101 through 111 also exclude manually hidden rows. For example, SUBTOTAL(109,B2:B20) sums visible rows. Check the import notice when rows were both manually hidden and excluded by an Excel filter, because the file does not distinguish those reasons.
Finish with a round trip
Export a genuine XLSX copy from Model and reopen it in your spreadsheet software. Inspect the supported formulas, table columns, filter criteria and important values. Keep both the original and the reviewed result until you are satisfied that the supported workflow fits your needs.
Start with a clear workflow
- Keep an untouched original and list the workbook’s important dependencies.
- Prepare a plain XLSX copy and import it into Model.
- Read the import report before accepting the conversion.
- Compare important calculations, identifiers, dates and filters with the original.
- Export XLSX and inspect the result before adopting it as the working file.
Know what to expect
- This workflow does not establish universal Excel or VBA compatibility.
- CSV exchanges tabular values and cannot substitute for a workbook with multiple sheets, formulas and formatting.
- Model table-column insertion and deletion operate on the whole worksheet column.
- External API functions and automatic refresh require actual supported connections; a workbook formula name does not create one.
Common questions
Can I import a macro-enabled workbook directly?
Workbooks containing macros are rejected. Keep the macro-enabled original and use a separate plain XLSX copy only after reviewing the effect of removing its unsupported dependencies.
Why does a filtered total still include hidden rows?
SUM continues to use all referenced cells. Use SUBTOTAL(9,B2:B20) to exclude filtered rows, or SUBTOTAL(109,B2:B20) to exclude both filtered and manually hidden rows. Choose the range and operation that match your intended calculation.
Can a small XLSX file still be rejected?
Yes. XLSX is a compressed archive. Expanded content, worksheet dimensions, populated cells and document size have separate bounds.
