You can export lists and reports from Manager to use in word processing documents or spreadsheets. Rather than export in formats unique to any specific application, Manager makes data available in tab-separated-value (TSV) format. TSV-formatted data can be imported or pasted into virtually all word-processing and spreadsheet programs on the market.
Completed transaction forms, such as sales invoices, expense claims, journal entries, or purchase orders, cannot be exported. These forms are not data files, but presentations of data from files. Customer lists, cash account registers, or fixed asset ledgers, on the other hand, are data lists and can be exported.
Any list or report that can be exported has an Export (X) button at the lower right corner. The X is a number showing how many rows of data will be exported following a row of column headings. The export function preserves any search or sort operations performed on the data prior to export.
Northwind Traders wants to create a spreadsheet of expense claim information to support a monthly management review. The main listing of the Expense Claims tab can be exported. It is sorted according to claim amount by clicking on the
Amount column heading:
Click on the Export (X) button to view the TSV data. Click within the grey data window to select all the data, or click and drag to select only a portion of it. Copy the selected data.
Open a word-processing or spreadsheet document and paste in the data. Depending on your purpose, TSV-formatted data is usually best pasted into a pre-formatted table in a word-processing document. It can usually be pasted into the first cell of a spreadsheet, where it will automatically be parsed into individual cells. (Exact behavior in the destination document depends on your operating system, application, and version. TSV formatting is used by Manager because it is the most flexible.
Functions available in the destination application can be applied to the exported data for analysis or presentation.