Uploading your data

CSV templates

Nagata provides downloadable templates for each type of data import. Using the template ensures your columns are named correctly and the import succeeds on the first try.

Download from Settings → CSV templates or from the /templates page.

Spend template

ColumnTypeRequiredExample
vendor_nameTextYesNotion
amount_usdNumberYes1200.00
dateDate (YYYY-MM-DD)Yes2024-03-15
categoryTextNoProductivity
departmentTextNoEngineering
currencyTextNoUSD
sourceTextNoRamp

AI usage template

ColumnTypeRequiredExample
providerTextYesopenai
modelTextYesgpt-4o
workflow_typeTextYesemail-draft
source_typeTextNoapi
user_emailEmailNojane@company.com
occurred_atISO timestampYes2024-03-15T14:22:00Z
input_tokensIntegerNo512
output_tokensIntegerNo1024
cost_usdNumberYes0.0082

Tips for all templates

  • Wrap any field containing a comma in double quotes: "Acme, Inc."
  • Save as UTF-8 CSV, not Excel .xlsx format
  • Remove any totals or summary rows at the bottom before uploading