Withdata Software

HiperSix import multiple TSV files into a single table

Want to import multiple TSV files into a single HiperSix table?

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

Download FileToDB
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Import multiple TSV files into a single HiperSix table

Login to HiperSix -> Choose TSV files -> Set HiperSix table -> Import TSV files to HiperSix table

Choose HiperSix and logon.

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

Select the “TSV” file type.

then show the wizard.

1. Select a folder that constains TSV files.

Support large ( > 4GB ) TSV files.

2. Config first TSV file importing options.

3. Select a HiperSix table and config fields.

4. Preview data will be in HiperSix table.

5. Import multiple TSV files to the HiperSix table.

View imported data in HiperSix table

Import multiple TSV files to HiperSix in command line

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

Set scheduled tasks for importing multiple TSV files 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

What is Withdata FileToDB?
Withdata FileToDB is an ETL software can import TSV data to HiperSix. Download Withdata FileToDB
How long does it take to import TSV data to HiperSix?
FileToDB works fast. It convert millions of rows within a minute.
Is it safe to import TSV data to HiperSix using FileToDB?
Of course! FileToDB import TSV data to HiperSix locally, absolutely safe.
Can I import TSV data to HiperSix on Linux, Mac OS?
Yes, you can. FileToDB has Linux, Mac OS, and Windows version.
Can I import TSV data to HiperSix in command line?
Yes, you can. FileToDB can running in command line, on Linux, Mac OS, and Windows.


More about Withdata FileToDB – TSV to HiperSix converter

See also:

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).