Skip to main content

Prepare your CSV

Use this page to prepare CSV data that Bulk Fill can preview and export reliably. CSV issues are one of the most common causes of mapping mistakes and unexpected output, so it is worth making the contract explicit.

Current CSV Contract​

In the current product contract:

  • Bulk Fill does not auto-detect whether the first row is a header.
  • Bulk Fill does not skip or special-case row 1.
  • Every row is treated as normal exportable data.
  • Columns are identified by position as column_0, column_1, column_2, and so on.

If your CSV includes a header row for your own reference, that row is still data to Bulk Fill. Exclude it during export by starting your batch range at row 2 or by leaving row 1 out of your selected rows.

Use these defaults unless you have a reason not to:

  • Save the file as UTF-8 CSV.
  • Keep one record per row.
  • Keep column order stable from test runs to final export.
  • Use plain, readable dates, numbers, and boolean values.
  • Leave blank cells only when blank output is acceptable.

Examples of readable values:

  • dates: 2026-03-18
  • numbers: 149.00
  • booleans: true / false or yes / no

Sample CSV​

Download a small test file here: sample-bulk-fill.csv

Inline example:

Alice Nguyen,INV-1001,2026-03-18,149.00
Marco Silva,INV-1002,2026-03-19,89.50
Priya Patel,INV-1003,2026-03-20,210.00

In this example:

  • column_0 is the customer name
  • column_1 is the invoice number
  • column_2 is the date
  • column_3 is the amount

If You Keep A Header Row​

Some teams prefer a visible header row for readability outside Doqlo. That is fine, but keep these tradeoffs in mind:

  • the header row will appear as row 1 in preview
  • the header row is eligible for export unless you exclude it
  • field mapping still uses positional column IDs, not the header text itself

Common CSV Mistakes​

  • expecting the first row to become column names automatically
  • changing column order after fields are already mapped
  • exporting from another tool with the wrong separator or encoding
  • leaving stray empty rows or empty columns in the file
  • mixing data formats across rows, such as different date styles

Next Steps​