(:title How To Create Tab Delimited Files:)
(:description Creating tab delimited files for importing data into PaperCut.:)
(:keywords tab delimited file, TSV, tab separated values, Excel tabs, Excel TSV:)
Several data import formats used with PaperCut require a file formatted as TSV (Tab Separated Values). TSV is simply a file where each line has its values separated by tabs. This is similar to the common format CSV (Comma Separated Values). TSV avoids many of the problems associated with CSV, particularly where values may contain commas, and in countries where commas are used as the decimal separator in numbers.
Creating a TSV File With Microsoft Excel
Start with a new worksheet in Excel.
Enter or paste the data into the corresponding columns (first field in column A, second field in column B, etc.).
Click File (or the Office Button) → Save As.
Change Save as type: to “Text (Tab delimited) (*.txt)”.
This release contains an updated Java version which no longer supports 32-bit workstations. If you have any 32-bit users launching the User Client or Release Station from a network share, see this Knowledge Base article for more information.