How do I import the itemized call records into Excel?

Step-by-step instructions for 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 using the button CSV export to your hard drive. Then open Microsoft Excel and click the tab Data. Now select on the left side of the screen From Text and then Import data from a text file.

2

Import file

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

3

Set encoding

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

If you are using a Windows operating system, you can 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 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.