> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.profitario.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Edit CSV File using Microsoft Excel

1. Download the template file with the Download Template Menu. If you don't know which template to choose [click here](/en/article/which-template-should-i-choose-to-upload-a-csv-file-wpzp1v/).

2. Open the file in Microsoft Excel. You will see a list like this:

![](https://storage.crisp.chat/users/helpdesk/website/5efc78d30dbaec00/image_1kwm4c7.png)

3. Convert the rows into indivdual columns.
First select to whole column of A by clicking on the Column named A
Then click on Data and choose 'Text to Columns'

![](https://storage.crisp.chat/users/helpdesk/website/5efc78d30dbaec00/image_deb6ce.png)

4. This will open the _Text to Columns Wizard_
Select **Delimited **in the first step and click Next.

![](https://storage.crisp.chat/users/helpdesk/website/5efc78d30dbaec00/image_1gt632w.png)

5. Select **Comma **to seperate the rows into individual columns.
You should now see individuall rows in the tabel. Reference point 2 in the picture below.
Continue by clicking Next

![](https://storage.crisp.chat/users/helpdesk/website/5efc78d30dbaec00/image_1mjo8ol.png)

6. Since Excel sometimes interprets id's and Costs incorrectly you have to mark every row as **Text ** .
Do this by slecting every Column an change the column data format to **Text**

|| If you do not change the Column Data Format to Text, the import will not interpret the file correctly.

![](https://storage.crisp.chat/users/helpdesk/website/5efc78d30dbaec00/image_1xz9j8l.png)

7. You will now see a table that looks like this:
Learn how to change the data here:

Change data in Productlist template
Change data in Orderlist template


![](https://storage.crisp.chat/users/helpdesk/website/5efc78d30dbaec00/image_1ytu0s7.png)