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.

Link to this article: https://dots.wiki/1028E

Updated on: 09/07/2023