Skip to Content
TaxPrepareExport and import an Excel workbook

Export and import an Excel workbook

Use the Excel menu in Leadsheet to download the binder workbook or bring an edited workbook back. Imported changes remain a proposal until you review and apply them.

Choose an export

  1. Open Leadsheet.
  2. Open Excel in the ribbon.
  3. Choose Export workbook or Export snapshot.
  4. Check your browser downloads for the Excel file.
ExportUse it for
Export workbookA working copy that keeps formulas.
Export snapshotA record with figures frozen rather than recalculating.

Export access is controlled by your firm. Importing changes also requires permission to edit the leadsheet.

Prepare an edited workbook

Use an .xlsx exported from this binder. Edit leadsheet figures without changing the sheet’s structure. Adding, moving, or renaming a box, heading, row, or column makes that leadsheet ineligible for figure updates from the file.

Other sheets can be imported as custom sheets, including formulas. Charts, pivot tables, and images do not carry across; the import review lists content that cannot be imported.

Review the import

  1. Open Excel → Import workbook….
  2. Choose the edited .xlsx, or drop it into the import panel.
  3. Review how each sheet is recognized.
  4. Choose the action for each sheet.
  5. Open Show changes for the figures you want to inspect.
  6. Resolve competing values and check the summary.
  7. Click Apply.

The review identifies intact leadsheets, leadsheets with changed structure, and custom sheets. Available actions include updating a leadsheet, adding a custom sheet, replacing one of your sheets, or skipping it.

For each changed figure, compare Exported, In file, and In binder now. If another person changed a figure after the export, decide which value to keep. You can exclude individual figures from the import.

Check formulas and shared edits

Keep all binder values and Use all file values apply broad choices to competing figures. Review their scope before using them. Skipping a sheet that another sheet’s formulas refer to can leave broken references; the import review warns about these dependencies.

If the import cannot be confirmed, choose Review again to see the binder’s current values before repeating it. A successful Import applied result reports figures updated and sheets added or replaced.

For a PDF working file instead, see downloading workpapers.

Last updated on