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.