--- title: "Automated Exports" description: "Automatic TapHome exports of device values, access logs and attendance to Google Sheets (IMPORTDATA) or Excel Power Query as CSV, JSON, XLSX or XML." url: "https://taphome.com/en/docs/exports/" language: en lastmod: 2026-11-01 generator: hugo ai: topics: ["automated-exports","data-export","device-statistics","access-log","attendance-tracking","google-sheets","microsoft-excel"] questions: ["How do I export device data from TapHome to Google Sheets?","What export formats are supported by TapHome automated exports?","What is the maximum number of rows allowed in a TapHome export?","How do I set up an attendance export in TapHome?","How do I configure access log exports for my TapHome access system?","Can statistics be recalculated if they were disabled?","What sampling intervals are available for device value exports?"] --- # Automated Exports Last updated: 2026-11-01 > [!NOTE] > πŸš€ **Available** β€” Core 2025.2 or newer. Automatic exports enable automated data collection and reporting from your TapHome system. This functionality stores all export parameters and allows you to: - Configure automatic data fetching in Google Sheets and Microsoft Excel (or other tools) - Manually download predefined reports from the app for the most recent period - Manually download custom reports for selected time ranges Data are stored in cloud storage at `https://data.taphome.com/api/export/profile//` and are available in CSV, JSON, XLSX, or XML formats. ### Export types Automatic exports support three different data types: ### [Device values](https://taphome.com/en/docs/exports/#hodnoty-zariadeni) Export of sensor values, device states, and calculated statistics (temperature, energy consumption, etc.) ### [Access log](https://taphome.com/en/docs/exports/#pristupovy-system) Chronological record of access system events (who, when, which reader, allowed/denied, reason) ### [Attendance](https://taphome.com/en/docs/exports/#dochadzka) Pre-formatted attendance reports based on access system data, showing arrival/departure times and hours worked ### Device values Export of sensor values, device states, and calculated statistics (temperature, energy consumption, etc.). This is the most commonly used export type. #### How it works #### 1. **Data Sources (Columns)** Specify from which devices and which values you want to export: - Device: e.g. Thermostat, Temperature sensor - Value type: e.g. Set temperature, Current temperature - Aggregate function: **Average**, **Minimum**, **Maximum**; for meters **Sum/Integral** (energy per row) instead of the average > [!NOTE] > The statistics are calculated and stored continuously for each device. Disabling them will prevent generating a complete export, as historical data cannot be recalculated later. #### 2. **Sampling Interval (Rows)** Specifies how frequently data are recorded. Each row in the export represents one sampling interval. Available intervals: 5 minutes, 10 minutes, 15 minutes, 30 minutes, 1 hour, 12 hours, 1 day, 1 week, 1 month, 1 quarter (3 months), 1 year. Example: With an interval of 1 hour, the export will contain one row per hour. #### 3. **Export Range** Defines how much data is generated for each export (how much historical data). > [!TIP] > If you set: > - Export range: 3 days > - Sampling interval: 1 hour > > The export will contain: **72 rows** (3 days Γ— 24 hours = 72 rows) #### 4. **Live data update** Set when new data are generated. - **Every day**: e.g. every 2 days at 14:30 - **Every week**: e.g. every 3 weeks, on Monday at 09:00 - **Every month**: e.g. every month, on the 15th at 12:00 - **Every year**: e.g. every year, on 25.12 at 18:00 #### Step by step: Create an export #### Step 1: Create a new export 1. Open the exports list 2. Click **Define a new export** 3. Enter the export **Name** #### Step 2: Set data sources 1. In the **Data Sources (Columns)** section, click **Add column** 2. Select the device (e.g. Thermostat) 3. Select the value type (e.g. Set temperature) 4. Select the aggregate function (**Average**, **Minimum**, **Maximum**) 5. Repeat for all required columns > [!TIP] > Example: Each row contains: Thermostat Set Temperature (1h average), Thermostat Temperature (1h minimum), Light Sensor Brightness (1h maximum). #### Step 3: Set the sampling interval 1. In the **Sampling Interval (Rows)** section, choose the interval 2. Recommendations: - 5–15 min – for detailed data (large export) - 1 hour – for general use - 1 day/week – for long-term trends (small export) #### Step 4: Set the export range 1. In the **Export Range** section, enter the number of periods 2. Check the number of rows in the summary 3. Warning: The export must not exceed 100 000 rows > [!TIP] > Example: Exported data will contain 1286 rows for a 3-day period. #### Step 5: Set automatic updates 1. In the **Live data update** section, enable the export (**Enabled**) 2. Set the generation frequency (e.g. every month, on the 1st day at 00:00) 3. Save the export #### Step 6: Get the export URL After saving, the app will automatically generate the URL: ``` https://data.taphome.com/api/export/profile//data.csv https://data.taphome.com/api/export/profile//data.json https://data.taphome.com/api/export/profile//data.xlsx https://data.taphome.com/api/export/profile//data.xml ``` The token is generated automatically by the app. #### Important notices - **Activation of statistics:** When you save the export configuration, the system automatically enables all required statistics for the exported devices. These statistics are calculated and stored continuously. Important: Statistics cannot be calculated retroactively β€” if you disable them, historical data will be permanently lost. - **Internet connection:** The control unit can store data for several hours without an internet connection. In the event of a long outage, older data must be deleted to avoid memory overrun. - **Critical data:** For critical data, we recommend using an alternative data collection solution. - **Row limit:** The maximum number of rows in an export is 100 000. ### Access system The access log export generates a chronological record of events – who, when, and on which reader was accepted or denied, and the reason. #### What the export contains Each row in the export represents a single access system event with the following data: - User – full name - Date and time – exact time of the event - Card reader – name and location of the reader - Result – Allowed / Denied - Reason – reason for denial (if relevant) #### Export configuration 1. Create a new export of type **Access log** 2. Enter the export **Name** 3. Choose the time period for the export (export range) 4. Set automatic updates (optional) 5. Save the export and obtain the download URL The export is available in CSV, JSON, XLSX, or XML formats. ### Attendance The attendance export, based on data from the access system, generates a clear report showing when employees arrived and left, and how many hours they worked. #### Prerequisites > [!WARNING] > You must have readers configured as "check-in" (building entry) and "check-out" (building exit). There must be at least one card reader. > [!WARNING] > Each access card must be assigned to a named user. #### Export configuration 1. Create a new export of type **Attendance** 2. Enter the export **Name** 3. **Check-in card readers**: - Select the readers used for entering the building (entrance readers) 4. **Check-out card readers**: - Select the readers used for exiting the building (exit readers) 5. Choose the time period for the export 6. Set automatic updates (optional) 7. Save the export and obtain the URL #### What the export contains Each row represents one working day for an employee: - Date – working day - Name – employee - First check-in – time of first entry into the building - Last check-out – time of last exit from the building - Time inside [hh:mm] – total time spent inside the building - Time outside [hh:mm] – total time of breaks outside the building #### Time calculation If the access card has an assigned user and the user entered the building on that day using a reader, a row is created in the table. Only records with successful access are considered. - Time inside [hh:mm] – sum of time differences between arrivals and departures. If the user had an arrival (without a departure) or a departure (without an arrival) several times in a row, only the first is considered. - First check-in – time of the first entry into the building. - Last check-out – time of the last exit from the building. - Time outside [hh:mm] – sum of time differences between exits and entrances. In standard cases, when an arrival is followed by an exit and after the exit there is a pair of arrival–exit (or more pairs), the following holds: Time inside + Time outside = Last check-out – First check-in #### Format The export is available in XLSX format (recommended) and includes a preformatted table ready for further processing. ### Integrations All three export types (Device Values, Access System, Attendance) can be integrated with Google Sheets and Microsoft Excel using the URLs generated by the app. #### Google Sheets Steps: 1. In the **Download report** dialog in the app, copy the CSV URL 2. Open Google Sheets 3. Paste this formula into any cell: ``` =IMPORTDATA("https://data.taphome.com/api/export/profile//data.csv") ``` 4. The data will automatically update in the background #### Microsoft Excel > [!NOTE] > Requires desktop Excel with Power Query (not available in the web version of Microsoft 365). **XLSX (Recommended)** Recommended format: XLSX Steps: 1. Data β†’ Get Data β†’ From Web 2. Paste the URL: [https://data.taphome.com/api/export/profile/](https://data.taphome.com/api/export/profile/)/data.xlsx 3. Click OK β†’ Close & Load **CSV** Alternative format: CSV Steps: 1. Data β†’ Get Data β†’ From Web 2. Paste the URL: [https://data.taphome.com/api/export/profile/](https://data.taphome.com/api/export/profile/)/data.csv 3. In Power Query Editor, set the delimiter and data types 4. Click Close & Load **XML** Alternative format: XML Steps: 1. Data β†’ Get Data β†’ From Web 2. Paste the URL: [https://data.taphome.com/api/export/profile/](https://data.taphome.com/api/export/profile/)/data.xml 3. Select the data table in the Navigator 4. Click Close & Load **See also** β€” [Export device descriptions](https://taphome.com/en/docs/configuration/export-description/), [Make.com Integration Example](https://taphome.com/en/docs/configuration/make-com-integration/).