Importing Bookings

Prev Next

You can easily import Bookings to Nexudus in a few steps on the Admin Panel.

Click on each of the steps below for step-by-step instructions.

Step 1. Downloading the template

The first step of the process is to download the import template you'll use to add customers. You can get this template from Settings > Imports on the Admin Panel.

  1. Log in to dashboard.nexudus.com if you aren't already.

  2. Click Settings > Imports.

  3. Click on Start import.

  4. Bookings in the drop-down menu.

  5. Scroll down the page and click Download template.

The download should only take a few seconds. You'll find the template file in the Downloads folder of your device.


Step 2. Editing the template

The second step is to add your data to the import template. The example below illustrates how to do this in Excel, but you can use any spreadsheet tool that can open and edit CSV files.

  1. Open the import template file you've downloaded in Step 1.

You should see the column headers in row 1 and a few rows of dummy data underneath.

image.png

  1. Add your space's data in each column following the dummy data's template.

  2. Remove the dummy data rows from the import template, making sure you don't remove any of the column headers.

  3. Save your changes.

Always save your file as a CSV UTF-8 file.

Imports_SaveFormat

You're now ready to format your data before the reupload.


Step 3. Formatting your template

The third step is to ensure your template is properly formatted for a successful import in Nexudus. Make sure you over the following formatting elements before uploading your import template.

Date Columns

All columns that include a date should be set to the yyyy-mm-dd hh:mm format. This format isn't available by default in most spreadsheet tools, but you can add this custom format to your date columns in a few clicks.

Here's how to do it in Excel:

  1. Select the entire date column in your import template.
  2. Right click the column.
  3. Select Format cells.
  4. Click Custom.
  5. Add yyyy-mm-dd hh:mm in the Type field.
  6. Click OK.

The dates in your column should now appear in the right format, for example 2021-10-11 16:00. Repeat the process for every column that includes a date in your import template.

YES or NO Columns

All columns that include YES or NO should always be uppercase.

Address Columns

If your file includes an Address columns, make sure the addresses are between double brackets when they contain one or multiple commas.

For example if your address is 12 Street, XYZ Building, City, you should make sure it is added as "12 Street, XYZ Building, City" in your template.

Columns Including Existing Nexudus Items

All columns that include the name of items that already exist in your Nexudus account must always be an exact match in your import file. The spelling is case-sensitive and includes spacing.

For example, if a product's name in Nexudus is Notepad, the product name in your import file must be Notepad. Using alternative spellings such as Note Pad or notepad will result in an import failure.

Don't reopen your import file once you've saved all your changes and closed the file.

Doing so will automatically reset the custom date format you've defined and you'll need to reformat the date columns a second time.


Step 4. Uploading the edited template

The last step of the data import process is simply to upload your edited import template file back in Nexudus.

  1. Log in to dashboard.nexudus.com if you aren't already.

  2. Click Settings > Imports.

  3. Click on Start import.

  4. Select Bookings in the drop-down menu

  5. Click on Select file.

  6. Select your edited import template file.

  7. Click Open.

The larger your file is, the longer it will take to upload.

You've successfully imported your data into Nexudus.

Couldn't complete the import?

Check out our article on Troubleshooting Import Errors or get in touch with us at support@nexudus.com.


Import columns explained

Column Details Format Required or Optional
CoworkerId Unique identifier of the coworker associated with the booking. Use this if you use IDs over emails to identify users. Numeric ID available in each customer's account. Optional
Email Email address of the customer who made the booking. The customer must already exist in the system. Must exactly match an existing user email (case-sensitive) Required
Start Start date and time of the booking. yyyy-mm-dd hh:mm Required
End End date and time of the booking. yyyy-mm-dd hh:mm Required
Location Location where the booking is created. This field already includes the location from where you downloaded the import file. Must be an exact match (case and spelling) with your location on the Admin Panel. Required
Resource Resource being booked, for example, a room or desk. Must exactly match an existing resource in your location (case-sensitive) Required
Notes Any notes related to the booking. These may be internal or visible to the customer, depending on your setup. Free text Optional
Free Indicates whether the booking is free of charge. TRUE / FALSE Required
DeskName Name of the specific desk assigned to the booking, if applicable. Must exactly match an existing desk name on your floor plan Optional