Interactive controls could not load. Reload this page to try again; the content and guides below are still available.
Reload pageData Studio
Create CSV pivot summaries free online, inspect missing values and calculate grouped counts or totals. Confirm the selected fields and aggregation scope before using results.
YOUR WORKSPACE
Create CSV pivot summaries free online, inspect missing values and calculate grouped counts or totals. Confirm the selected fields and aggregation scope before using results.
Load the sample, clean and confirm its three deduplicated rows, then sum by channel: community has two rows totaling 400 and email has one totaling 200. Summarizing the original four rows instead includes a duplicate.
Up to 50 files, 50 MB total, 100,000 rows, 300 fields and 2 million cells. Pivots allow up to 500 column groups and 20,000 row groups; splitting allows 500 groups. Record counts are not distinct-customer counts. Do not sum different currencies as one amount.
Blank and nonnumeric values need review; treating them as zero could conceal missing data. Correct or clean the source before retrying.
The check generates an issue list. Only explicit adoption makes it working data; review the source and row count before continuing.
Use the local functions for free without a KitNelo account. Optional Gemini generation sends the supplied text to Google and requires a configured server API key; provider fees and quotas can apply.
Confirm the aggregation field and scope. A sum or count does not explain why the result changed.
Read KitNelo data and privacy detailsImport a CSV and select the grouping and aggregation fields to produce a pivot-style summary. Check which source rows are included and whether the chosen calculation is a count or sum before interpreting the displayed result.
Load the table and inspect missing-value information to identify fields that need attention. Review the underlying rows for empty cells and placeholder text, because the summary alone cannot explain why a value is absent or what should replace it.
Choose the categories to group and the numeric field to total, then inspect the resulting table. Confirm that values use consistent units and the intended aggregation scope; grouped totals show amounts without explaining their causes.
Inspect the quality summary for missing fields, inconsistent values and other reported issues before relying on aggregates. Review flagged rows in their original context. A clean summary reflects the available checks and does not establish the correctness of the underlying business data.
