Importing from Microsoft Excel®

Creating The Source File

Figure 4 shows the original spreadsheet with all cells appropriately formatted. Notice that the Zip and Tax ID columns now include the leading zeros. This spreadsheet is now ready to be stripped of all formatting codes and saved as a tab delimited text file.

Figure 4 - Properly Formatted Spreadsheet

Select Save As from Excel's File menu. This will display Excel's Save As dialog. Select Text (tab delimited) from the Save as type drop down list and click the Save button. The following dialog will be displayed,

Reply Yes to have Excel create the desired tab delimited text file. You can now close Excel. If the following dialog is displayed,

reply No. The delimited text file you just created is now a suitable Source file for IMU.