Bulk Download: How to extract and view data in Excel?
However, if one desires to open a bulk download data file in Excel, we advise users to follow the options below to be able to extract and view the maximum number of data points in Excel.
1) Download the data in time series format, which reduces the file size and makes it easier for Excel to consume the data file.
2) Breakdown the size of the bulk download data file by selecting a desired subset of countries and/or indicators.
NOTE: For best practices, users are advised to use a specialized data management software capable of handling large datasets to open a bulk download data file. We are not in a position to advise on which software users should use, but Open Office or Power-Pivot Excel add-ins are some examples.