---
title: "Opening CSV files in Microsoft Excel"
canonical: "https://support.appfire.com/space/AIP/10256874/Opening%20CSV%20files%20in%20Microsoft%20Excel"
format: markdown
---
> Macro (aura-html)

This guide explains how to open CSV (Comma-Separated Values) files in Microsoft Excel while preserving the formatting of your data, especially dates and numbers. Following these steps ensures your information remains accurate and usable within Excel.

## Instructions

### For Windows users

**Step 1: Open Your CSV File**

Locate and open your downloaded CSV file by double-clicking on it or using the **Open** option in Excel.

**Step 2: Format Date Fields**

Check if your date fields' format matches your Jira date or date-time format.

> ✅ You can check your Jira date and date-time format in **Import Assets from CSV** page or **General Configuration** page.

If the date fields in your CSV file do not match your Jira date or date-time format:

1. Right-click the column with the date.
2. Select **Format Cells**.

3. Under Category, choose **Custom**.
4. Type your date or date-time format according to your attribute type.
5. Click **OK**.

**Step 3: Adjust Number Fields**

If the Number fields are incorrect:

6. Right-click the column with the number.
7. Select **Format Cells**.

8. Click **Custom** and pick **0**.
9. Click **OK**.

This will fix the CSV file:

![image](media://73e4942b-f8d2-4db8-beba-1c39cafadd93)

### For macOS users

**Step 1: Start with a New Workbook**

1. Open Microsoft Excel and create a new blank workbook.

**Step 2: Import CSV File**

2. Click on cell **A1** to select it.
3. Navigate to **Data** > **From Text/CSV**.

**Step 3: Configure Import Settings**

4. Browse to locate your CSV file and click **Get Data**.
5. In the Text Import Wizard, set **File Origin** to **Delimited** and **Unicode** **UTF-8**.
6. Click **Next**.
7. Choose **Comma** as your delimiter and click **Next**.
8. On the bottom table, select all columns, click **Text**, and then click **Finish**.
9. Click **OK**.

This will fix the CSV file: 

![image](media://d13233fe-3025-45fc-9e34-13644da58dc1)