Import online TSV file to HiperSix

by

Want to parse online TSV file and save to HiperSix?

Try Withdata FileToDB, a desktop TSV to HiperSix converter for Windows, MacOS, and Linux, Import cloud TSV to HiperSix, Easy and Fast.

  • Can run in GUI mode, Step by Step, just a few mouse clicks.
  • Can run in Command line, for Scheduled Tasks and Streams.
  • Convert locally and securely, avoid uploading large or private TSV file(s) to online services.

Download Withdata FileToDB Download FileToDB

Import cloud TSV file to HiperSix table

Choose HiperSix and logon.

convert online TSV file to HiperSix table - Choose HiperSix and logon

Click “Wizard – 1 File To 1 Table” at task dialog.

convert online TSV file to HiperSix table - task window

Select “Source Type” with “Url”.

convert online TSV file to HiperSix table - select type

then show the wizard.

1. Input the TSV file URL, and download the file.

convert online TSV file to HiperSix table - download from TSV file URL

2. Open the saved TSV file.

convert online TSV file to HiperSix table - open saved TSV file

3. Config target HiperSix table.

convert online TSV file to HiperSix table - config HiperSix table

4. Set rows options.

convert online TSV file to HiperSix table - summary

5. Import cloud TSV to HiperSix.

convert online TSV file to HiperSix table - convert to HiperSix table

See HiperSix table

convert online TSV file to HiperSix table - view  HiperSix table

Import cloud TSV to HiperSix in command line

Save “TSV to HiperSix” session, then you can:

Set scheduled tasks for importing cloud TSV to HiperSix

You can schedule and automate this converting task by:

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “TSV to HiperSix” conversion.
  2. Set scheduled task for “TSV to HiperSix” conversion.

FAQ


More about Withdata FileToDB – TSV to HiperSix converter

TSV → HiperSix reference

Type mapping

Value kindin TSVin HiperSix
Int1234Numeric(10,0)
Bigint9007199254740993Numeric(19,0)
Decimal1234.56Numeric(p,s)
Float1.234e+10Float
Textunquoted; a tab in the value splits the columnCharacter(n)
Long textunquoted; newlines break the rowMemo
Date2026-09-18Date
Datetime2026-09-18 14:30:00(none)
Binarynot representable(none)
BooleanTRUE / FALSELogical
JSONthe whole JSON value as-is (its own quotes stay)(none)

Dialect differences

TSV is a file format and HiperSix is a database server, so the target has to be told the types the file never carried - the rows below are where the two sides diverge.

Propertyin TSVin HiperSix
port—(file-based)
identifiersRarely used, which is exactly why tabs in data break it—
row limit—(driver dependent)
datesConventional text: 2026-09-18 or 2026-09-18 14:30:00Date (D)
long text—Memo (M)
binaryNot supported - must be encoded—
separatorTab—
encodingNo declaration - UTF-8 works only with a BOM—
typingNone - every field is text—
shapeFlat table, optional header rowTables of rows and columns
ceilingNo formal limit—

No counterpart

  • TSV values of kind Date and time have nowhere to go in HiperSix.
  • TSV values of kind Binary have nowhere to go in HiperSix.
  • TSV values of kind JSON have nowhere to go in HiperSix.

Convert your data online, free

Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.

New to the format? Read what a TSV file is (and how it differs from CSV).