Skip to main content

Import activities from Excel

How to import several activities into a project at once from an Excel file, and update the dates of activities that already exist.

Written by Thim Smedbrant

When should I use this guide?

  • When you want to create many activities at once, for example from the project schedule.

  • When you want to update the start and end dates of activities that already exist.


Requirements

  • You are a member of the project.

  • Activities is enabled for the project.

  • You have an Excel file in .xlsx format. The easiest way is to start from the Excel template.


How to do it

The import is only available on the web, not in the app. Each row in the file becomes an activity with a name, start date and end date. Only the name is required.

On the web

Open the import

  1. Go to Places and open the project.

  2. Click the Open in App icon next to the project name. The project view opens in your browser, not in the mobile app.

  3. Click Activities in the side menu below the project name.

  4. Open the Upload tab.

Fill in the Excel template

  1. Click Download Excel-template.

  2. Fill in one row per activity in the aktivitet, startdatum and slutdatum columns. The column headings are in Swedish. Do not change them.

  3. Delete the example row with Ex: Stomme.

  4. Save the file as .xlsx.

Dates can be entered as Excel dates or as text, for example 2026-11-03. If you use a file from your planning system, the column headings must be the same as in the template.

Upload and import

  1. Drop the file on the upload area, or click Choose a file and select the file.

  2. Check the preview under Import activities. The Status column shows whether each row becomes a new activity or updates an activity that already exists.

  3. Untick the rows in the Import column that should not be imported.

  4. Click the Import [number] Activities button.

The activities are imported and you are taken to the list of activities.

How existing activities are handled

  • If a row has the same name as an activity in the project, that activity's dates are updated.

  • If you rename an activity in the file, it becomes a new activity. The old activity remains in the list and can be removed there.


If it does not work

First, check that:

  • the file is an Excel file in .xlsx format,

  • the column headings are the same as in the template: aktivitet, startdatum and slutdatum,

  • every row has a name.

If an error says that an activity appears several times

The same name is on several rows in the file. Those rows are not ticked for import. Keep each activity on one row and upload the file again.

If the Upload tab or Activities is missing

The import is only available on the web. If Activities is missing from the project menu, Activities is not enabled for the project. Contact Infobric.


Tips!

  • Start from the template, so that the columns are recognized straight away.

  • Use the same activity names every time you import. Then the dates are updated instead of new activities being created.

  • Once the activities exist, you can add equipment to them. See the guide Plan equipment with activities.

Did this answer your question?