# Excel Formating **URL:** \ **Category:** Process Studio\ **Created:** [June 18, 2026, 5:27am UTC](https://community.automationedge.com/t/excel-formating/18061 "2026-06-18T05:27:36Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Shivraj](https://avatars.discourse-cdn.com/v4/letter/s/aca169/32.png) [@Shivraj](https://community.automationedge.com/u/Shivraj)\ **Post date:** [June 18, 2026, 5:27am UTC](https://community.automationedge.com/t/excel-formating/18061/1 "2026-06-18T05:27:36Z")
how to make the templates in excel so that i would get the format that sr no, id, working hrs ---
**Author:** ![madhavibade1](https://avatars.discourse-cdn.com/v4/letter/m/9d8465/32.png) [@madhavibade1](https://community.automationedge.com/u/madhavibade1)\ **Post date:** [September 17, 2026, 6:48am UTC](https://community.automationedge.com/t/excel-formating/18061/2 "2026-09-17T06:48:35Z")
To output your data with a specific, pre-formatted header structure (“Sr No”, “ID”, “Working Hrs”), you need to physically create the template file first and then configure your workflow to use it. Here is how to set it up: **1.Create the Excel Template** :Outside Process Studio. Open Microsoft Excel, type your headers (“Sr No”, “ID”, “Working Hrs”) into the first row, apply any visual formatting you want (like bold text or background colors), and save the file as a `.xlsx` document. **2.Enable Template Option** :File & Sheet Tab. In your **Microsoft Excel Writer** step, check the box for **Use template when creating new files**. Then, specify the exact file path to the template you just saved in the **Template file** field. **3.Prevent Header Duplication** :Content Tab. Since your template already contains the headers, go to the **Content** tab and check **Omit Header** to exclude the workflow from writing its own header row. Use the **Start writing at cell** option (e.g., typing `A2`) to force the data to start writing exactly one row below your template headers. Run a quick test to verify the alignment.