CSV

EmEditor makes it convenient for you to edit different delimited formats, especially comma-separated values (CSV) files. When open a CSV file, all the separators line up vertically. You can quickly edit the document using the CSV/Sort toolbar, which includes commands like Sort by Multiple Columns, Extract ColumnsLine Number, Ruler, and Heading. Furthermore, the versions after EmEditor v14.6 has enhanced the CSV features and give you more options to customize any CSV document:

  • You can define up to 64 CSV formats, and each format now allows up to 39-character long text.
  • You can easily filter any CSV file through the Filter toolbar. The Advanced Filter dialogue box allows you to specify filter strings and conditions for each column. Furthermore, you can simply click the Negative button on the Filter toolbar to exclude the matched lines.
  • The Join CSV feature allows you to merge two CSV documents specifying key columns, using a method analogous to SQL JOIN operations (INNER JOIN, OUTER JOIN, RIGHT JOIN and LEFT JOIN).
  • Have embedded newlines in your CSV document? No problem! You can select the Remove Embedded Newlines command on the CSV/Sort toolbar to quickly remove the embedded newlines. You can also use the new Match Only Embedded Newlines in CSV option in the Find dialog box as well as the Find toolbar to find, replace, and remove newlines.
  • Want to mark all the duplicate lines in your file? The Delete Duplicate Lines dialog box can help you set bookmarks for duplicate lines without deleting them. You can also apply the command to all documents in a group.
  • EmEditor v17.2 added the AutoFill feature in the CSV cell selection mode. The AutoFill feature allows you to drag the bottom right corner of the selected cell border (AutoFill handle) to copy the same value as the selected cell to the up, down, right, or left neighboring cell(s). If multiple cells are selected and those cells contain values including serial numbers, those values can be easily extended by dragging the AutoFill handle. Double-clicking the AutoFill handle while the selected cell is at the top of the CSV document, the above behavior can be applied to the entire column of the document.
  • Added the Flash Fill command. Selecting the Flash Fill command while in the CSV cell selection mode causes EmEditor to compare the current cell with other columns, and fills the current column with data if it finds an apparent pattern.
  • EmEditor v21.4 added a set of new data-analysis commands—Transpose, Pivot Table, and Unpivot—used for CSV documents. The Transpose command simply switches the rows and columns of a CSV document. The Pivot Table finds all distinct values for a specified column, and for each distinct value, the command counts the occurrences or calculates the total values in another specified column. The Unpivot command is the reverse of the Pivot Table command. They are simple enough to use even if users aren’t familiar with them. For instance, Each option of the Pivot Table dialog box is placed visually as the actual location of a pivot table. These commands can be recorded to a macro, which you can reuse later for repeated use. They are optimized for speed, and allow you to analyze big data more quickly while you deal with CSV files. The Sort toolbar includes these buttons for Transpose, Pivot Table and Unpivot commands.