Working With Excel Online

You are here:
Table of Contents

Ventipix Asset & Inventory Manager platform supports three interactions with Excel Online.

Point-in-time syncing

You can choose to have the platform sync a copy of your data as it is at the current moment. This only works whilst you’re logged in to your account.

From the tables, go to Options > Sync With Excel Online

You will then be shown this prompt.

Fill out the form accordingly, then click on the Sync button.

Continuous Syncing

This type of syncing works whether you are logged in to your account or not.

Any data that you create is automatically synced to the nominated file.

Note – the nominated file should not be edited manually as the platform will not be aware of the changes you made and may overwrite your data.

From the Apps page, click on the Settings button.

Fill out the form.

  • File Name – Choose the file that we should sync to. Only .xlsx files will be shown.
  • Services to be logged – choose the type of services you want to be synced. Each chosen service will be created as a worksheet, on the chosen file, and whenever you create data on the platform, the same data will be synced.
  • Status – indicate whether you want the syncing to be active or not.

Sending barcode scans or NFC tag taps directly to Excel Online spreadsheets

Tap on the Scan to Spreadsheet button, on the pages that display it.

On the new page, choose Excel Online from the dropdown options.

On the prompt that appears, fill out the form with the relevant details.

Scroll down that pop-up, to continue filling out the required details.

Refer to the notes beneath the input fields.

Once you click on the Start Scanning button, the paired device will be ready to scan or tap NFC tags.