How do I import csv data for my groups ?

Hi Juan I., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋

To import CSV data for your groups in Mixpanel, you have a few options: 1. Using the Users Report: You can upload Group Profiles using a CSV file through the Users report. This method is described in the Group Analytics documentation, which states: "It is possible to create Group Profiles by CSV upload as an alternative to the Groups API. Follow the instructions here to learn how to upload Group Profiles using the Users report."2. Bulk Import from CSV: You can use the bulk import feature to upload your group data via CSV. The process is similar to importing user profiles. Here are the key steps: - Prepare your CSV file without column headers. - Go to the "Import from CSV" tab and select your prepared CSV. - Choose an identifier column, which should be the $group_id for Group Profiles. - Select the desired CSV columns and map them to Mixpanel profile properties.For more detailed instructions, you can refer to the User Profile: Bulk Import from CSV documentation.3. Using Google Sheets: If you prefer working with Google Sheets, Mixpanel offers a native extension that allows you to import CSV data directly from Google Sheets. You can install the Sheets ⇔ Mixpanel extension from the Google Workspace Marketplace. Once installed, you can use the "Sheet → Mixpanel" option to import your group data.For more information on using the Google Sheets integration, check out the Google Sheets Integration documentation.Remember to set up your Group Keys in Project Settings before importing group data. Also, note that when importing group profiles, you should use $group_id as the identifier instead of $distinct_id used for user profiles.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.