By Emma Street
Publication Date: 2025-11-25 19:02:00
Excel Data Types is a nifty function that you might not know is available. If you’ve got an Excel spreadsheet that needs up-to-the-minute (ish) data about stock market prices, currency exchange rates, or even a country’s carbon emissions, then you can add it with just a couple of clicks. To use it, open an Excel spreadsheet, then enter a company name, currency code, or the name of a country, state, or city in a cell. Then, go to Data on the top toolbar and in the Data Types section, select Stocks, Currencies, or Geography. If there’s more than one option, you can select the one you want. The cell will then display a small icon in the top left – a map for geography, or a stock market building for stocks and currency.
Go to the cell and select the “Insert Data” icon. (a table with a green plus sign). Here, you can choose either “Show Data Type Card” or select a field to insert. “Show Data Type Card” brings up a window containing information about your location,…