O'Reilly logo

Scrivener For Dummies by Gwen Hernandez

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required