File Import

Available

File Import

Koopic processes enterprise-grade file imports with zero configuration. Upload CSV, TSV, JSON (arrays, nested objects, NDJSON), or Excel files (.xlsx/.xls) from Google Cloud Storage or Azure Blob Storage. Auto-detection handles character encoding, delimiters, and column types so you can import data from any tool that exports files.

Key Features

CSV, TSV, JSON (array, nested, NDJSON), and Excel (.xlsx/.xls) with multi-sheet support
Auto-detection of encoding (UTF-8, Latin-1, etc.), delimiter, and column types
Type inference: datetime, integer, numeric, boolean, JSON, text
Visual file browser for GCP and Azure cloud storage
Preview first 10 rows before mapping
Scheduled imports from cloud storage buckets

How to Set Up

1

Add cloud storage credentials

Create a GCP service account key or Azure storage key/SAS URL in the Koopic credential vault.

2

Browse and select files

Use the visual file browser to navigate your buckets and containers. Select the file to import.

3

Preview and map fields

Koopic shows a preview of the first 10 rows with auto-detected column types. Map source columns to the unified schema.

4

Schedule recurring imports

Set a schedule to automatically re-import updated files from the same location.

Use Cases

Legacy Tool Migration

Import CSV exports from tools being replaced. Map fields once, and Koopic handles ongoing imports.

Manual Data Sources

Import Excel spreadsheets from teams that track assets manually or in tools without APIs.

Bulk Initial Load

Bootstrap your Koopic instance by importing existing asset data from any format.

Ready to connect your tools?

Start your free trial and set up your first integration in under 10 minutes.