Analyze Cohort Data from Spreadsheet
When you analyze cohort data from spreadsheet exports, you track groups of users over time to measure retention, engagement, and revenue patterns. Most product analytics tools export cohort data as wide tables with one row per cohort and columns for each time period, which makes calculating trends or comparing cohorts difficult without restructuring the data first.
Upload a cohort export and get back analysis-ready rows you can pivot, chart, and filter by period or cohort without restructuring formulas.
Drop your file in and ask a question — no account needed.
Upload your spreadsheet.xlsx .xls .csv — free to try, no accountWhat this export contains
| Cohort |
| Cohort Size |
| Week 0 |
| Week 1 |
| Week 2 |
| Week 3 |
| Week 4 |
| Day 0 |
| Day 1 |
| Day 7 |
| Day 14 |
| Day 30 |
| Users |
| Revenue |
Common questions
How do I analyze cohort data from spreadsheet exports?
Calculate retention rates by dividing each period's user count by the cohort size, convert the wide format to long format so each cohort-period combination is one row, then chart or filter by specific periods to compare cohorts. This lets you see which acquisition periods brought users who retained best and what the revenue per user looks like over time.
How do I calculate retention rate for each cohort period?
Divide each period's user count by the cohort size in Week 0 or Day 0, then multiply by 100. If Week 0 is 500 users and Week 4 is 120 users, the Week 4 retention rate is (120/500)*100 = 24%. You need this formula copied down for every cohort and across for every time period.
How do I convert cohort data from wide format to long format?
Use Power Query's Unpivot Columns feature in Excel, or stack the period columns into rows with a formula that repeats the cohort name and size for each period. Long format has one row per cohort-period combination with columns for Cohort, Period, and Value, which most charting and analysis tools require.
How do I compare retention across multiple cohorts?
Add a column that calculates retention rate for a specific period like Day 30, then sort or filter by that column to rank cohorts. To see trends over time, convert to long format first so you can group by period and average the retention rates across cohorts acquired in the same month or quarter.
How do I calculate average revenue per user by cohort?
Sum the revenue columns for each cohort, then divide by the cohort size. If cumulative revenue across all periods is $12,000 and the cohort size is 500, ARPU is $24. Watch for blank cells in revenue columns from cohorts that have not matured yet, which will cause SUM to skip them or return zero incorrectly.
How do I identify which cohort has the best long-term retention?
Calculate the retention rate at your longest measured period for each cohort, then sort descending. If you measure out to Week 12, divide the Week 12 user count by Week 0 for every cohort and find the maximum. This tells you which acquisition period or campaign brought users who stayed longest.
Try it with your own file
DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.
Ask about your fileWhat DataMimi costs
Every plan does everything — slides, written reports, cleaned exports, dashboards. They differ in how much work they cover.
Free
Free
40 credits a month
Starter
$24 /month
1,500 credits a month
Pro
$59 /month
5,000 credits a month