If you cannot find what you are looking for in the ready-made Excels or templates, you can also put together your own file. You can determine yourself which data you want to include, and how to sort the columns.
⚠️ Note: Only Admins can create a custom Excels.
Set up your own Excel
Under 'Data' in the main menu on top, you'll find 'Custom Excels'. On this page, click 'Create new' in the top right corner. Depending on which information you want to see in your table you can now choose from the following categories:
Team members: Export the data per team member. You get all team members in rows under each other.
Hour entries: Export the data per shift from the time registration. Every shift appears on a row.
Planned shifts: Export the data per shift from the schedule. Every shift appears on its own row.
Leave requests: Export the data per leave request. This way you get a leave request on each row with the corresponding data.
Teams: Export the data per team. On each row you get a team.
Venues: Export the data per venue. Each row shows a venue.
Revenue: Export the data per revenue group. Rows represent revenue groups per day.
After you selected a category, you can choose whether you want to set up your Excel from scratch, or if you want to use one of the available templates. This article explains how to create your own from scratch.
After this step, your file will appear under 'My Custom Excel Files' to continue setting it up later, to make changes, or to export.
Select data
Go to 'Columns' (menu on the left) where you can find all data to add to your file. As soon as you select an item, it will appear as a new column.
If you select multiple items and want to change the order of the columns, select the item and choose 'Move'.
On top of this screen you see a preview of your selection, so you can see how your setup will appear in Excel.
Change format of data
For most of the data you can change the format. For example, you can decide to have the name of team members in uppercase, or change the date format. For hour entries you can choose for 'decimals' instead of 'hours and minutes'. You find the 'Format' option by clicking the item.
Move and sort columns
When selecting new data on the left, the items will appear in your selection on the right. On top of the page you can see how the selected data will show in the Excel file later. Editing can be done in the selection on the right.
You can click each item and move it either left or right, which determines where in the Excel file the column goes. In the preview on top of the page you can see the effect of moving the column left or right.
By default the data is sorted on the first column and in an ascending order. So for team members that would be from A to Z. You can sort any data option and choose either an ascending or a descending order.
So, if you want to order the file by team member with the most worked hours, you can sort on 'Hours' in a 'descending' order. This way the team member with the most worked hours appears on the very top in your Excel file.
In the export you will see on which column the data is sorted and if it is in a descending or ascending order by looking at the little arrow icons: ▼ / ▲
Don't forget to save your setup and settings when you're done.
Apply filters
When you are done selecting data and organising your columns, go to the next step in the menu on the left to choose which data you do or do not want to include. This step is called e.g. 'Pick time entries', 'Pick team members', or 'Pick shifts' and are basically filters to make sure you do not get too much unnecessary data in your file. Learn about this step here.
Settings
In the settings you can name the file, give it a description, and determine which roles have access to the file. You can also change the file from Excel (.xlsx) to CSV (.csv).
The type (category) can no longer be changed. This was selected when creating the file, so everything is based on that.
Export to Excel
Your Excel is finished and ready to be exported.
Click 'Export' on top of the page. You will now be asked to select the dates, either by picking a period or by selecting the dates manually (click 'Date' in top right corner).
Now, click 'Export'. When it's done, you can download the file from 'Notifications' in the top right corner of Eitje, or you will find it under 'Files' in the menu on the left of the current page.
Files
In the menu on the left you find 'Files'. On this page you will find all the files (downloads) that have been created. Here you can download previously exported files, or export a new file. Apart from that, you will find the options to duplicate, edit, and delete.
Automatic export
The last option in the menu on the left is the 'Automatic export' setting. Setting up an automatic export allows you to make sure you receive the export by email on a set date and time (e.g. every week or every month). Learn more about the 'Automatic export' option.