Help Center Navigation
Document Composer

Importing Spreadsheets & CSVs

Connect Excel (.xlsx) and CSV spreadsheets, auto-map columns to template placeholders, edit rows directly in the data grid, and handle nested items.

4 min read • Guide

Once your Word template is loaded, the next step is feeding it with data. Trydoku lets you connect Excel spreadsheets (.xlsx) or CSV files, automatically maps spreadsheet columns to your template variables, and gives you a high-performance in-browser data grid for instant edits.

Supported File Formats

Microsoft Excel (.xlsx)

Preserves column formatting, dates, currency signs, and handles multi-tab workbooks by letting you choose the target sheet.

Comma-Separated Values (.csv)

Standard UTF-8 or BOM-encoded CSV files exported from Google Sheets, Airtable, CRM systems, or internal databases.

Column Auto-Mapping

Trydoku automatically matches column headers with template variables using intelligent normalization:

  • Header Customer Name automatically maps to placeholder {{ customer_name }}.
  • Header INV_DATE automatically maps to placeholder {{ inv_date }}.
  • If a column name differs, you can manually re-assign the target variable using the column dropdown in the grid header.

Importing Repeating Loop Blocks (Sub-Items)

When your Word template contains repeating table rows or bulleted lists defined with loop tags (such as {{> products }} ... {{< products }}), you can import their sub-items directly from your spreadsheet:

  • Supported JSON Format: Enter a JSON array of objects in the loop cell, for example: [{"productName": "Widget", "productPrice": "9.99"}, {"productName": "Cable", "productPrice": "14.50"}]. Alternatively, the wrapper object format {"items": [...]} is fully supported.
  • Empty Loop Cells: Blank cells in loop columns are initialized as empty lists ({ items: [] }). During document generation, empty loops cleanly omit the repeating block as intended.
  • Zero Silent Data Loss: If a spreadsheet contains plain text or malformed JSON in a loop column, Trydoku halts import and reports the exact row and column so you can correct your data rather than silently losing loop items.
  • Supported Nesting Depth: Trydoku supports single-level repeating loops. Nested loops within another loop are explicitly rejected with an informative error message.

In-Grid Editing & Sub-Item Grids

Need to fix a typo or add an extra record before generating? You don't have to go back to Excel. The Composer includes a full-featured data grid:

  • Direct Cell Editing: Double-click any cell or press Enter to edit values inline.
  • Keyboard Navigation: Use arrow keys, Tab, Enter, and paste (Ctrl+V / Cmd+V) to copy data directly from other spreadsheets.
  • Sub-Item Tables: For repeating invoice lines, click the nested grid icon on any row to open the sub-item modal and add line items.
  • Row Boundaries: The interactive data grid supports up to 500 rows per batch session directly in the browser.

Put this into practice

Ready to take action or test what you've learned?

Import Data →