Publish / file · All operations
Write another file format
Write any other file format.
Status
- In arcform
Not built yet
arcform does not do this yet. Its place on the roadmap
- Shape of the result
- the table sent out, with nothing new to look at
- Level
- needs a DuckDB extension
Variants
- Write a BI extract file
Write a table to an extract file a business intelligence product loads, such as a Hyper or QVD file.
- Write binary objects or images
Write the binary content or image held in each row to its own file.
- Write a configuration file
Write rows as key and value pairs or structured settings, such as a properties, INI, TOML or YAML file.
- Write a machine-learning data file
Write a table to a format machine-learning libraries read, such as ARFF, TFRecord or a NumPy array.
- Save in a data tool's own format
Write a table, project or object to the native or serialised file format of a data tool.
- Write rows as SQL statements
Write a file of CREATE TABLE and INSERT statements that recreate the rows in a database.
- Write plain or templated text
Write values, messages or rows laid out by a template to a plain text file.
Write another specialised format
Write a file in a format no other variant covers, such as GeoJSON, SSTable, LDIF, Stata or Markdown.
What other tools call it
Meridian's classification; an independent blind rating agreed on 86.2% of 312 rows (exact class, version 2).
Alteryx Designer (3)
Blob Outputread 2026-09-27Write each record's binary object to its own file
Image Outputread 2026-09-27Save image files to a chosen location
Profile Outputread 2026-09-27Write a profile or collection of profiles to a Profile Set .scd file
Apache Hop (8)
Binary File Outputread 2026-09-27Write a binary field to a file whose name comes from each row
Cassandra SSTable Outputread 2026-09-27Write rows to a directory as Cassandra SSTable files for bulk loading
Data set outputread 2026-09-27Write rows to a reusable data set stored in project metadata
Properties file Outputread 2026-09-27Write key and value pairs to a Java properties file
SQL File Outputread 2026-09-27Write rows to a text file as SQL INSERT statements
Serialize To Fileread 2026-09-27Write rows and metadata to a binary Hop serialised file
Write to fileread 2026-09-27Write or append custom text to a file
vCard Outputread 2026-09-27Build vCard text from fields and optionally write .vcf files
Apache NiFi (1)
FreeFormTextRecordSetWriterread 2026-09-27Write each record as free-form text built with Expression Language
Azure Data Factory (2)
Binary format (sink)read 2026-09-27Write Binary files in copy activity
Common Data Model format (sink)read 2026-09-27Write Common Data Model files in mapping data flow
Duckle (4)
Geospatial (GeoJSON / GeoPackage / ...)read 2026-09-25write GeoJSON, GeoPackage and other spatial files with COPY FORMAT GDAL
Qlik QVDread 2026-09-25write a Qlik QVD file
TOMLread 2026-09-25write rows as TOML under a rows key
YAMLread 2026-09-25write rows as a top-level YAML array
EasyMorph (4)
Export as plain textread 2026-09-27Write one column to a text file, one value per line, unformatted
Export datasetread 2026-09-27Write the table to EasyMorph's native .dset file
Export into Qlik fileread 2026-09-27Write the table to a Qlik QVD file
Export to Tableauread 2026-09-27Write the table to a Tableau Hyper or TDE file, or publish it to Tableau Server or Online
KNIME Analytics Platform (5)
ARFF Writerread 2026-09-27Write a table to a Weka ARFF file
Image Writer (Port)read 2026-09-27Write an image port object to a file
Image Writer (Table)read 2026-09-27Write every image in a column to files in a directory
KNIME Tableau Integration (extension)read 2026-09-27Extension outside the base install: 3 current nodes: Send to Tableau Server; Tableau Reader (Labs); Tableau Writer
Table Writerread 2026-09-27Write a table to a file in KNIME's native .table format
OpenRefine (3)
Export to QuickStatements (version 1)read 2026-09-27Write the edits the schema produces as QuickStatements version 1 text commands
OpenRefine project archive to fileread 2026-09-27Write the whole project, history included, as a .tar.gz archive
SQL statement exporterread 2026-09-27Write a .sql file of CREATE TABLE and INSERT statements with chosen column types
Pentaho Data Integration (5)
ARFF outputread 2026-09-27Write rows to a Weka ARFF file
Properties Outputread 2026-09-27Write key and value pairs to a properties file
SQL File Outputread 2026-09-27Write rows to a file as SQL INSERT statements
SSTable Outputread 2026-09-27Write rows to a directory as a Cassandra SSTable
Serialize to fileread 2026-09-27Write rows to a serialised data cube file
Polars (1)
DataFrame.serializeread 2026-09-27Write a frame to Polars' own serialised form, as a file or string
RapidMiner Studio (11)
Storeread 2026-09-27Save a data table, model or other object into the repository
Store to Fileread 2026-09-27Serialise any process object into a file object
Write ARFFread 2026-09-27Write a table to a Weka ARFF file
Write Documentread 2026-09-27Write a document to a text file
Write Fileread 2026-09-27Write a file object to disk or to the repository as a blob
Write Hyper Fileread 2026-09-27Write a table to a Tableau .hyper extract file
Write Imageread 2026-09-27Write an image to disk
Write Messageread 2026-09-27Write a given text message to a file
Write QVXread 2026-09-27Write a table to a Qlik QVX exchange file
Write Special Formatread 2026-09-27Write rows to a text file using a user-defined line template
Write as Textread 2026-09-27Write the text form of any result objects to a file
Tableau Prep (1)
Hyper Extract (.hyper)read 2026-09-27Write a Tableau extract file; create or append
Talend (5)
tFileOutputARFFread 2026-09-27Write rows to an ARFF file
tFileOutputLDIFread 2026-09-27Write or modify entries in an LDIF file, or delete content from it
tFileOutputPropertiesread 2026-09-27Write key = value pairs to an .ini or .properties file
tFileOutputRawread 2026-09-27Write a single column of incoming data to a file
tQVDOutputread 2026-09-27Write QVD files that can be published to Qlik Cloud
VisiData (23)
dot (saver)read 2026-09-23Save as Graphviz diagram (from pcap)
dta (saver)read 2026-09-23Save as Stata file via pandas
geojson (saver)read 2026-09-23Save as GeoJSON (from shp or geojson)
grep (saver)read 2026-09-23Save as grep JSON Lines
jira (saver)read 2026-09-23Save as JIRA/Confluence table markup
jrnl (saver)read 2026-09-23Save as jrnl CLI journal
md (saver)read 2026-09-23Save as Markdown table
npy (saver)read 2026-09-23Save as NumPy array
org (saver)read 2026-09-23Save as Emacs Org-mode file
png (saver)read 2026-09-23Save as PNG image (from a PNG source)
rec (saver)read 2026-09-23Save as recutils database file
save-allread 2026-09-23Save all sheets on the stack to one file or directory
save-colread 2026-09-23Save current column to a file
save-col-keysread 2026-09-23Save key columns plus current column to a file
save-selectedread 2026-09-23Save selected sheets to one file or directory
save-sheetread 2026-09-23Save current sheet to a file; saver chosen by extension or filetype
save-sheet-reallyread 2026-09-23Save current sheet to its default name without prompting
save-sourceread 2026-09-23Save the root sheet back over its source
table (saver)read 2026-09-23Save as text table (loaders/texttables.py)
txt (saver)read 2026-09-23Save as plain text of the visible column(s)
vds (saver)read 2026-09-23Save as VisiData multi-sheet file with column metadata
xd (saver)read 2026-09-23Save as crossword .xd file
zip (saver)read 2026-09-23Save as zip archive of saved sheets
Yggdrasil Decision Forests (2)
convert_datasetread 2026-09-27Rewrite a dataset from one typed-path format to another using its dataspec
ydf.util.write_tf_recordread 2026-09-27Write an in-memory dataset to a TFRecord file of tf.Example rows
Background
In DuckDB, COPY ... TO writes a table or a query's result to an external file, and its FORMAT option names the copy function that writes it.[1] Out of the box, DuckDB's COPY provides CSV, Parquet and JSON copy functions, and extensions can add further ones.[1] A file format may be standardised, whether proprietary or open, or it may be an ad hoc convention.[2]
When to use it
Some file formats have a published specification, while others are defined de facto by the behaviour of the program that accesses the file.[2] File formats with publicly available specifications tend to be supported by more programs.[2] Reach for one of the less common formats when the program that will read the file asks for it, and otherwise prefer CSV, Parquet or JSON. (Meridian's view)
In DuckDB, COPY ... TO overwrites the destination file if it already exists, without raising an error.[1] By default DuckDB writes to a temporary file first and replaces an existing destination only once the write completes, so an interrupted write does not corrupt the previous file.[1] DuckDB community extensions add functionality to DuckDB and are developed by external contributors, not maintained by DuckLabs.[3] Before a pipeline depends on a format that an extension adds, write a small file and open it in the program that will consume it. (Meridian's view)
The method
A file format may describe the encoding at levels from the low-level bit and byte layout to high-level organisation such as markup and tabular structure.[2] A text file can contain any stream of characters and is encoded in one of various character encoding schemes.[2]
In DuckDB, any file created by COPY ... TO can be copied back into the database by using COPY ... FROM with a similar set of options.[1]
Sources
- [1]COPY Statement – DuckDBdocumentation
- [2]File format - Wikipediasecondary source
- [3]Overview – DuckDB Community Extensionsdocumentation