How to import call detail records into excel

How to download and import sipgate Call Detail Records (CDR) in CSV format into Microsoft Excel with proper formatting.

You can easily download your Call Detail Records (CDRs) in CSV format for further processing in Excel. Here's how to do it:

• Save the CSV file to your hard drive by clicking the CSV Export button.

• Open Microsoft Excel and go to the Data tab. On the left-hand side, select From Text, then choose Import Data from a Text File.

• Next, select the saved CDR file and confirm your choice by clicking Import.

• To ensure special characters and umlauts are displayed correctly, set the file origin to 65001: Unicode (UTF-8) in the next step, then click Next.

• Choose the Semicolon delimiter option so the values are properly placed into separate columns. Enter Semicolon under Delimiter Options and save the changes.

If you're using a Windows operating system, follow these steps: Data ➔ Get Data ➔ From Text (Legacy) ➔ Select CSV File ➔ Add Delimiters ➔ File Origin (Unicode UTF-8) ➔ Next ➔ Semicolon Delimiter. Newer versions may allow importing the file as CSV with PowerQuery.

Important: Click on the Caller row and set the data format to Text. Repeat this step for the Phone Number and Cost columns.

Once you click Finish, your imported CDR data will be correctly displayed with the corresponding information.