Exporting Your Outline to a Spreadsheet

If you want the nice columns like the ones you see in the Outliner, you can export your outline for use in a spreadsheet program (for example, Apple Numbers or Microsoft Excel). Just follow these steps:

1. Display the desired container or selection of files in the Outliner.

I describe how to do this step in the section “Accessing the Outliner,” earlier in this chapter.

2. Choose FileExportOutliner Contents as CSV.

The Export window opens.

3. Enter a filename in the Save As text box, and navigate to the desired location in the column at the left.

4. In the Format drop-down list, choose the desired format.

You have these options:

Comma Separated Values (CSV): The standard option recognized by most spreadsheet programs. It creates a text document with each value separated by a comma and each item on a new line.

Tab Separated Values (TSV): Creates a text document with tabs between each value and each item on a new line.

Semi-Colon Separated Values (TXT): Creates a text document with semicolons between each value and each item on a new line.

5. From the Text Encoding drop-down list, select the desired encoding type.

Unicode (UTF-8) is the default, and the standard.

6. To view only the columns you currently have visible in the Outliner, make sure the Only Include Columns Visible in Outliner check box is selected.

If the box is unchecked, the output includes all columns.

7. Click Export.

The file is saved to the location ...

Get Scrivener For Dummies now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.