Importing from Microsoft Excel®

Creating The Source File

Introduction  Previous Topic  Next Topic

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.


Excel Spread Sheet Formatted


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,


Excel Save As Text


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


Excel Exit Message


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