6.
On the
Text Import Wizard - Step 3 of 3
window, select all columns in
Data preview
, select
Text
in
Column data format
, and then click
Finish
.
The TSV file will be opened.
Note
•
Phone numbers must be treated as text strings. Otherwise, a "0" at the beginning of a phone number
might disappear when exported.
To save the phonebook data for importing to the cordless handset
1.
After editing the phonebook entries, click
Office Button
, and then
Save As
.
Assign record IDs manually before saving.
2.
Enter a file name in
File name
, and select
Unicode Text
in
Save as type
.
The file will be saved in UTF-16 little endian with a BOM. Fields will be separated by tabs.
3.
Click
Save
.
A message warning you about file compatibility will be displayed.
4.
Click
Yes
.
The file will be saved as a Unicode text file, with the fields separated by tabs.
Note
•
The procedure may vary depending on the software version of Microsoft Excel. Therefore, files
exported and imported between the cordless handset and Microsoft Excel are not always compatible
with each other.
5.2.2 Editing with Microsoft Excel
374
Administrator Guide
Document Version: 2020-04