# Excel Import

Importing attendance data into an Excel sheet involves transferring attendance records from an external resource. The import feature lets you import attendance of a day, week, or month altogether. Importing the data involves three steps:

* Export Data
* Edit the Data
* Import Data

<div align="left"><figure><img src="/files/cYCsYjEPtm1s86gSBvxb" alt=""><figcaption><p>Export Data</p></figcaption></figure></div>

**Export Data**

To get started with Excel Import, go to Attendance > Monthly Attendance and click '**Export Data'** on the right corner of the screen.

You will be directed to the **Export Attendance** screen to select Location, Cost Center, and Department and click the **'Export'** button as shown below:

<div align="left"><figure><img src="/files/qyy5H85czNWSOT17u1Qt" alt=""><figcaption><p>Export Attendance</p></figcaption></figure></div>

Once you export the Excel sheet, you can see Code, Employee Name, Dates columns, and Leave Types. You can edit the exported Excel sheet and make the changes.

<div align="left"><figure><img src="/files/5t55ZGQ5upNakXpp2NNH" alt=""><figcaption><p>Exported Excel Sheet</p></figcaption></figure></div>

**Editing the Exported Excel Sheet**

* **Importing Attendance** - You have the option to import the attendance for a day or a week by keeping the columns related to that and deleting the remaining ones.&#x20;
* **Deleting and Adding the new Columns** - You should not delete columns **A, B, and C** as they contain Serial Number, Code, and Employee Name details. Additionally, you should not add any new columns in the sheet.&#x20;
* **Deleting the Rows** - **Row 1** contains all the Column Names, so Row 1 should not be deleted.
* **Half Day Attendance** -If you want to mark **'Half Day'** attendanc&#x65;**,** you can write it as **P/A** as shown in the Excel sheet below:

<figure><img src="/files/RwjJO03IzobT5Dv8orDh" alt=""><figcaption><p>Excel Sheet showing P/A for Half Day</p></figcaption></figure>

**Import Data**

Once all the edits are made, you can Import the Data by clicking the **'Import Data'** button on the extreme right corner of the screen.

<div align="left"><figure><img src="/files/fc5oq6NGiwSOKqySqqrb" alt=""><figcaption><p>Import Data</p></figcaption></figure></div>

You will be directed to the **Import Attendance** screen, where you can choose your file to attach, and select attendance Types to Import as shown in the image below;

<div align="left"><figure><img src="/files/OWbZbL05NqiLhzoM4hW2" alt=""><figcaption><p>Import Attendance</p></figcaption></figure></div>

Click the '**Import'** button, and all the data will be imported.&#x20;

When we are importing the attendance using an Excel file, the system will ignore the time punches and attendance and will consider the changes made in an Excel sheet.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.runtimehrms.com/attendance-and-leaves/attendance-types/excel-import.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.