Payanvil

Input file format

Payanvil reads your recipient list from a spreadsheet or a text file. Here's exactly what it expects.

The rule

What matters is the order of the columns — not their names. The header row can be in any language, or absent altogether.

So you don't have to rename anything or translate your existing register. Keep the columns in this order:

  1. Full name — optional
  2. Recipient wallet — required
  3. Purpose — optional
  4. Amount — required

Supported formats: .xlsx, .csv and .txt.

Excel (.xlsx)

Four columns, first sheet. The header row is skipped automatically.

Example of an Excel file with four columns: full name, wallet, purpose, amount
Columns A–D. Rows with an empty name or purpose are perfectly fine.

CSV (.csv)

Same four columns. The delimiter — ;, , or a tab — is detected automatically, so a file exported from any regional version of Excel just works.

Example of a CSV file with four fields separated by semicolons
Fields may be quoted (RFC 4180). Amounts accept both a dot and a comma: 150.50 or 150,50.

Plain text (.txt)

The simplest option when you only have addresses and amounts: an address amount pair per record. A record ends at a line break or a semicolon ;, so you can keep one per line or put several in one line. The amount accepts both a dot and a comma: 150.50 or 150,50. Lines starting with # are treated as comments.

# payouts for July
TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t  150,50
TJnRioDipVbRx7hz8ApdeUpygdjN9gy4a3  1000
TWUQMSrGvefAJTZqNhkDAaf1WpnTWYH53f  75; TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t  20

What happens to bad rows

One typo doesn't cost you the whole file. Valid rows are accepted; every rejected row is reported with its line number, the reason and the offending value — so you know exactly what to fix.

ReasonWhat it means
Invalid wallet addressNot a valid Tron (TRC-20) address — typo, wrong network, or stray characters
Invalid amountThe amount isn't a number
Amount is missingThe amount cell is empty
Wrong line format.txt only: the line isn't an «address amount» pair

The same reference is built into the app — press the ? button next to the file selector, and you'll get this page in your interface language.

← Back to home