# Export a workbook or worksheet tab

{% hint style="info" %}
User permission for methods 1 and 2: Budgets & Forecasts\
User permission for method 3: Budgets & Forecasts and Manage Budgets & Forecasts
{% endhint %}

There are different ways to export a workbook or tab. Select the method that best suits your needs. With methods 1 and 2, the data is exported in a format similar to how you view it on the screen. However, if formulas are used to calculate values, they are omitted (only the values are displayed).&#x20;

<figure><img src="https://content.gitbook.com/content/aNH5UMuZXBHuAbFF7nI2/blobs/KI96yyOOCB1ZrjDPpkgO/image.png" alt=""><figcaption></figcaption></figure>

With method 3, the data is exported in an unformatted state (flat file) suitable for importing into other applications, such as your ERP or back into Phocas.&#x20;

<div align="left"><figure><img src="https://content.gitbook.com/content/aNH5UMuZXBHuAbFF7nI2/blobs/JVMRinQj4OtPNM6K2oDg/image.png" alt="" width="563"><figcaption></figcaption></figure></div>

## Method 1: Standard export process <a href="#exportaworkbookorworksheettab-method1-standardexportprocess" id="exportaworkbookorworksheettab-method1-standardexportprocess"></a>

This method allows you to write the name of the export file and determine which tabs are included in the export. By default, all the worksheet tabs are included.

1. Either click the **Export** button in the top right corner of the workbook or click the **Budget** menu > **Export to Excel**.

   <div align="left"><figure><img src="https://content.gitbook.com/content/aNH5UMuZXBHuAbFF7nI2/blobs/fSBUNq7AdfAICg38YbuI/3477373174.png" alt="image-20240508-015642.png" width="149"><figcaption></figcaption></figure></div>
2. Edit the default export name, if required.
3. Determine the worksheet tabs that are included in the export:
   * By default, most tabs are included in the export. If you only want to export one or more specific tabs, click the **Tabs** button then clear the checkboxes of the tabs you do NOT want.
   * If you are a headcount owner or administrator, you have the option to include the data from the Headcount (Input) tab. This option is not selected by default, so if you want this data, click the **Tabs** button and select the **Headcount (Input)** checkbox.

     <div align="left"><figure><img src="https://content.gitbook.com/content/aNH5UMuZXBHuAbFF7nI2/blobs/o5E5V3TK1QuS1eIq0q3z/3150119384.png" alt="" width="272"><figcaption></figcaption></figure></div>
4. Click **Export**. The file downloads to your computer.
5. Click the file to open it in Microsoft Excel.

## Method 2: Quick export <a href="#exportaworkbookorworksheettab-method2-quickexport" id="exportaworkbookorworksheettab-method2-quickexport"></a>

This method allows you to quickly export a whole workbook or a specific worksheet tab, bypassing the standard export process. The name of the export file is automatically generated, based on the name of the workbook and/or tab, as applicable.

To quickly export the whole workbook, open the Main tab, then either click the **Tab** menu or right-click the tab name, then click **Export workbook to Excel**.

<div align="left"><figure><img src="https://content.gitbook.com/content/aNH5UMuZXBHuAbFF7nI2/blobs/beaWllvlUIDJ9asr0JIN/3479011329.png" alt="image-20240508-024117.png" width="181"><figcaption></figcaption></figure></div>

To quickly export a specific tab, either click the **Tab** menu (when the relevant tab is open) or right-click the tab name, then click **Export tab to Excel**.

<div align="left"><figure><img src="https://content.gitbook.com/content/aNH5UMuZXBHuAbFF7nI2/blobs/qDVunnZLyOYoiHSHoyNJ/3478814733.png" alt="image-20240508-023947.png" width="279"><figcaption></figcaption></figure></div>

## Method 3: Export via the publishing process (flat file) <a href="#exportaworkbookorworksheettab-method3-exportviathepublishingprocess" id="exportaworkbookorworksheettab-method3-exportviathepublishingprocess"></a>

This method allows you to export the data from a specific worksheet tab into an XLXS file, which opens in Microsoft Excel. The data is in a basic, import-friendly format, ready to be used elsewhere. If you prefer to export the data in a format similar to how you see it on-screen, use either method 1 or 2 above.

In the bottom right of the worksheet tab, click the **Publish** button, then select **Export to Excel**. Edit the default file name and select the applicable [publishing options](https://docs.phocassoftware.com/budgets-and-forecasts/owner-and-administrator/publish-a-budget-forecast-or-other-worksheet-tab#publish-the-data-in-a-worksheet-tab).&#x20;

<figure><img src="https://content.gitbook.com/content/aNH5UMuZXBHuAbFF7nI2/blobs/s5gIEnhvnY8IGEA0uAPd/image.png" alt=""><figcaption></figcaption></figure>
