📄 CSV Import Templates
GigAnalytics auto-detects column names from these formats. Download a template, fill in your data, and import via Import → Upload CSV.
Animated demo — upload any CSV and GigAnalytics maps your columns automatically
Import Rules
- File must be UTF-8 CSV (comma-separated, optional quotes)
- First row must be headers — case-insensitive column matching
datemust be parseable (YYYY-MM-DD or MM/DD/YYYY)amountornetis required (numeric, no currency symbols)- Negative amounts are treated as refunds/chargebacks
- Maximum file size: 5 MB (~50,000 rows)
- Duplicate rows (same source_id or date+amount+description) are silently skipped
Generic / Universal
Works with any platform. Required columns only.
| date | amount | currency | description | platform |
|---|---|---|---|---|
| … | … | … | … | … |
Tip: Minimum required format. All other columns are optional.
Stripe Exports
Matches Stripe Payments CSV export format.
| id | created (UTC) | amount | amount_refunded | currency | description | fee | net | status |
|---|---|---|---|---|---|---|---|---|
| … | … | … | … | … | … | … | … | … |
Tip: Export from Stripe Dashboard → Payments → Export. GigAnalytics reads "net" as revenue and "fee" as acquisition cost.
PayPal Exports
Matches PayPal Activity CSV format.
| Date | Time | TimeZone | Name | Type | Status | Currency | Gross | Fee | Net |
|---|---|---|---|---|---|---|---|---|---|
| … | … | … | … | … | … | … | … | … | … |
Tip: Export from PayPal → Activity → Statements → Download. Filter to "Completed" transactions.
Upwork
Matches Upwork Transaction History CSV.
| Date | Ref ID | Type | Description | Amount | Agency Amount | Bonus | Other |
|---|---|---|---|---|---|---|---|
| … | … | … | … | … | … | … | … |
Tip: Export from Upwork → Reports → Transaction History. "Amount" is used as net revenue.
Fiverr
Matches Fiverr Revenue CSV.
| Date | Order Number | Buyer | Description | Total | Revenue | Service Fee |
|---|---|---|---|---|---|---|
| … | … | … | … | … | … | … |
Tip: "Revenue" (after Fiverr 20% fee) is used as net revenue.
Using a custom format?
GigAnalytics will do its best to auto-detect columns. If detection fails, you'll see a column mapping screen before import. Required: at least one date column and one numeric amount column. Any unrecognized columns are stored as metadata and shown in transaction detail.