📚 Legacy Web Query Guide

Integrating with older Excel versions using Web Queries.

Description

For users of older Excel versions (e.g., Excel 2007, 2010, 2013) that might not fully support the WEBSERVICE function, Excel Web Queries (`.iqy` files) provide a robust alternative for importing data directly from the API. This guide explains how to use these files to get holiday data into your spreadsheets.

🧩 Excel Web Query

You can create a .iqy file specifically designed to import holiday data from our API into Excel. This file automates the process of creating a Web Query.

Note: All API endpoints require an API key. Legacy Web Queries cannot send custom HTTP headers, so you must include your key as an api_key query parameter in the URL. Get a free API key →

To create a holidays.iqy file manually, save a plain-text file with the .iqy extension containing the following (replace YOUR_KEY_HERE with your actual key):

WEB
1
https://fincalapi.com/v1/holidays/range?calendar=SIFMA-US&months_ahead=12&format=html&api_key=fincal_live_YOUR_KEY_HERE

Security note: Your API key will be visible in the .iqy file and in Excel's data connection settings. If you are using Excel 2016 or newer, consider using Power Query instead, which supports sending the key via a secure Authorization header.

How to Use:

  1. Create the holidays.iqy file as described above and save it to your computer.
  2. Open Excel.
  3. Go to the Data tab.
  4. In the "Get External Data" group, click From Web.
  5. In the "New Web Query" dialog, paste the full URL (including your api_key) or open the saved .iqy file.
  6. Excel will import a vertical range of holidays into a table.

Once the data is imported, you can use standard Excel formulas to work with the holidays. For instance, to check if a date (in cell A2) is a holiday (assuming your imported holidays are in column D): 

=IF(ISNA(VLOOKUP(A2, D:D, 1, FALSE)), "Not a holiday", "Holiday")