CSV Support
The Sablier Interfaces supports CSV files for faster processing and automating large-scale operations. This feature is available for both airdrops and streams.
Dates: All columns with the "date" type should have the following format: "YYYY-MM-DD HH:mm".
Durations: All columns with the "duration" type should have the following format: "x years y days z hours". Note that each particle is optional, e.g., you can skip the days.
Timezones: The dates and times extracted from the CSV are processed using the same timezone used by the user's browser.
Amounts: All token amounts should be expressed in humanized form, e.g., 10 USDC should be written as 10, not
10000000. The Sablier app will multiply the amounts by the token's number of decimals in the processing step.
Airdrops
With Sablier, you can create airdrop campaigns with up to a million recipients. To do so, you must upload a CSV file containing all recipient addresses and the airdrop amounts.
Use the provided template and fill in the rows with recipient addresses and airdrop amounts.
CSV Template
For your convenience, here's a download link for the CSV template:
Navigation
To use this feature:
- Access the create airdrop page
- Fill out the details for your airdrop campaign in the 1st step
- Continue to the 2nd step, where you can upload the CSV
 |
Streams
 |
Using a CSV, you can deploy up to 280 streams all at once. Start from the suggested template, and fill in the rows with addresses, amounts, and other details.
CSV Template
Here's table with all the available CSV templates:
| URL | Description |
|---|---|
| Flow | Open-ended streams that can be topped up. |
| Linear with duration | Linear streams with the duration timing. |
| Linear with range | Linear streams with the range timing. |
| Cliff with duration | Cliff streams with the duration timing. |
| Cliff with range | Cliff streams with the range timing. |
| Monthly with range | Unlock Each Month streams with the range timing. |
| Stepper with duration | Unlock In Steps streams with the duration timing. |
| Stepper with range | Unlock In Steps streams with the duration timing. |
| Timelock with duration | Timelock streams with the duration timing. |
| Timelock with range | Timelock streams with the range timing. |
| BackWeighted with range | BackWeighted streams with the range timing. |
| Unlock linear with duration | Unlock-Linear streams with the duration timing. |
| Unlock linear with range | Unlock-Liner streams with the duration timing. |
| Unlock cliff with duration | Unlock-Cliff streams with the duration timing. |
| Unlock cliff with range | Unlock-Cliff streams with the range timing. |
| Exponential with duration | Exponential streams with the duration timing. |
| Exponential with range | Exponential streams with the range timing. |
| Cliff exponential with duration | Cliff-Exponential streams with the duration timing. |
| Cliff exponential with range | Cliff-Exponential streams with the range timing. |
Navigation
To use this feature:
- Access the vesting gallery page in the Sablier app
- Select the desired vesting shape
- In the top right corner, you will find a button guiding you toward the CSV feature
 |
Column Formats
To use the CSV feature, the data you provide must be formatted correctly. Bellow is a list with the format expected for all column types supported by Sablier.
Make sure that your CSV editing software (e.g. Microsoft Excel) does not override the cell format. We suggest double-checking in the Sablier app that the dates have been parsed as expected.
| Column | Type | Description | Examples |
|---|---|---|---|
| address | String | Recipient address | 0x12...AB |
| amount | Number | Deposit amount | 100, 42161 or any other valid amount |
| duration | String | Total duration | 1 year 20 days, 3 years 20 days 4 hours |
| start | Date | Start date in YYYY-MM-DD HH:mm format | 2024-02-24 16:15, 2026-02-14 17:25 |
| end | Date | End date in YYYY-MM-DD HH:mm format | 2024-02-24 16:15, 2026-02-14 17:25 |
| cliffDuration | String | Cliff duration | 2 years 20 days, 3 years 20 days 4 hours |
| cliffEnd | Date | Cliff date in YYYY-MM-DD HH:mm format | 2024-02-24 16:15, 2026-02-14 17:25 |
| months | Number | Number of months for the unlock monthly | 5, 12 or any other valid integer |
| steps | Number | Number of steps for the unlock in steps | 5, 12 or any other valid integer |
| unlock | Number | Amount that will be initially unlocked | 100, 42161 or any other valid amount |
| initial | String | Whether the first unlock should occur at the start date or at the end of the first month | at start or end of first month |