How to export data from Sage 100 into a Delimited File (.CSV)

There are several Methods available to export Sage 100. Here are 3 popular methods:

1. Visual Integrator
   1. In Sage 100, select Export Job Maintenance
   2. Enter a Job Name 15 characters or less
   3. Click the Lookup to select the desired table to export
   4. Choose the File Type “Delimited”
   5. Click the Lookup for the Export File and browse to the desired location where the exported file will be saved
   6. Click the Options button and select “Display Read Only Fields For Export” and then click “Close”
   7. Click Data tab and select desired fields from the Available Fields window by double-clicking the field or clicking the Add Selected Field button
   8. After selecting the desired fields to be exported, click Accept
   9. Click “Yes” to execute the job and click “Accept” to export the data
2. Export from Lookup
   1. In Sage 100, select a Lookup for desired information to be exported, i.e. Click Customer Number Lookup in AR Customer Inquiry
   2. Click “Custom” button in lower left corner
   3. Enter a name of the Custom Lookup and click Enter Key and click Next
   4. Select the desired fields from the Available Fields window by double-clicking the field or clicking the Add button
   5. After selecting the desired fields to be exported, click “Finish”
   6. Select the newly created view in the View Drop-down
   7. Click the Excel button located towards the lower right-corner
   8. Once the data is displayed in Excel, click File, Save As and save the file as type CSV (Comma delimited) (*.csv)
3. Export from Reports
   1. In Sage 100, select a report that contains desired data to export, i.e. AR Customer Listing
   2. Click Preview to preview the report
   3. Click “Export Report” in upper left corner
   4. Click Format drop-down and select Separated Values (CSV) and click OK
   5. Choose desired selections in the Separated Values Export Options if any and click OK
   6. Save the file to a desired location

Note: Visual Integrator is a Sage 100 application which must be purchased. Select Installed Modules Listing in Library Master Reports to check if Visual Integrator is installed. These options may require specific Sage 100 Roles to be executed as described. See your Sage 100 Administrator if these options are not available to you.