background

Data import guide

Tags:uploadglobal importimportcsvxmlsdd

Twikey enables you to import structured data in bulk, including customers, agreements, subscriptions, invoices, transactions, refunds, and payment links. This guide explains how the import process works and where to find the correct templates and detailed instructions per data type.

Each import type has a dedicated help article describing mandatory fields, optional fields, and validation rules.

Before you start

To ensure a successful upload:

  • Always use the official template provided for the specific import type.
  • Do not change the column headers (name or order).
  • Remove example rows before uploading your final file.
  • Make sure your file respects the required format (CSV, UBL, or SDD where applicable).
Please note that working with Excel might affect the .csv file ! Date formats change, leading zeros dissappear,... Make sure to export your file as a .CSV - comma seperated file to avoid issues.

If an import fails, you will receive an email containing a detailed error report so you can quickly correct and re-upload your file.

How to upload a file

You can start an import from anywhere in your Twikey environment:

  1. Click the New button at the top of the screen
  2. Select Import

You can also initiate an import directly from a specific module (e.g. Customers, Transactions, Subscriptions). This will automatically open the global import screen with the correct import type preselected.

Maximum file size

  • CSV files are limited to 200 KB per upload.
  • If your file exceeds this limit, split it into multiple smaller files before importing.

Updating existing data

The import function can also be used to update records.

A recommended approach is:

  1. Export the existing data from Twikey.
  2. Modify only the necessary fields.
  3. Re-import the updated file.

Be aware that not all fields behave the same way. Some fields update existing records, while others result in new entries being created. Each import-specific help article explains which fields can safely be modified.

Example:
If you change the description of a subscription via import, the current subscription will be cancelled and a new one will be created.

Last Update: 2026-02-12