The data portal offers the possibility of a preview. You can select figures from a dataset and then look into this selection with a preview. In the future an option will be added to download the selection as a csv file. To this download will apply no limits concerning the number of cells.
There is a manual available with an explanation how to load data into Excel with an odata 4 query. It uses the query editor of Excel to first retrieve the metadata and then retrieve a subset of a large dataset. Next it shows how to use these data to make a pivot table in Excel. The manual uses Excel 2016.
Excel 2016 recognizes two ways to retrieve data using an odata query. But only the way that you find under Data > New Query > From Other Sources > From ODataFeed supports odata version 4. The way you find under Data > From Other Sources > From ODataFeed is only fit for use with odata version 3.
The API (application programming interface) of odata 4 makes available datasets to load them into BI tools or computer programs. There are quick start guides (Dutch only) for using R and Python. To make use of these quick start guides basic skills with R or Python are necessary.