For Windows users

Export Worksheets to Files

Export a selection of worksheets as separate files, breaking all links to the original file or other external resources.

The Export to Files feature allows you to export each worksheet in the current workbook as a separate file. This can be useful when individual worksheets need to be shared with different people or teams, or when worksheets need to be processed or analyzed separately.

The feature creates a separate file for each worksheet in the workbook, with the filename being the name of the worksheet. The feature provides the option to also break all external links within the exported sheets, ensuring the files are easy to share and don’t need external files to work.

The Export to Files feature can save you time and effort by automating the process of exporting multiple worksheets as separate files.

Save up to 2 hours of mundane work per day

debug formulas up to 5 times faster

More features in this category: