Skip to main content

Append a CSV

Add many rows to an existing file by uploading another CSV and mapping its columns.

Use Append CSV when you have a separate file (for example, last month's export plus this month's) and want to merge it into the existing data source without re-uploading from scratch.

Before you start

  • The original file is already uploaded.
  • You're on its data editor.
  • Your new CSV has a header row.
  • Column names in the new CSV should ideally match the existing schema.

Step 1 — Pick the new CSV

  1. Click Append CSV in the editor's header. A panel slides in from the right.
  2. Drag your new .csv onto the drop zone, or click to browse.
  3. AskPhi parses the file and shows a column mapping screen.

Step 2 — Map columns

For each column in the existing schema, AskPhi shows a dropdown of the new CSV's headers. Where header names match, AskPhi pre-selects them for you.

For each schema column, choose one of:

  • A column from the new CSV (default for matching headers).
  • Auto-increment — only available for integer-like columns. AskPhi generates the next sequence numbers.
  • Leave blank — only allowed if the column is nullable.

A green checkmark appears next to each schema column once it has a valid mapping.


Step 3 — Append

  1. When all required columns are mapped, the Append button enables.
  2. Click Append.
  3. A progress bar shows upload status. The button is disabled while working.
  4. A success toast confirms the new rows have been added. The data table on the left refreshes automatically.

What happens to mismatched columns?

SituationResult
New CSV has columns the existing file doesn't haveThey are ignored.
Existing column has no matching new CSV columnYou must pick Auto-increment (if available) or leave it blank if the column is nullable.
Required column has no mapping and isn't nullableThe Append button stays disabled.

Next