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