---
title: "Querying Data from Lucanet"
description: "You can use CFP Add-In for Excel 365 to selectively read in data from Lucanet to MS Excel. This allows you to populate reports created in MS Excel at the push of a button. As Lucanet saves all data in a central database, all reports are available with the current values from Lucanet at all times."
source_url: https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/querying-data
language: en
last_updated: 2023-08-16
---
# Querying Data from Lucanet

## Overview

You can use CFP Add-In for Excel 365 to selectively read in data from Lucanet to MS Excel. This allows you to populate reports created in MS Excel at the push of a button. As Lucanet saves all data in a central database, all reports are available with the current values from Lucanet at all times.

The following can be queried:

- [Values](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/querying-data/querying-values.md)
- [Exchange Rates](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/querying-data/querying-exchange-rates.md)
- [Comments](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/querying-data/querying-comments.md)
- [Attributes](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/querying-data/querying-attributes.md)

For data to be read in to MS Excel, [LUCANET formulas](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/querying-data/lucanet-formulas.md) must be specified in the Excel workbook. You can use parameters to define which data are to be imported to MS Excel. You can use parameters to define which data are to be read in to MS Excel.