Adding Custom Profile Property 'Internal User' via CSV Import in Kapa.ai

·Aug 06, 2025 08:47 AM·

kapa.ai how do I add a custom profile property to users via CSV file import? This profile property does not already exist in our data, and is not something that can be inferred via a formulae. I want to create custom profile property 'Internal User' and based on their Distinct ID assign users TRUE or FALSE

2 comments

· Sorted by Oldest

kapa.ai
APP
·
·
Please stand by Anjali A. as I search the knowledge base. I normally take about 15 seconds or so. 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
kapa.ai
APP
·
·
To add a custom profile property (e.g., Internal User) to users via CSV import in Mixpanel, follow these steps: 1. Prepare Your CSV File - Do not include column headers in your CSV file. - The first column should contain the users’ $distinct_id values. - The second column should contain the value for your custom property (TRUE or FALSE for Internal User). - Example (no headers):
67890,FALSE 54321,TRUE ```LBKSLBKS2. **Import the CSV in Mixpanel** - Go to the **Users** tab in Mixpanel. - Click **Add/Edit Profile** and select **Import from CSV**. - Upload your CSV file.LBKS3. **Map Columns to Properties** - In the upload wizard, assign the first column as `$distinct_id`. - Assign the second column as your new custom property, e.g., `Internal User`. - You can define the property name during this step, even if it does not already exist in your data.LBKS4. **Complete the Import** - Review the column mappings and values. - Click **Import profiles** to apply the changes.LBKS**Notes:** - If the `$distinct_id` matches an existing user, the profile will be updated with the new property. If not, a new profile will be created. - If you upload new information for an existing property, it will overwrite the old value. New properties will be added to the profile. - The maximum CSV size is 1 million rows.LBKSThis process will create the `Internal User` property for each user and set it to `TRUE` or `FALSE` as specified in your CSV file. There is no need for the property to pre-exist in Mixpanel; it will be created during the import if it does not already exist.LBKSFor more details, see the official documentation on [Bulk Import from CSV](https://docs.mixpanel.com/docs/data-structure/user-profiles#bulk-import-from-csv) and [Importing Profiles via the UI](https://docs.mixpanel.com/docs/data-structure/user-profiles#importing-profiles-via-the-ui).
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

kapa.ai
APP
·
·
Please stand by Anjali A. as I search the knowledge base. I normally take about 15 seconds or so. 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
kapa.ai
APP
·
·
To add a custom profile property (e.g., Internal User) to users via CSV import in Mixpanel, follow these steps: 1. Prepare Your CSV File - Do not include column headers in your CSV file. - The first column should contain the users’ $distinct_id values. - The second column should contain the value for your custom property (TRUE or FALSE for Internal User). - Example (no headers):
67890,FALSE 54321,TRUE ```LBKSLBKS2. **Import the CSV in Mixpanel** - Go to the **Users** tab in Mixpanel. - Click **Add/Edit Profile** and select **Import from CSV**. - Upload your CSV file.LBKS3. **Map Columns to Properties** - In the upload wizard, assign the first column as `$distinct_id`. - Assign the second column as your new custom property, e.g., `Internal User`. - You can define the property name during this step, even if it does not already exist in your data.LBKS4. **Complete the Import** - Review the column mappings and values. - Click **Import profiles** to apply the changes.LBKS**Notes:** - If the `$distinct_id` matches an existing user, the profile will be updated with the new property. If not, a new profile will be created. - If you upload new information for an existing property, it will overwrite the old value. New properties will be added to the profile. - The maximum CSV size is 1 million rows.LBKSThis process will create the `Internal User` property for each user and set it to `TRUE` or `FALSE` as specified in your CSV file. There is no need for the property to pre-exist in Mixpanel; it will be created during the import if it does not already exist.LBKSFor more details, see the official documentation on [Bulk Import from CSV](https://docs.mixpanel.com/docs/data-structure/user-profiles#bulk-import-from-csv) and [Importing Profiles via the UI](https://docs.mixpanel.com/docs/data-structure/user-profiles#importing-profiles-via-the-ui).
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.