Delimit Features

Open files which Excel cannot open; up to 2 billion rows large and GBs in size. Open them much faster than Excel; over 1 million rows/second, multiple files at a time. Open character delimited, text delimited, fixed column width or plain text files. Open them via the Delimit menu, by drag-and-drop into Delimit or with Windows 'Open with'.

Save the current file under same or new name and/or with different delimitation.

Change the way the file is delimited, for example from CSV to TAB or vice versa and/or change the line endings of the file, one of: Windows (CRLF), Unix/Linux (LF) or Other (CR).

Have Delimit automatically detect the delimiter of a file and assign it to the file, based on customizable delimitation rules under Settings.

Manually assign a delimitation rule (delimiter) to the currently opened file if no appropriate delimitation rule is defined under Settings or if the file's delimitation varies, from row to row, by too much.

Edit the currently selected cell. Editing is done within the edit bar located right below the main menu. Hit enter or tab to commit the edit to the currently selected cell.

Restore original cell content, from when the file was last saved.

Restore original file content, from when the file was last saved. This will undo all editing, copy/pasting, replacing, inserting and deleting of columns and rows.

Cut, copy and paste content, from and to different cells, from and to different files. These commands are all internal to Delimit (except for single cell operations) for performance and data formatting reasons.

Copy current selection of cells, columns and/or rows to the Windows Clipboard. Choose to include or not column headers.

Copy current selection of cells, columns and/or rows to a file, i.e. save the current selection to a file. Choose to include or not column headers.

Insert copied columns or rows, or insert empty columns or rows, either left/right or above/below the currently selected column or row respectively.

Delete currently selected columns or rows, shifting left all columns right of the deleted column or shifting up all rows below the deleted row.

Clear contents of all selected cells, columns and/or rows.

Freeze the 1st row of a file, typically because it is the file header row, so that when you scroll the file up and down the header row is always visible.

Automatically resize a single column, a selection of columns or all columns, based on column content for best fit.

Show fixed column widths of columns instead of column numbers, when working with fixed column width files, for easier comprehension of how the file is delimited.

Search for specific text or for specific types of cells like empty cells, throughout the file or throughout a specific range of columns and/or rows. Optionally choose to replace found items with other text.

Have Delimit count and report the number of times the search item occurs throughout the file or within specific range of columns and/or rows.

Jump to and view any cell or any far corner of the file.

Toggle a bookmark on any cell for quick future access to the cell. Click on the bookmark label to edit it and to add a bookmark description or double-click on the bookmark coordinates to jump to the corresponding cell.

Delimit supports Microsoft's Multiple Document Interface (MDI) which allows you to open and work on multiple files at the same time. Each opened file displays in its own tab. If you need to view more than one file at the same time, you can create horizontal or vertical tab groups and assign files to them.

Have Delimit, upon restart, reopen all files that were left open last time you exited the app.

Customize the way Delimit displays the grid and its content. Including: the default cell size, the font to use when displaying text, the color of: the grid background, bookmarks, text, multiline text, cell selections, grid headers, grid lines and virtual cells. You can also adjust the number of rows scrolled for each movement of the mouse wheel.

Split a single column into two columns based on a delimiter within the single column or based on a certain number of characters that should be split out into the resulting two columns.

Join two columns into one column by optionally including a delimiter as the joining character of the content from the two columns.

Quickly reorder all columns, after you have indicated the new column order via the Column Selectors. This method of reordering columns is recommended and significantly more efficient then coping, cutting and pasting columns around.

Split-up a file, either vertically or horizontally, into file parts of equal size. You can split-up the entire file or only a part of it, define the size of each file part and even define how many leading rows or columns to systematically add to each file part.

Split-up a file so that each unique column value and its corresponding row is stored in a separate file. For example, if you have a file that stores records of car sales and a column named "Make", with different car makes, after splitting the file on column "Make" a separate file will be created for each car make.

Join many smaller files, of the same delimitation, into one large file. File joining is opposite of file splitting. Delimit allows you to join files either vertically (one on top of the other) or horizontally (side to side).

Same as 'Join Files', with the added convenience of having the 'list of files to join' prepopulated by all the files currently opened in Delimit. The files need to be delimited the same way and need to have the same number of columns and/or rows.

Join two files into one, on matching column values, similar to an INNER JOIN in SQL. You also have the option to include unmatched rows too, from either or both files.

Extract rows from a file based on a filter expression. The filter expression is constructed using column values, constants, number operators, text operators and logical operators, similar to a query. You also have the option to save your filter expressions for future reuse.

Filter the data of one file based on the data of another file. The comparison is done across all rows of both files, on a single column or a set of columns, whereby rows of the first file are extracted if the data matches the data in the second file. The inverse is also possible; extract rows if data does not match.

Extract every Nth row from a file, similar to systematic sampling. For example, extracting every 20th row will result in a file containing only rows 20, 40, 60, .. etc, of the original file.

Extract any number of random rows from a file, similar to simple random sampling. Optionally instruct Delimit to keep the first row if that row is the file's header row.

Sort a file based on cell content, on up to three columns. Specify either ascending or descending order. Sort data of the following data types: Text, Number, and Date/Time.

Randomize or shuffle the order of all the rows in a file. Optionally instruct Delimit not to shuffle the first row if that row is the file's header row.

Deduplicate a file by specifying a column or a list of columns, on which to base duplicates. Delimit will only compare data from the specified columns when determining if two rows are duplicates. The first instance of a duplicate row is always retained, the other instances of duplicate rows are removed.

Remove rows from one file based on duplicate rows found in another file. Specify which columns to compare, across both files, in order to establish if a row of the first file is a duplicate of a row in the second file.