How To Create Tab Delimited Files

KB Home   |   How To Create Tab Delimited Files

Main.HowToCreateTabDelimitedFiles History

Hide minor edits - Show changes to markup

August 23, 2019, at 05:39 AM by timg - Cross linking to Batch user import/update page
Added lines 15-17:

It’s also worth checking out the Batch User Import & Update examples if you’re looking to create tsv files for that purpose!

Changed line 21 from:

Keywords: tab delimited file, TSV, tab separated values, Excel tabs, Excel TSV

to:

Keywords: tab delimited file, TSV, tab separated values, Excel tabs, Excel TSV

Added lines 1-18:

(: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

  1. Start with a new worksheet in Excel.
  2. Enter or paste the data into the corresponding columns (first field in column A, second field in column B, etc.).
  3. Click File (or the Office Button) → Save As.
  4. Change Save as type: to “Text (Tab delimited) (*.txt)”.
  5. Enter a file name and save the file.

Categories: Administration


Keywords: tab delimited file, TSV, tab separated values, Excel tabs, Excel TSV

Comments

Share your findings and experience with other PaperCut users. Feel free to add comments and suggestions about this Knowledge Base article. Please don't use this for support requests.

Article last modified on August 23, 2019, at 05:39 AM
Printable View   |   Article History   |   Edit Article