How do I import the itemized call records into Excel?

Step-by-step guide to importing sipgate itemized call records as a CSV file into Microsoft Excel.

You can download your data from the itemized bill at any time for further processing in Excel. You can learn how this works in this article

1

Export CSV file

Save the CSV file via the button CSV export to your hard drive. Then open Microsoft Excel and click the tab Data. Now select From Text on the left side of the screen and then Import data from a text file.

2

Import file

Then select the saved itemized bill file and confirm the selection with Import.

3

Set encoding

To ensure that special characters and umlauts are displayed correctly, please set the File origin on 65001 : Unicode (UTF-8) and then click Continue to the next step. Then activate the option Delimiter: Semicolonso that the values are correctly placed in individual columns. To do this, enter a semicolon under Delimiter options Semicolon. and then save the changes.

If you use a Windows operating system, you will find the settings under: Data → Get Data → From Text (Legacy) → Select CSV file → Delimited → File origin (Unicode UTF-8) → Next → Delimiter semicolon. Newer versions can also import the file as CSV with Power Query.

4

Adjust data format

Important: Click the row Caller and then select the data format Text. Repeat this step for the columns a phone number and Costs.

5

Finish import

After you click Finish the imported data from your itemized bill will be displayed correctly with the corresponding data.