convert-file
Convert any data file to another format—CSV, Parquet, JSON, Excel, GeoJSON, and more—in a single DuckDB command. Handles both local and remote files, with support for partitioning and compression options when needed.
convert-file transforms data files between formats like CSV, Parquet, JSON, and Excel using DuckDB.
AI-generated summary based on this skill's SKILL.md
Install
duckdb/duckdb-skills/convert-file · repository language: Shell
git clone https://github.com/duckdb/duckdb-skills
cp -r duckdb-skills/skills/convert-file ~/.claude/skills/convert-fileFrequently asked questions
AI-generated answers based on this skill's SKILL.md and metadata
How do I turn a CSV into Parquet with convert-file?
convert-file transforms CSV to Parquet in a single DuckDB command. Simply specify your CSV source and choose Parquet as the output format; the skill handles the conversion automatically, including optional compression and partitioning if you need them.
What formats does convert-file support for conversion?
convert-file supports CSV, Parquet, JSON, Excel, GeoJSON, JSONL, NDJSON, TSV, and spatial formats like Shapefiles and GeoPackage. You can convert between any of these formats—whether exporting data as JSON, transforming xlsx to CSV, or writing data as GeoJSON.
Can convert-file handle remote data files?
Yes, convert-file handles remote data files from S3, GCS, and HTTP sources. You can point to a remote file location and convert it to your desired format without downloading it locally first.
Does convert-file support compression and partitioning?
convert-file supports compression and partitioning options during format conversion. When converting large datasets, you can apply these optimizations to reduce file size and improve query performance on the output.
How does convert-file handle geospatial data conversion?
convert-file can transform geospatial data to GeoJSON or other spatial formats. It supports converting Shapefiles, GeoPackage files, and other spatial sources, making it easy to work with location-based datasets across different formats.
What license does convert-file use?
convert-file is released under the MIT license, allowing free use, modification, and distribution in both open-source and commercial projects.
SKILL.md
rendered from the published skill — quoted content, verbatim
You are helping the user convert a data file from one format to another using DuckDB.
Input file: $0
Output file: ${1:-}
Step 1 — Resolve input and output
Input: $0. If it's a bare filename (no /), resolve to a full path with find "$PWD" -name "$0" -not -path '*/.git/*' 2>/dev/null | head -1.
Output: If $1 is provided, use it as the output path. If not, default to the same stem as the input with a .parquet extension (e.g., data.csv → data.parquet).
Infer the output format from the output file extension:
| Extension | Format clause |
|---|---|
.parquet, .pq |
(default, no clause needed) |
.csv |
(FORMAT csv, HEADER) |
.tsv |
`(FORMAT |
(truncated - see the full file via the links below)
Read as markdown · JSON record · Browse the source repository
File tree — 1 file
skills/convert-file/SKILL.md