CSV / Excel

The file connector accepts .csv, .tsv, .xlsx, and .xls. Use it for exports, one-off analyses, and reference data that has no API.

Upload

Drag a file onto Add data, or click CSV / Excel in Quick add. Chartizer parses the header row, samples up to 500 rows to infer types, and shows a preview before creating the dataset.

Setting	Default	Notes
Delimiter	auto	Detected from the first line
Encoding	`UTF-8`	`Windows-1257` and `ISO-8859-1` also supported
Header row	`1`	Set to `0` for headerless files
Sheet (Excel)	first	One dataset per sheet
Decimal separator	`.`	Set to `,` for European exports

Check the decimal separator

1,5 parsed with the wrong separator becomes 15. Chartizer flags columns where this is ambiguous, but confirm it in the preview before creating the dataset.

Replace a file

Uploading again replaces the data and keeps the dataset identity — its ID, mappings, and every chart built on it stay intact.

Open the dataset and click Replace file

Upload the new version

Chartizer compares the incoming header to the stored schema.

Resolve differences

Difference	Result
Identical header	Replaces immediately
New column	Dataset moves to `Schema drift`; accept to add it
Missing column	Charts using it show a broken-field marker
Renamed column	Treated as one removal and one addition — repoint the mapping

Replace, do not delete and re-upload

Deleting the dataset destroys its mappings and breaks every chart reading it. Replacing keeps all of that.

Scheduled file drops

For recurring exports, point Chartizer at a location instead of uploading by hand:

Method	Setup
S3 / GCS	Bucket, prefix, and read-only credentials; newest matching object wins
HTTPS URL	A stable URL Chartizer fetches on a schedule
Email drop	A team address; attachments matching a filename pattern are ingested

Watch a bucket prefix
{
  "type": "file",
  "source": {
    "kind": "s3",
    "bucket": "acme-exports",
    "prefix": "chartizer/leads-",
    "pattern": "leads-*.csv"
  },
  "refresh": { "policy": "scheduled", "interval": "24h" }
}

Limits

Limit	Value
Max file size	100 MB (Pro), 25 MB (Free)
Max columns	512
Max rows per file	5 million

Large recurring files belong in a database

If you are uploading a 90 MB CSV every morning, load it into PostgreSQL and connect that instead. Syncs get faster and schema changes stop being surprises.

Rows dropped silently on upload

Almost always unescaped quotes or stray line breaks inside a field. Re-export with proper quoting; the preview reports the first offending line number.

Dates imported as text

The format was not recognised. Set the column type to date and supply a format string such as DD.MM.YYYY.

Leading zeros stripped from IDs

Excel did that, not Chartizer. Export the column as text, or set the column type to text before creating the dataset.