Panasonic KX-UDS124, Administrator'S Manual

Page: 257 / 292

5.
On the Text Import Wizard - Step 2 of 3 window, select Tab for Delimiters , and then click Next .
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 S-PS
1.
After editing the phonebook entries, click Office Button , and then Save As .
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 S-PS and Microsoft Excel are not always compatible with each
other.
•
For KX-NS1000 users, if you find numbers in the first column of the exported TSV record data, they
are records downloaded from the KX-NS1000 System Phonebook. These files are updated through
the KX-NS1000 automatically so do not modify this data.
Document Version 2013-03 Administrator Guide 257
6.1.2 Editing with Microsoft Excel