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
- Click Append CSV in the editor's header. A panel slides in from the right.
- Drag your new
.csvonto the drop zone, or click to browse. - 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
- When all required columns are mapped, the Append button enables.
- Click Append.
- A progress bar shows upload status. The button is disabled while working.
- A success toast confirms the new rows have been added. The data table on the left refreshes automatically.
What happens to mismatched columns?
| Situation | Result |
|---|---|
| New CSV has columns the existing file doesn't have | They are ignored. |
| Existing column has no matching new CSV column | You must pick Auto-increment (if available) or leave it blank if the column is nullable. |
| Required column has no mapping and isn't nullable | The Append button stays disabled. |