> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://dots.crisp.help/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).

# Algorithm for correctly exporting CSV reports to Excel

In order for the Report to be displayed correctly in the Excel table, you need to make an import, for this, in the excel table, select the cell in which you want to place the data from the text file. On the **Data** tab, in the **Get External Data** group, click **From Text**. In the **Import Data** dialogue box, find and double-click the text file you want to import, then click the **Import** button. Make sure to select "Delimited" and the encoding is **Unicode**. Also, in the **Separator character** area, be sure to check the box next to the options **Semicolon** and **Tab**.



[![](https://storage.crisp.chat/users/helpdesk/website/5622c20188617000/4ed614e4-550f-4b95-b3c6-3ace30_1xrxhf2.jpeg)](https://dots-platform.intercom-attachments-7.com/i/o/337584626/ac0686696d1c71f6609fd93b/K89i4U8DI--UUqkIyl-bEdsa0HpwicS0xzkjAmTI2fAru1rkXNRnrvr9e27KWCfDybQhFxCyrptIEpN2qox0cgvebDdLp4noNlbcZC-uH1mhhP0jT17Nt4u6ZJx9jJUkvxV2Ix0a?expires=1621351581&signature=4d8b02a85ee19a683958d18c3e3503545abc1d3c1cd12f20ceea34c92b098e5b)

[![](https://storage.crisp.chat/users/helpdesk/website/6e3f6d64bd900c00/964c4f08-31f0-4890-8815-96c0cc_1ktecpv.jpeg)](https://dots-platform.intercom-attachments-7.com/i/o/337584628/298fdc7f26c5ff0f460f8723/DBGuFDL9du9_MwrryUwuPYwlcZgAGB0LPPJvKDBxwnJHwX3DIWnPDbuc-bKA3h0Cl_rBRlPHbLyGoe7UIqTrr8FhVwcgg1XDkLZbgdlHrKr6x7ivyIplFm-o34If9n4DR9oY_O7g?expires=1621351581&signature=b3b942e480a1ac19885bb3b67dafd70475179ab51779ee8f079765d52c0ef6ea)



Link to this article: [https://dots.wiki/1028E](https://dots.wiki/1028E)