When saving an Answerset tab, spreadsheet data is saved using one of the following file types. Text data is saved using one of the file types described under Saving a Query.
| File Type | Description |
|---|---|
| Tab delimited [ANSI] | Any special formatting applied to the Answerset is not saved, but it can be read into a spreadsheet or a text editor for formatting. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. The column headings are saved only if they are visible on the screen. |
| Tab Delimited [Unicode] | Any special formatting applied to the Answerset is not saved, but it can be read into a spreadsheet or a text editor for formatting. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. The column headings are saved only if they are visible on the screen. |
| Tab delimited [UTF-8] | Any special formatting applied to the Answerset is not saved, but it can be read into a spreadsheet or a text editor for formatting. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. The column headings are saved only if they are visible on the screen. |
| Delimited Text [ANSI] |
To set the use of quotes or to set the delimiter between columns, see Setting Export/Import Options. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. The column headings are saved only if they are visible on the screen. |
| Delimited Text [Unicode] | If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. The column headings are saved only if they are visible on the screen. |
| Delimited Text [UTF-8] | If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. The column headings are saved only if they are visible on the screen. |
| Microsoft Excel 2003 |
If there are multiple tabs in the Answerset window, you are asked whether you want to save all tabs to a single ExcelWorkbook. Any special formatting applied to the Answerset is retained. The entire Answerset is saved. Column and row headers are saved if they are currently visible. |
| Microsoft Excel 2007 |
If there are multiple tabs in the Answerset window, you are asked whether you want to save all tabs to a single ExcelWorkbook. Any special formatting applied to the Answerset is retained. The entire Answerset is saved. Column and row headers are saved if they are currently visible. |
| PDF Document [*.pdf] | Any special formatting applied to the Answerset is retained. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. |
| Web Page [*htm] | Any special formatting applied to the Answerset is retained. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. Hidden columns are not saved if you save as HTML.
|
| XML Document | No special formatting is retained. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. See Saving as XML. |