Summarise a CSV or Google Sheet by URL (Group By)

Created by

Adam Pearce

Actor

Dataset Aggregate, Group By & Pivot

Load a public CSV, Excel, JSON file or Google Sheet by link and group it: here the open ISO country-codes CSV on GitHub, grouped by continent with a country count, the number of distinct currencies and the lowest dial code per continent, sorted by size, downloaded as CSV and Excel. Swap in your own file or sheet link and field names.

Try for free

Dataset Aggregate, Group By & Pivotnerolabs/dataset-aggregate-pivot

Region

Orders

Total amount

Avg amount

Input

File URL (CSV, Excel, JSON or Google Sheet):https://raw.githubusercontent.com/datasets/country-codes/main/data/country-codes.csv

Group by field(s):Continent

Aggregations

function:count+2

alias:countries+2

Sort by column:countries

Sort direction:desc

Add a grand-total row:true

Export file formats:csv+1

Output fields

Region

Orders

Total amount

Avg amount

How it works

Sign up on Apify or log in

The Dataset Aggregate, Group By & Pivot Actor is ready to run with the inputs already set for "Summarise a CSV or Google Sheet by URL (Group By)". Sign up or log in and you'll land in Apify Console with a copy of this exact task.

Start the "Summarise a CSV or Google Sheet by URL (Group By)" task

The Dataset Aggregate, Group By & Pivot Actor will start running based on the input automatically. You can also change all the input fields, like file url (csv, excel, json or google sheet), group by field(s), and more, to match your specific use case.

Receive the "Summarise a CSV or Google Sheet by URL (Group By)" output

Monitor the progress in real time. You will be notified as soon as your dataset is complete and ready for review. Each result includes data such as region, orders, total amount, and more.

Integrate into your workflow

The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow. You can also run the "Summarise a CSV or Google Sheet by URL (Group By)" task via API.