<img height="1" width="1" style="display:none" src="https://q.quora.com/_/ad/4f3715cc84e84ae691b8fbf0a0529271/pixel?tag=ViewContent&amp;noscript=1">
Skip to content
English
  • There are no suggestions because the search field is empty.

Data file (.csv) doesn't open correctly on Excel

When you download the call data from the Call Analytics dashboard, it is a .csv file. You can open the file by Excel if you wish, however, the columns might look unorganised. To make them more presentable, you need to follow these simple steps:

Step 1: Open the .csv file with Excel.

Step 2: Select column A.

 

Step 3: Data > Texts to Columns > Finish.