> ## Documentation Index
> Fetch the complete documentation index at: https://docs.procuros.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Import a CSV into Excel

> A quick 4-step guide to importing Procuros CSV exports cleanly into Microsoft Excel using the Text Import Wizard.

Double-clicking a CSV file often goes wrong — columns get misread, numbers turn into dates, IDs lose leading zeros, and everything lands in a single column. The Text Import Wizard handles it cleanly.

## Step 1 – Open the file

<Steps>
  <Step title="Open Excel">
    Launch Microsoft Excel.
  </Step>

  <Step title="Go to File → Import">
    From the top menu, choose **File → Import**.
  </Step>

  <Step title="Select the CSV file">
    Select **CSV** as the file type and open your file.
  </Step>
</Steps>

<Frame>
  <img src="https://mintcdn.com/procuros-c35f505c/xyBc60r6Kx-3oM12/images/csv-import-step1.jpg?fit=max&auto=format&n=xyBc60r6Kx-3oM12&q=85&s=8d3f7a633a01ff714ab14fdff5fe02f4" alt="Step 1 – Open the file in Excel" width="776" height="1156" data-path="images/csv-import-step1.jpg" />
</Frame>

## Step 2 – Choose the import type

<Steps>
  <Step title="Select Delimited">
    Choose **Delimited** — not "Fixed Width".
  </Step>

  <Step title="Keep start row at 1">
    Leave **Start import at row** set to **1** so the header row is included.
  </Step>

  <Step title="Click Next">
    Click **Next** to continue.
  </Step>
</Steps>

<Frame>
  <img src="https://mintcdn.com/procuros-c35f505c/xyBc60r6Kx-3oM12/images/csv-import-step2.jpg?fit=max&auto=format&n=xyBc60r6Kx-3oM12&q=85&s=44bca741562cc1ba33cbb8e3388a33f3" alt="Step 2 – Choose Delimited import type" width="1184" height="916" data-path="images/csv-import-step2.jpg" />
</Frame>

## Step 3 – Set the delimiter

<Steps>
  <Step title="Tick Comma only">
    Check **Comma** as the delimiter.
  </Step>

  <Step title="Uncheck everything else">
    Make sure **Tab**, **Semicolon**, and **Space** are unchecked.
  </Step>

  <Step title="Keep the text qualifier">
    Leave **Text qualifier** as `"` (double quote).
  </Step>

  <Step title="Click Next">
    Click **Next** to continue.
  </Step>
</Steps>

<Frame>
  <img src="https://mintcdn.com/procuros-c35f505c/xyBc60r6Kx-3oM12/images/csv-import-step3.jpg?fit=max&auto=format&n=xyBc60r6Kx-3oM12&q=85&s=60703b15d7910f60079f9e6e56958049" alt="Step 3 – Set comma as delimiter" width="1166" height="870" data-path="images/csv-import-step3.jpg" />
</Frame>

## Step 4 – Set column formats

<Steps>
  <Step title="Leave columns as General">
    Leave all columns set to **General** — this works for most data.
  </Step>

  <Step title="Click Finish">
    Click **Finish** to complete the import.
  </Step>
</Steps>

<Frame>
  <img src="https://mintcdn.com/procuros-c35f505c/xyBc60r6Kx-3oM12/images/csv-import-step4.jpg?fit=max&auto=format&n=xyBc60r6Kx-3oM12&q=85&s=c40d0ab62066b5c3d62c3b8c98deaed4" alt="Step 4 – Set column formats" width="1158" height="920" data-path="images/csv-import-step4.jpg" />
</Frame>

<Tip>
  For columns with long IDs or numbers with leading zeros (e.g. GTINs, order numbers), click each column **before** hitting Finish and set it to **Text**. Otherwise Excel will truncate the values or convert them to scientific notation.
</Tip>

## Done

Your CSV is now loaded into Excel with columns correctly split and data readable. To save: **File → Save As** and choose **Excel Workbook (.xlsx)**.