Skip to content
Trio Travel guide

Import Restaurants from Excel

On this page
  1. Open Restaurants and download the template
  2. Fill the four columns
  3. Upload the file and follow the task
  4. Check saved records before retrying
  5. Read the rejection report
  6. Correct the existing record

Open Restaurants and download the template

Open Restaurants in Settings. Use Import for restaurant records. Import Meals is a separate action for meals and their prices.

1 The list shows serial number, restaurant name, telephone, country and city. One restaurant existed before this example.
The list shows serial number, restaurant name, telephone, country and city. One restaurant existed before this example.

Open the Import arrow and download Example for the upload template and Catalog for column guidance and references. The catalog contains Catalog, Countries and Cities sheets. Use references appropriate to your company.

2 The downloaded template has four headers and no data rows. Keep the headers unchanged and enter data from row 2.
The downloaded template has four headers and no data rows. Keep the headers unchanged and enter data from row 2.

Fill the four columns

3 The two demo rows use Egypt/Cairo for A and the nonexistent test country number 999999999 for B. That number is included only to demonstrate...
The two demo rows use Egypt/Cairo for A and the nonexistent test country number 999999999 for B. That number is included only to demonstrate the result; do not use it for normal data.

restaurant_name: enter a clear restaurant name. DEMO-XLS-REST-20261115-A and DEMO-XLS-REST-20261115-B identify this example.

phone: enter the telephone value. Keep it as text when a leading zero must be preserved. DEMO-PHONE-A and DEMO-PHONE-B are training values.

country: use a valid country reference; the example uses Egypt. Read the column catalog before using numeric reference values.

city: enter the appropriate city, such as Cairo. If reference names repeat, verify both city and country on the saved record.

Read the header comments or Catalog sheet for meanings and rules. Keep a copy of the input workbook before uploading.

Upload the file and follow the task

Choose Import and select the prepared Excel workbook. Check its filename in the confirmation, then choose Yes once.

4 The confirmation names restaurants-demo-mixed.xlsx. No returns without uploading.
The confirmation names restaurants-demo-mixed.xlsx. No returns without uploading.

Open Background tasks to follow the result. If the page is slow, check the existing task before uploading the file again.

5 The task shows Completed, 1 succeeded and 1 rejected. Completion does not mean both rows were accepted.
The task shows Completed, 1 succeeded and 1 rejected. Completion does not mean both rows were accepted.

Check saved records before retrying

6 After upload, A appears as serial 2 and B as serial 3, bringing the total to 3. B exists in the list with a dash for its country.
After upload, A appears as serial 2 and B as serial 3, bringing the total to 3. B exists in the list with a dash for its country.

Check the names, serials, telephone, country and city. B already exists in this example, so do not resend it as a new record.

A row in the rejection report must be checked against the saved list before a retry. Correct an existing record in place. If no record exists, review the reason and correct only the affected rows before another upload.

Read the rejection report

Choose Download details on the task and open the report. Compare it with your original input workbook.

7 The report contains restaurant_name, phone, country, city and error. B is shown with country 999999999 and city 154257.
The report contains restaurant_name, phone, country, city and error. B is shown with country 999999999 and city 154257.
8 The error message says the request could not be completed due to a system problem and asks you to contact the administrator if it persists.
The error message says the request could not be completed due to a system problem and asks you to contact the administrator if it persists.

restaurant_name identifies the restaurant; phone, country and city describe its details; error contains the reported reason. Do not add error to the original input template.

The report changes the city from Cairo to a number. Refer to the original workbook and the saved record; do not assume the report is ready to upload unchanged.

Correct the existing record

Open the menu for B, serial 3, and choose Edit. Select Egypt in Country, then select Cairo again in City. Changing the country cleared the city in this example, so review it before saving.

9 The Edit form shows B with the selected country and city. Choose Save to correct that existing record.
The Edit form shows B with the selected country and city. Choose Save to correct that existing record.
10 B remains serial 3 with Egypt and Cairo. The total remains 3. B was not reuploaded and no record was deleted.
B remains serial 3 with Egypt and Cairo. The total remains 3. B was not reuploaded and no record was deleted.

Sign in to record the lessons you have read. Sign in