Select data in [Dataset Viewer](link to /jxpbwuf/help-center?s=getting-started&h=dataset-viewer). Open Tools > API > Excel Formula.
If you do not see the right panel with Tools, open your browser window in full screen mode or look in the API menu along the top. It will look like this:
The resulting Excel formula includes the dataset ID, date and transform fields, and dimensions in the required sequence for your selection. These formulas are described in more detail in a later section.
From here you have two options: Open in Excel and Copy.
Open in Excel to include dates and metadata
Click "Open in Excel" on the lower right to immediately download the =Knoema.GETA() formula into a new file. The file will contain both data and metadata for your selected time series.
Copy to include only the data
Copy the provided =Knoema.GET() formula into Excel to add only the data. Additional information such as dates will need to be added separately, e.g., using the Knoema.GETDATES() function. This approach can be useful if you are building a large highly parameterized spreadsheet.
You do not need to copy and paste this formula to all cells of the column. The results from the cell with the formula spill into the adjacent cells, which means that if additional data is added to the dataset, it will be automatically included with a refresh of your workbook.
To quickly add date labels to your new data, modify your formula to =Knoema.GetDates(rest of your formula) but remove any transform or transform placeholder (“ ”), which is in the third position in your formula. See “DataFinder Add-In Commands” below.
