Importing from Microsoft Excel® Overview |
![]() ![]() ![]() |
The primary step in importing an Excel spreadsheet is to save the spreadsheet as a delimited text file. This text file is then opened as the Source file in The Import Mapping Utility ("IMU"). A mapping is then created and executed, resulting in a text file that Account Ability can import.
The following topics illustrate how to create a tab delimited text file from a sample spreadsheet, 1099MISC_EXAMPLE, created with Excel. Although this illustration uses a tab delimiter, one could also use a comma (,) or pipe (|) delimiter.
Topics
|