How to export data from a pivot table

Last modified: April 7, 2025

You can export data from a pivot table using the Preview window.

To export data in a printing mode:

1. Open the Preview window by doing one of the following:

• On the File menu, select Print.
• Press Ctrl+P.

2. In the Preview window that opens, select Export Document and choose the desired option file format from the shortcut menu.

3. Depending on the chosen file format, the corresponding [File_format] Export Options window opens, where you can specify export options.

The following screenshot displays the CSV Export Options window.

4. In the [File_format] Export Options window, select OK to save the changes.

5. In the Save As window that opens, specify the location of the file and its name and then select Save to save the file.

The following screenshot displays the exported data from the pivot table in a .csv file format.