CSV category

Normal Mode

Exits separated value view mode.

CSV Mode

Switches to CSV (comma-separated) mode.

TSV Mode

Switches to TSV (tab-separated) mode.

User-Defined DSV Mode

Switches to user-defined DSV (delimiter-separated) mode.

CSV (multiple items)

Shows the document as the specified separated value mode (multiple items).

Cell Selection Mode

Toggles cell selection mode in CSV documents.

Hide Quotes Temporarily

Temporarily shows the current CSV document without quotation marks or escape characters.

Column Header

Shows or hides the column header.

Use One-Based Numerical Characters for Column Header

Uses one-based numbering for the column header.

Use Alphabetical Characters for Column Header

Uses alphabetical characters for the column header.

Use Zero-Based Numerical Characters for Column Header

Uses zero-based numbering for the column header.

Toggle Headings (Freeze or Unfreeze Panes)

Freezes or unfreezes panes above and to the left of the current cell.

Set Headings (Freeze Panes)

Freezes panes above and to the left of the current cell.

Column Heading 0

Unfreezes panes.

Column Heading 1

Freezes the first line as headings.

Column Heading 2

Freezes the first two lines as headings.

Column Heading 3

Freezes the first three lines as headings.

Column Heading 4

Freezes the first four lines as headings.

Row Heading 0

Unfreezes row headings.

Row Heading 1

Freezes the first column as row headings.

Row Heading 2

Freezes the first two columns as row headings.

Row Heading 3

Freezes the first three columns as row headings.

Row Heading 4

Freezes the first four columns as row headings.

Read-Only in Column Headings

Toggles the option to make column headings read-only.

Heading (Pop-up Menu)

Shows a pop-up menu to set headings.

Convert to CSV (multiple items)

Converts the current separated value document or fixed width column document to the specified separated value document (multiple items).

Convert to Fixed-Width Columns

Converts the current separated value document to fixed-width columns using the current separator positions.

CSV Converter

Shows or hides the CSV Converter.

Adjust Separator Positions (Whole Document)

Adjusts all separator positions in the CSV document.

Adjust Separator Positions (Visible Lines Only)

Adjusts separator positions in visible lines only in a CSV document.

Hide Columns

Hides the selected columns or the current column.

Unhide Columns

Unhides the selected columns or the current column.

Reset Column Width

Resets the width of the selected columns in a CSV document.

Align Left

Aligns text in the selected columns, or the current column, to the left.

Align Center

Centers text in the selected columns, or the current column.

Align Right

Aligns text in the selected columns, or the current column, to the right.

Select CSV Column without Headings

Selects the current column (excluding headings) in vertical selection mode.

Select CSV Column with Headings

Selects the current column with headings in vertical selection mode.

Insert Column Left

Inserts a new column to the left of the current column in a separated value document.

Insert Column Right

Inserts a new column to the right of the current column in a separated value document.

Add Column

Adds a new column to the right of the last column in a separated value document.

Duplicate Columns

Duplicates the selected columns in a CSV document.

Move/Copy Columns

Moves or copies selected columns, or the current column, to the specified position in a CSV document.

Manage Columns

Moves, copies, deletes, or sorts columns in the CSV document.

Combine Columns

Combines selected columns in a CSV document.

Split Columns

Splits the selected columns in a CSV document.

Make Number of Columns Same

Makes the number of columns the same in a CSV document.

Remove Unnecessary Quotes

Removes unnecessary double quotes in a CSV document.

Remove Embedded Newlines

Removes embedded newline characters in CSV documents.

Quote All Cells

Encloses all cells in a CSV document in double quotes.

Combine Lines

Combines vertically adjacent duplicate cells in a CSV document.

Flash Fill (Cell Selection Mode Only)

Automatically fills values in the entire column of a CSV document.

Transpose

Swaps rows and columns in the CSV document.

Pivot Table

Creates a pivot table in the CSV document.

Unpivot

Converts columns into rows by unpivoting the CSV data.

Join CSV

Joins two CSV documents.

Extract Columns

Extracts specified columns from the current CSV document.

Automatically Add Separators

Automatically detects and adds separators in Normal mode to prepare for conversion to fixed-width columns.

Add/Remove Separator

Adds or removes a separator at the cursor position (or the position pointed to on the ruler) in Normal mode to prepare for conversion to fixed-width columns.

Remove All Separators

Removes all separators in Normal mode.

Columns/Separators (Pop-up Menu)

Shows a pop-up menu for working with columns and separators.

Edit Cell (Cell Selection Mode Only)

Edits the current cell in a CSV document.

Clear Contents (Cell Selection Mode Only)

Clears the contents of the selection in the CSV document.

Next Cell (Cell Selection Mode Only)

Jumps to the next cell in the CSV document.

Previous Cell (Cell Selection Mode Only)

Jumps to the previous cell in the CSV document.

Cell Above (Cell Selection Mode Only)

Jumps to the cell above in the CSV document.

Cell Below (Cell Selection Mode Only)

Jumps to the cell below in the CSV document.

Right Edge (Cell Selection Mode Only)

Moves to the right edge of the current data region.

Left Edge (Cell Selection Mode Only)

Moves to the left edge of the current data region.

Top Edge (Cell Selection Mode Only)

Moves to the top edge of the current data region.

Bottom Edge (Cell Selection Mode Only)

Moves to the bottom edge of the current data region.

Right Edge Extend (Cell Selection Mode Only)

Extends the selection to the right edge of the current data region.

Left Edge Extend (Cell Selection Mode Only)

Extends the selection to the left edge of the current data region.

Top Edge Extend (Cell Selection Mode Only)

Extends the selection to the top edge of the current data region.

Bottom Edge Extend (Cell Selection Mode Only)

Extends the selection to the bottom edge of the current data region.

Select Cell

Selects the cell at the cursor in CSV, TSV, or DSV mode.

Next Cell

Jumps to the next cell in CSV, TSV, or DSV mode.

Previous Cell

Jumps to the previous cell in CSV, TSV, or DSV mode.

CSV (Pop-up Menu)

Shows a pop-up menu to select a CSV mode.