Skip to main content
All CollectionsPresence ManagementHow to use Partoo dashboard?
How to update my data in bulk from the Partoo interface?
How to update my data in bulk from the Partoo interface?
Sébastien Blum avatar
Written by Sébastien Blum
Updated this week

If you manage several establishments, you can edit your data in bulk using an Excel file directly from the Partoo application.

If you only manage one establishment, you can edit your data directly from the Partoo editing interface (Learn more).

What data can I update using an Excel file from the Partoo application?

Here is the data that can be edited by Excel file from the Partoo application:

  • Opening times (normal and exceptional)

  • Descriptions (long and short)

  • Contacts (phone & email)

  • URLs (website and social networks)

For bulk edits on fields that are not listed above, please contact us by clicking on the blue bubble at the bottom right.

How do to update data by Excel file from the Partoo application?

Here are the steps to follow to update your classic and specific opening times by Excel file:

  1. Once connected to Partoo, click on "Bulk modification" in the "Businesses" section.

  2. Click on "Export data" to export all your data or select the establishments for which you want to export data and then the sections to export. Refer to the list above to have the details of the sections' content.

  3. Go to your emails, and download your data from the email entitled "Data extract".

  4. Fill in the Excel file following the instructions indicated in the file (line 2) and save the edited file

  5. Go back to the "Bulk modification" page of the application, click on "Import your data" and then on "Upload or Drag and drop your file here", select your file, and validate (you can also drag and drop it in the insert)

  6. Once the upload is finished, click on "Update fields".

  7. Then go back to your emails and open the email entitled "Integration Report". If the email says "Successful", your data has been updated! 🔥

  • If you receive an email that says "Error", follow the next steps :

    1. If your import failed, click on "Download Report". Cells with errors are highlighted in red.

    2. Correct the cells highlighted in red by following the instructions on the file (line 2), save the file, and resume at step 5 of this list.

How to Fill in Information in the Excel File?

Once you have opened your Excel file:

Read-only fields must not be modified.

The "Business ID" column must not be deleted.

The fields to be modified are:

  • Opening hours

  • Specific hours

  • Phone number

  • Email address

  • Short description

  • Long description

  • Your website link

Please adhere to the formats indicated in each column:

  1. Opening hours & exceptional hours:

    • Enter your hours in this format: HH:MM-HH:MM

    • Separate different time slots within the same day with a comma. Example: 08:30-12:30, 14:00-18:00.

  2. Phone numbers, email addresses, and website links must be valid.

  3. Short descriptions must not exceed 80 characters.

  4. Long descriptions must not exceed 750 characters.

Did this answer your question?