CSV category

Normal Mode

Clears the separated value view mode.

CSV Mode

Selects the CSV (Comma-separated) mode.

TSV Mode

Selects the TSV (Tab-separated) mode.

DSV Mode

Selects the user-defined DSV (Delimiter-separated) mode.

CSV (multiple items)

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

Cell Selection Mode

Toggles the 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 numerical characters 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 numerical characters for the column header.

Toggle Headings (Freeze or Unfreeze Panes)

Sets or resets lines above and columns left of the current cell non-scrollable.

Set Headings (Freeze Panes)

Sets lines above and columns left of the current cell non-scrollable.

Column Heading 0

Resets column headings.

Column Heading 1

Sets the first one line headings and non-scrollable.

Column Heading 2

Sets the first two lines headings and non-scrollable.

Column Heading 3

Sets the first three lines headings and non-scrollable.

Column Heading 4

Sets the first four lines headings and non-scrollable.

Row Heading 0

Resets row headings.

Row Heading 1

Sets the first one column heading and non-scrollable.

Row Heading 2

Sets the first two columns headings and non-scrollable.

Row Heading 3

Sets the first three columns headings and non-scrollable.

Row Heading 4

Sets the first four columns headings and non-scrollable.

Read Only in Column Headings

Toggle the option to make the column headings as read only.

Heading (Popup)

Shows a popup 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).

Fixed Width Columns

Converts the current separated value document to the 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 the visible lines only of the CSV document.

Hide Columns

Hides the selected columns or current column.

Unhide Columns

Unhides the selected columns or current column.

Reset Column Width

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

Align Left

Align text in the selected columns or current column left.

Align Center

Align text in the selected columns or current column center.

Align Right

Align text in the selected columns or current column right.

Select CSV Column without Headings

Selects the current column without headings as vertical selection mode in the CSV document.

Select CSV Column with Headings

Selects the current column with headings as vertical selection mode in the CSV document.

Insert Column Left

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

Insert Column Right

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

Add Column

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

Duplicate Columns

Duplicates selected columns of the CSV document.

Move/Copy Columns

Moves or copies selected columns or the current column of the CSV document to the specified position.

Manage Columns

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

Combine Columns

Combines selected columns of the CSV document.

Split Columns

Splits the selected columns of the CSV document.

Make Number of Columns Same

Makes the number of columns same in a CSV document.

Remove Unnecessary Quotes

Removes unnecessary double-quotes in the CSV documents.

Remove Embedded Newlines in CSV

Removes embedded newlines in CSV documents.

Quote All Cells

Quotes all cells in the CSV document with double-quotes.

Combine Lines

Combines vertical adjacent duplicate cells of the CSV document.

Flash Fill (Cell Selection Mode Only)

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

Transpose

Switches the rows and columns of the CSV document.

Pivot Table

Creates a pivot table in the CSV document.

Unpivot

Converts columns into rows by flattening 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 while in the normal mode to prepare for conversion into the fixed width columns.

Add/Remove Separator

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

Remove All Separators

Removes all the separators while in the normal mode.

Columns/Separators (popup menu)

Shows a popup menu to work with columns or separators.

Edit Cell (Cell Selection Mode Only)

Edits the current cell in the CSV document.

Clear Contents (Cell Selection Mode Only)

Clear 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 of the current cursor position in CSV mode.

Next Cell

Jumps to the next cell in CSV mode.

Previous Cell

Jumps to the previous cell in CSV mode.

CSV (popup menu)

Shows a popup menu to select a CSV mode.