Find and download collections of multiple areas at once using the data cart

This guide shows how to create a custom collection of multiple areas (or organisations) using the data cart. This is useful if you want to use it as a template for looking at information about the same areas which is held in different datasets (for example if you’re a council officer for a particular local authority).

In any table you generate, the geography will be the rows and you can select the columns from the data. Read how to add data columns to a cart to create a custom spreadsheet.

An empty data cart looks like this:

Find the areas you want to add to your cart

If you know the area you want then go to the search box in the top toolbar, select the Find places tab and enter the postcode / place. Read more about browsing by area or searching by place name or postcode.

You can also get to areas by going to the Atlas Tab, and scrolling down the page to the map and list of area types, organisations and place names:

To find data zones: if you enter Perth as a keyword in the search box you get a list of areas matching the Perth search term as a result. So data zones do appear searching this way but only those with 'Perth' in their title to match the search term (eg Perth Road). To get all data zones for an area, go to the council area they belong to.

To find all data zones for Perth select the Council Area ‘Perth and Kinross’. This takes you to a new page. Scroll down (below the area profile and datasets) to view all areas, including Data Zones, within the council.

Select the Data Zones text in the list on the left of the map of the council area. You will get a list view of all data zones next to an interactive map of them.

Add your areas to the cart (these areas will be your spreadsheet rows). 

In this example I add all the data zones by clicking on the add to data cart button at the foot of the list.

Edit or save your cart. 

Check you have your areas of choice in the data cart by going to the Data Cart tab in the top toolbar on the right. Remove areas using the red button, or add more by finding areas and adding them to the cart. Read how to add data columns to a cart to create a custom table.

Once you have the areas you want, click on the Save Cart button. Once saved a cart can no longer be edited.

You now have a permanent link to this selection of areas that you can use and share with others - a re-usable filter on geographical areas. You can also download your selection by clicking on the csv button. You will need to bookmark it or otherwise make a note of it.

To use the data cart again, use the saved URL to reload the cart, then go to the contents tab. This will give you the option to add this collection of areas to a new cart, and then you can add whatever data you want to. Read about how to add data to your cart.

Summary

• Find the areas you want to add to your cart either by Search or in Atlas
• Select the ‘Add to Cart’ button to add them to your cart
• After making any edits you want, click on ‘Save Cart’. You will then have a permanent link to your collection of areas as well as the option to download the rows of areas.
• Share your collection by copying and pasting the link under ‘share’ or get the areas into Excel by clicking on csv.
• To use the data cart again, go to the contents tab of your cart. This will give you the option to add this collection of areas to a new cart, which you can add whatever data you want to. (Read about how to add data to the cart).

To continue exploring our data, go to statistics.gov.scot