4. On the Text Import Wizard - Step 1 of 3 window, click Next.
Note
Regardless of what is selected for File origin, the file will be processed normally if the format is
appropriate.
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.
204 Administrator Guide Document Version 2010.03.15
5.2.2 Editing with Microsoft Excel