To Import Data Instructions: Microsoft Excel 2007 CSV Format

[brid.siriwan]

To Import Data Instructions:
Microsoft Excel 2007 CSV Format

Steps

1. Open Microsoft Excel. Click on the [Office] button. Click on [Open].

ms.png (88.68 KiB) Viewed 5634 times

2. Locate the .txt file in the “Look in:” field. Select files of type: Text Files. Click on [Open].

ms1-1.png (54.31 KiB) Viewed 5634 times

3. Click on the radio button for the Delimited option. Click on [Next >].

ms1.png (20.31 KiB) Viewed 5634 times

[brid.siriwan]

4. Click on the check box for Comma. Click on [Next >].

ms2.png (16.42 KiB) Viewed 5633 times

5. Select all of the fields by highlighting the first field, holding down the [Shift] key, moving the scroll bar all the way to the right, then clicking on the last field. Click the Text radio button in Column data format section. Click on [Finish].

ms3.png (93.18 KiB) Viewed 5633 times

6. Delete the unwanted data (qualifiers, phone, fax, etc.) and blank fields which will not be included in your merged document. Highlight the column(s) to be deleted. (Column B is used here.) Right-click your mouse to see a list of options.
Click on Delete to delete the column(s).

ms4.png (117.43 KiB) Viewed 5633 times

[brid.siriwan]

7. Click the [Office] button. Click on [Save As]. Select Other Formats.

ms5.png (234.97 KiB) Viewed 5633 times

8. Type a file name. Save as type: CSV (Comma delimited). Click on [Save].

ms6.png (11.55 KiB) Viewed 5633 times

9. Click on [Yes].

ms7.png (16.03 KiB) Viewed 5633 times

[brid.siriwan]

10. Click the Office button. Click on Close.

ms8.png (140.44 KiB) Viewed 5633 times

11. Click on [No].

ms9.png (13.66 KiB) Viewed 5633 times

It is done!