Skip to main content
Updated Oct 19, 2026
Zu Wei
2 min read

How to Export Form Submissions and Match Them to Customers

What Is This?

Download every answer to a form as a spreadsheet. Each row from a logged-in customer carries a Customer ID, so you can join it to your customer list even when names repeat.

Real-Life Example

Wei Lin runs a pet grooming salon in Subang. Her pet health form had 300 answers, and two owners were both called "Tan". She exported the submissions and her customer list, then matched them by Customer ID, not by name. Now each pet's answers sit beside the right owner.

How to Set It Up

  1. Go to Admin Panel → Forms → Forms.

    Admin Panel with Forms expanded, Forms highlighted and its landing page visible.

    Forms has its own sidebar group.

  2. Click Edit on the form you want.

    Step 2: The Custom Forms list with the Edit button highlighted on the KLCC Smart City Expo row

    Edit is at the right of each row.

  3. Click the Manage Custom Form Submissions tab.

    Step 3: The Edit Custom Form page with the Manage Custom Form Submissions tab highlighted

    The tab sits next to Edit Custom Form.

  4. Click the filter icon to export only some rows (optional). Set the filters, then click Apply filters.

    Step 4: The Filters panel open with Status, Submitted From, Submitted Until, With Attachments and Apply filters

    The export keeps only rows that match your filters and search.

    • Status: Pending, Verified, Approved or Rejected.
    • Submitted From and Submitted Until: a date range.
    • With Attachments: only rows with an uploaded receipt or document.
    • On a Custom Form, you also get Priority, Category and Assigned To.
  5. Click Export.

    Step 5: The Export button highlighted above the submissions table

    Export sits above the table.

  6. Keep Customer ID ticked. It is the column you match on. Tick Customer too if you also want the name beside it. Untick the columns you don't need.

    Export Form Submissions dialog with the Customer ID column checkbox ticked and highlighted in blue, above the form submissions table.

    Type in a box to rename that column.

  7. Click Export at the bottom of the window.

    Custom Form Submissions export dialog scrolled to the Export button, highlighted before submitting.

    When the file is ready, the bell shows Export completed with Download .csv and Download .xlsx.

Match Rows to Your Customers

Export your customer list too. Its ID column holds the same number as Customer ID.

In Excel or Google Sheets, put the customer list on a sheet called Customers. In the submissions sheet, if Customer ID is in column B, type:

=XLOOKUP(B2, Customers!A:A, Customers!B:B, "Not found")

This returns the customer's name. Change the last range to pull points or tier.

What Your Customers Will See

Nothing. Exporting sends customers no message.

Good to Know

  • Form Data holds the form's field answers in one cell, written as "field name: answer | field name: answer". Uploaded files aren't in the export.
  • If a form has Require Login turned off, a guest can send it. Guest rows show N/A for Customer ID, name, email and phone.
  • Status, Priority and Category export as short codes, for example "approved".

Need Help?

If Export completed never arrives, contact Pixalink support with the form name.

What's Next?

Was this article helpful?

Thank you for your feedback!

0 found this helpful 0 did not

Search