Skip to content
NAVdryx docs

Import data

Bring an investor register, capital activity history, trial balance, or chart of accounts into NAVdryx through the staging area.

Steps

  1. Start from a template. Templates are provided for the investor register, capital activity, trial balance, and chart of accounts.
  2. Upload. CSV or Excel, with encoding, delimiter, and header detected automatically.
  3. Map columns.Match your file’s columns to NAVdryx’s fields, or reuse a saved mapping from a previous import.
  4. Validate in staging. Nothing lands in production data yet — the staging area holds the draft import while you review it.
  5. Read the error report. Row-level issues are called out explicitly rather than failing the whole import silently.
  6. Promote to production. An explicit, separate action — the import cannot become live data by accident.

Excel specifics

Excel import preserves sheet structure and detects formulas, external links, hidden sheets, and macros. Formula support has an explicit, stated scope — arithmetic, statistical functions, lookup functions (VLOOKUP, INDEX/MATCH, XLOOKUP), conditional functions, and date functions. A formula outside that scope converts to a static value with a flag, so you know it happened. External links convert to a static value with a flag the same way. Macros are stripped on import and warned about on export.

If something looks wrong

Because production data is never touched until you explicitly promote a staged import, a bad mapping or a dirty source file costs you a re-upload, not a cleanup job against live records. Fix the source file or the mapping and re-run validation before promoting again.