--- title: "Open Exchange Rates Connector | OWOX Data Marts" canonical: "https://www.owox.com/data-sources/open-exchange-rates" updated: "2026-09-29" --- ![Open Exchange Rates logo](https://cdn.owox.ai/www/webflow/679a01a3971c7e05d0d522c3_178.svg/public) # Collect Open Exchange Rates data. Deliver reports. Automate AI Insights. Easily collect OpenExchangeRates data with OWOX Data Marts, store in your data warehouse, automate reporting across major BI Tools and AI Insights (the ones that matter) delivered straight to corporate messengers on a schedule. [Get started free](https://www.owox.com/app-signup) ![Open Exchange Rates](https://cdn.owox.ai/www/portfolio-management-data-source/open-exchange-rates/hero/1.png/public) ## Available connectors [Exchange Rates to Google Sheets Connector](/connectors/free-open-exchange-rates-connector-to-google-sheets) [Open Exchange Rates Connector to Azure Synapse](/connectors/open-exchange-rates-connector-to-azure-synapse) [Open Exchange Rates Connector to ChatGPT](/connectors/open-exchange-rates-connector-to-chatgpt) [Open Exchange Rates Connector to Claude](/connectors/open-exchange-rates-connector-to-claude) [Open Exchange Rates Connector to Microsoft Excel](/connectors/open-exchange-rates-connector-to-microsoft-excel) [Open Exchange Rates Insights to Email](/connectors/open-exchange-rates-insights-to-email) [Open Exchange Rates Insights to Google Chat](/connectors/open-exchange-rates-insights-to-google-chat) [Open Exchange Rates Insights to Microsoft Teams](/connectors/open-exchange-rates-insights-to-microsoft-teams) [Open Exchange Rates Insights to Slack](/connectors/open-exchange-rates-insights-to-slack) [Open Exchange Rates to AWS Athena Connector](/connectors/free-open-exchange-rates-connector-to-aws-athena) [Open Exchange Rates to AWS Redshift Connector](/connectors/free-open-exchange-rates-connector-to-aws-redshift) [Open Exchange Rates to Databricks Connector](/connectors/free-open-exchange-rates-connector-to-databricks) [Open Exchange Rates to Google BigQuery Connector](/connectors/free-open-exchange-rates-connector-to-google-bigquery) [Open Exchange Rates to Looker Connector](/connectors/free-open-exchange-rates-connector-to-looker-studio) [Open Exchange Rates to Snowflake Connector](/connectors/free-open-exchange-rates-connector-to-snowflake) ## Endpoints ## Open Exchange Rates endpoints [Documentation](https://docs.owox.com/packages/connectors/src/sources/open-exchange-rates/readme/) 1 Open Exchange Rates endpoints you can import. Each lands in its own table in your warehouse. * ### [Historical exchange rates data](#schema-historical-exchange-rates-data) Contains historical exchange rates for different currencies relative to a base currency 4 fields · Time series ## Historical exchange rates data schema ## Open Exchange Rates Historical exchange rates data schema 4 fields · Time series · `open_exchange_rates_historical` · [Schema on GitHub](https://github.com/OWOX/owox-data-marts/blob/main/packages/connectors/src/Sources/OpenExchangeRates/OpenExchangeRatesAPIReference/historical-fields.js) Contains historical exchange rates for different currencies relative to a base currency | Field | Type | Description | | --- | --- | --- | | `date` | DATE | Date of exchange rate | | `base` | STRING | Base currency | | `currency` | STRING | Target currency | | `rate` | NUMBER | Exchange rate | ## S01 · Why teams pick OWOX ## Why collect Open Exchange Rates data into your warehouse with OWOX? Your Open Exchange Rates data shouldn’t be trapped in a platform you can’t query. OWOX collects it into your warehouse on autopilot — no per-connector fees, no vendor lock-in. The entire platform is open-source on GitHub, so you can self-host it today and never worry about losing access to your own data pipelines. ![The Set Up Connector dialog in OWOX Data Marts at step 1 of 5, listing the connectors available to choose from.](https://cdn.owox.ai/www/webflow/6a043cc99b38463750b8ea95_connectros-data-source-list.png/public) ### Collect to your warehouse No per-connector pricing — connect as many sources as you need, all included ![The Create Scheduled Trigger dialog in OWOX Data Marts, setting a connector run to repeat daily at 09:00.](https://cdn.owox.ai/www/portfolio-management-data-source/criteo/body/1.png/public) ### Zero-maintenance syncs Fully open-source on GitHub — self-host anytime, no vendor lock-in, your data stays yours ![The Joined Data Marts SQL dialog in OWOX Data Marts, showing the generated SQL that joins an orders data mart with unified ad spend and reporting it as valid.](https://cdn.owox.ai/www/portfolio-management-data-source/criteo/body/2.png/public) ### Full-funnel joins Full transparency and control — every query, every schema, every schedule is visible and auditable [Get started free →](https://www.owox.com/app-signup) ## How it works ![OWOX Data Marts data setup for Open Exchange Rates, with the Open Exchange Rates input source feeding Google BigQuery, AWS Athena, Snowflake, Amazon Redshift and Databricks.](https://cdn.owox.ai/www/portfolio-management-data-source/open-exchange-rates/hero/1.png/public) R01 · Collect ## Collect all your Open Exchange Rates data with zero engineering Pull everything your company needs from OpenExchangeRates without touching code or maintaining custom scripts. OWOX Data Marts handle the heavy lifting. * Your exchange rate data is stored in one place – your own infrastructure. OWOX Data Marts automatically land your data into BigQuery, Snowflake, or Redshift. * Your OpenExchangeRates data lands on a schedule: clean, complete, and ready to re-use across reports, dashboards, BI tools, and spreadsheets. * No API maintenance, no broken scripts — just reliable daily syncs [Explore data marts →](https://www.owox.com/app-signup) ![OWOX Data Marts data setup for Open Exchange Rates, with Open Exchange Rates data delivered to Google Sheets, Looker Studio, Slack, Microsoft Teams and email.](https://cdn.owox.ai/www/portfolio-management-data-source/open-exchange-rates/body/1.png/public) R02 · Report ## Build reports with Open Exchange Rates data that everyone trusts Once your exchange rate data lands in your warehouse, OWOX Data Marts make it instantly reusable across spreadsheets and BI tools. * Pre-built data marts for multi-currency financial reporting * Join exchange rates with ad spend, revenue, and CRM data in one query * Self-serve reporting for finance teams — no analyst tickets needed [Explore data marts →](https://www.owox.com/app-signup) ![The OWOX Data Marts side panel open in Google Sheets, building an eCommerce report from a products data mart with its columns selected.](https://cdn.owox.ai/www/webflow/69f4fbc009ea60814be448c5_product-frame.webp/public) R03 · Visualize ## Visualize Open Exchange Rates data instantly in your BI tools With OWOX Data Marts, your exchange rate data becomes instantly available for charts, dashboards, pivots, and spreadsheets. * Whether you use Google Sheets, Looker Studio, Excel, or Power BI, OWOX delivers clean, scheduled exchange rate data that just works. * Deliver to Looker Studio, Google Sheets, Power BI, or Excel automatically * Same numbers everywhere — one source of truth for all stakeholders [Get started free →](https://www.owox.com/app-signup) ## S03 · Eight outcomes ## Why use OWOX connectors to collect your Open Exchange Rates data? Eight outcomes you get the moment your data marts go live. ### Full picture, one screen Bring live and historical exchange rates into your warehouse from one governed source — the quiet fix that makes global numbers line up. ### Beyond native dashboards Revenue in many currencies never reconciles until it’s converted consistently; OWOX lands rates alongside your data to do exactly that. ### Your questions, your reports Build reports in a single reporting currency — so regional numbers roll up correctly instead of drifting apart. ### Faster decisions, better data When “the numbers don’t match” across markets, standardized rates in your warehouse are usually the reason they finally do. ### Always fresh, always complete OWOX Data Marts automate exchange-rate collection on a schedule — daily rates, every currency pair you need — with no manual entry. ### All sources, one warehouse Merge rates with Shopify, ad spend, and finance data so every metric is comparable across countries. ### Zero manual work Automate transfer into BigQuery, Snowflake, or Redshift — governed and reusable across every report, saving time and removing errors. ### Blended reports Once rates live in governed Data Marts, anyone can ask in their own AI chat — “what was global revenue in USD last month?” — every number tracing to analyst-written SQL. ## What users are saying ## Not testimonials. Comment threads. Real things real customers said — each quote pinned to a specific claim, straight from the quotes database. A3 · re: trusting AI ![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public) Nodari Rizun · Founder & CEO, Pürblack® > _“AI, by the nature of the models, will hallucinate. And because of that, you need something which will create guardrails to ensure that there are no hallucinations, that you can trust your data.”_ C9 · re: one source of truth ![Mark Simmons](https://cdn.owox.ai/www/webflow/6a7b298b2b9daab0ade631d7_mark-headshot.png/public) Mark Simmons · CMO, Pürblack® > _“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”_ E7 · re: getting time back ![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public) Nodari Rizun · Founder & CEO, Pürblack® > _“We regained time. And time is the one resource that never comes back.”_ ## Start collecting Open Exchange Rates data for free Set up your Open Exchange Rates connector in minutes. No credit card, no engineering team required. [Get started free](https://www.owox.com/app-signup) ![Open Exchange Rates](https://cdn.owox.ai/www/webflow/6a043cc9dce0415e2d0f6a01_data-marts-list-connector.png/public) ## References Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link. - [Get started free](https://www.owox.com/app-signup) - [Exchange Rates to Google Sheets Connector](https://www.owox.com/connectors/free-open-exchange-rates-connector-to-google-sheets) — /connectors/free-open-exchange-rates-connector-to-google-sheets.md - [Open Exchange Rates Connector to Azure Synapse](https://www.owox.com/connectors/open-exchange-rates-connector-to-azure-synapse) — /connectors/open-exchange-rates-connector-to-azure-synapse.md - [Open Exchange Rates Connector to ChatGPT](https://www.owox.com/connectors/open-exchange-rates-connector-to-chatgpt) — /connectors/open-exchange-rates-connector-to-chatgpt.md - [Open Exchange Rates Connector to Claude](https://www.owox.com/connectors/open-exchange-rates-connector-to-claude) — /connectors/open-exchange-rates-connector-to-claude.md - [Open Exchange Rates Connector to Microsoft Excel](https://www.owox.com/connectors/open-exchange-rates-connector-to-microsoft-excel) — /connectors/open-exchange-rates-connector-to-microsoft-excel.md - [Open Exchange Rates Insights to Email](https://www.owox.com/connectors/open-exchange-rates-insights-to-email) — /connectors/open-exchange-rates-insights-to-email.md - [Open Exchange Rates Insights to Google Chat](https://www.owox.com/connectors/open-exchange-rates-insights-to-google-chat) — /connectors/open-exchange-rates-insights-to-google-chat.md - [Open Exchange Rates Insights to Microsoft Teams](https://www.owox.com/connectors/open-exchange-rates-insights-to-microsoft-teams) — /connectors/open-exchange-rates-insights-to-microsoft-teams.md - [Open Exchange Rates Insights to Slack](https://www.owox.com/connectors/open-exchange-rates-insights-to-slack) — /connectors/open-exchange-rates-insights-to-slack.md - [Open Exchange Rates to AWS Athena Connector](https://www.owox.com/connectors/free-open-exchange-rates-connector-to-aws-athena) — /connectors/free-open-exchange-rates-connector-to-aws-athena.md - [Open Exchange Rates to AWS Redshift Connector](https://www.owox.com/connectors/free-open-exchange-rates-connector-to-aws-redshift) — /connectors/free-open-exchange-rates-connector-to-aws-redshift.md - [Open Exchange Rates to Databricks Connector](https://www.owox.com/connectors/free-open-exchange-rates-connector-to-databricks) — /connectors/free-open-exchange-rates-connector-to-databricks.md - [Open Exchange Rates to Google BigQuery Connector](https://www.owox.com/connectors/free-open-exchange-rates-connector-to-google-bigquery) — /connectors/free-open-exchange-rates-connector-to-google-bigquery.md - [Open Exchange Rates to Looker Connector](https://www.owox.com/connectors/free-open-exchange-rates-connector-to-looker-studio) — /connectors/free-open-exchange-rates-connector-to-looker-studio.md - [Open Exchange Rates to Snowflake Connector](https://www.owox.com/connectors/free-open-exchange-rates-connector-to-snowflake) — /connectors/free-open-exchange-rates-connector-to-snowflake.md - [Documentation](https://docs.owox.com/packages/connectors/src/sources/open-exchange-rates/readme)