Skip to main content

How to update my information using an Excel file?

Written by Sébastien Blum

This article was automatically translated by artificial intelligence. For accurate information, please refer to the original English version.

If you manage multiple Business, you can update certain information via Excel file directly from the Partoo application.

If you manage only one Business, you can edit your information directly from the Partoo editing interface (learn more).

If the Bulk edit option is not available from your Partoo interface, we recommend contacting your internal company representative.

What information can be updated via Excel file from the Partoo application?

Here is the information that can be edited via Excel file from the Partoo application:

  • Hours (normal and Special hours)

  • Descriptions (long and short)

  • Contacts (phone and email)

  • URLs (website and Facebook URL)

Only the following information (hours, descriptions, contacts, and Google / Facebook URLs) can be exported.

For Bulk edit on fields not listed above or if you want access to other information via Excel file, please contact us by clicking the blue bubble at the bottom right.

How to update my information via Excel file from the Partoo application?

Here is the procedure to update your information via Excel file:

  1. Once logged into Partoo, in the "Business" tab, click the "Bulk edit" button

  2. Click "Export data" to export all your data or select the Business (1) for which you want to export information, then the sections (2) to export. Refer to the list above for section content details.

  3. Go to your emails and download your data from the email titled "Data extraction"

  4. Then fill in the Excel file following the instructions indicated in the file (line 2) and save the modified file

  5. Return to the "Bulk edit" page of the application, click "Import your data" then "Upload or drag your file here", select your file and validate (you can also drag and drop it into the box)

  6. Once the upload is complete, click "Update fields"

  7. Then go back to your emails and open the email titled "Integration report". If the email says "Success", your data has been updated! 🔥

  • If not, follow the next steps.

    1. If your import failed, click "Download report". Cells containing errors are highlighted in red.

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

How to fill in the information in the Excel file?

Once in your Excel file:

Read-only fields must not be modified

The "Business Id" column must not be deleted

Here are the fields to modify:

  • Opening hours

  • Special hours

  • Phone number

  • Email address

  • Short description

  • Long description

  • Your website link

Respect the formats indicated in each column:

  1. Opening hours & Special hours:

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

    • Separate different time slots in the same day with a comma: Here is an example to follow Ex: 08:30-12:30, 14:00-18:00

  2. Phone numbers, email addresses, and your website link must be valid
    ​

  3. Short descriptions must not exceed 80 characters

  4. Long descriptions must not exceed 750 characters
    ​

Related Articles
Did this answer your question?