Withdata Software

Import CSV into HiperSix

Want to import data from CSV file to HiperSix?

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

Download Withdata 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 data from CSV file to HiperSix

Login to HiperSix -> Choose CSV file -> Set HiperSix table -> Import CSV to HiperSix

Choose HiperSix and logon.

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

Select the “CSV” file type.

then show the wizard.

1. Open a CSV file.

Support large ( > 4GB ) CSV file.

Here is the file’s content.

2. Select a HiperSix table and config fields.

3. Preview data will be in HiperSix table.

4. Import CSV data to HiperSix.

View imported data in HiperSix table

Import CSV to HiperSix in command line

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

Set scheduled tasks for importing CSV to HiperSix

You can schedule and automate this “CSV to HiperSix” conversion task by:

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

FAQ

What is Withdata FileToDB?

Withdata FileToDB is an ETL software can import CSV data to HiperSix. Download Withdata FileToDB

How long does it take to import CSV data to HiperSix?

FileToDB works fast. It convert millions of rows within a minute.

Is it safe to import CSV data to HiperSix using FileToDB?

Of course! FileToDB import CSV data to HiperSix locally, absolutely safe.

Can I import CSV data to HiperSix on Linux, Mac OS?

Yes, you can. FileToDB has Linux, Mac OS, and Windows version.

Can I import CSV 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 – CSV to HiperSix converter

See also:

CSV → HiperSix reference

Type mapping

Value kindin CSVin HiperSix
Int1234Numeric(10,0)
Bigint9007199254740993Numeric(19,0)
Decimal1234.56Numeric(p,s)
Float1.234e+10Float
Textquoted only when it contains a comma or a quoteCharacter(n)
Long textmust be quoted; line breaks inside force multi-line recordsMemo
Date2026-09-18Date
Datetime2026-09-18 14:30:00(none)
Binarynot representable - base64 or hex string(none)
BooleanTRUE / FALSE, or 1 / 0 depending on the writerLogical
JSONthe whole JSON value quoted, with internal quotes doubled(none)

Dialect differences

CSV 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 CSVin HiperSix
port—(file-based)
identifiersDouble quotes; a literal quote is doubled ("" )—
row limit—(driver dependent)
datesConventional text: 2026-09-18 or 2026-09-18 14:30:00Date (D)
long text—Memo (M)
binaryNot supported—
separatorComma ","—
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; row count bounded by memory—

No counterpart

  • CSV values of kind Date and time have nowhere to go in HiperSix.
  • CSV values of kind Binary have nowhere to go in HiperSix.
  • CSV 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.