Question 1

How do I export my data to CSV?

Accepted Answer

Mataee lets you easily export all your time tracking data in CSV format, for analysis, archiving, or sharing with your accounting team.
Accessing the CSV export
Go to the Reports section of your Mataee workspace. Select the desired period (week, month, quarter, or custom range) and your chosen filters (project, member, client, billing status).
Running the export
Once your criteria are set, click the "Export to CSV" button located at the top right of the report page. The file is generated instantly and downloaded to your computer.
Content of the exported file
The CSV file includes all time entries matching your criteria, with the following information:

Date of the entry
Team member
Associated project and task
Related client
Duration in minutes, decimal and sexagesimal format (hh:mm)
Amount calculated according to the applicable hourly rate
Billing status (billable, non-billable, invoiced)

Compatibility
The CSV format generated by Mataee is directly compatible with Microsoft Excel, Google Sheets, and LibreOffice Calc. UTF-8 encoding and the semicolon separator ensure correct display of special characters and columns in spreadsheet applications.
Common uses
The CSV export is particularly useful for preparing client invoices, feeding your accounting tools, performing profitability analyses, or simply keeping a record of your data outside of Mataee.
Discover all the reporting and export tools available on our Features page.

Question 2

What reports are available?

Accepted Answer

Mataee offers several types of reports to give you a clear view of your team's activity, your projects' profitability, and your billing progress.
Weekly and monthly reports
View a summary of hours logged for the current week or month. These reports provide a synthetic view of time spent, with the ability to compare periods to identify trends.
View by project
Analyze the time spent on each project, with details by task and by member. Compare actual hours to the estimated budget to anticipate overruns and adjust your planning.
View by member
Track each collaborator's workload. Quickly identify distribution imbalances and ensure no one is overloaded or underutilized.
View by client
Group all hours and amounts by client. This view is ideal for preparing invoicing and measuring each client's share of your revenue.
Supervision dashboard
The supervision dashboard centralizes your business's key indicators:

Budget alerts: receive a notification when a project approaches or exceeds its time or financial budget.
Profitability indicators: compare billable amounts to internal costs to evaluate each project's margin.
Billing rate: measure the proportion of billable hours relative to total hours logged.

Billing view
Track the billing status of your projects: billable hours, already invoiced hours, and hours remaining to be invoiced. Easily identify outstanding amounts and projects that need follow-up.
All these reports are exportable in CSV format for in-depth analysis in your spreadsheet. Find the details of these features on our Features page.

Question 3

Can I filter my exports by project or by period?

Accepted Answer

Yes, all Mataee exports support an advanced filtering system that lets you get exactly the data you need.
Available filters
Before running an export, you can apply one or more of the following filters:

Period: select a precise date range (day, week, month, quarter, or custom period) to limit the export to the corresponding time entries.
Project: choose one or more specific projects to export only the data related to them.
Member: filter by collaborator to get the detailed hours of a particular member or group of members.
Client: isolate data related to a specific client, ideal for preparing invoicing.
Billing status: export only billable, non-billable, or already invoiced hours based on your needs.

Combining filters
The power of the system lies in combining filters. For example, you can export the billable hours of a specific member, on a given project, for the past month. This lets you produce perfectly targeted reports without having to manually reprocess the data in a spreadsheet.
How to apply filters
Go to the Reports section, then use the dropdown menus and date selector at the top of the page. The displayed results update in real time. Once satisfied with the selection, click "Export to CSV" to download the filtered file.
A daily time saver
Thanks to these filters, you avoid tedious manipulations in Excel and save valuable time, especially when preparing monthly invoicing or quarterly reviews. This is one of the many advantages of a dedicated tool compared to a traditional spreadsheet.

Question 4

Are exported data compatible with Excel?

Accepted Answer

Yes, files exported from Mataee are fully compatible with Microsoft Excel, as well as Google Sheets and LibreOffice Calc.
Format and encoding
Exports are generated in CSV (Comma-Separated Values) format with the following characteristics:

UTF-8 encoding with BOM: ensures correct display of accented and special characters (e, e, c, etc.) in all spreadsheet applications.
Semicolon separator (;): this is the standard expected by French-language versions of Microsoft Excel, allowing direct opening without any configuration step.
Readable and standardized date format for easy sorting in the spreadsheet.

Opening in Excel
Simply double-click on the downloaded CSV file. Excel automatically recognizes the format and displays the data in separate columns. No import or conversion steps are needed.
Opening in Google Sheets
Import the CSV file from the File > Import menu in Google Sheets. The file is natively supported with automatic separator detection.
Opening in LibreOffice Calc
LibreOffice Calc opens CSV files by displaying an import wizard. Select UTF-8 encoding and the semicolon separator for optimal display.
Why switch from Excel to a dedicated tool?
If you still use a spreadsheet to track your team's time, you know the limitations: data entry errors, broken formulas, shared files that are hard to synchronize. Mataee centralizes your data and lets you export it to Excel whenever you need it. Discover in our article Excel vs. time tracking software why a dedicated tool saves your agency time.

Frequently asked questions

Exports and reports

Can't find your answer?