EBS: Downloaded Contact Data And/or Notification Data Is Not Properly Displayed When Imported Into a New Excel File in Everbridge Suite

Problem:

When downloading Everbridge data such as contact data or notification data, it is not displayed properly when imported into an Excel file.

Root Cause:

There is a problem with the file format.

Solution:

Follow the steps below to properly format the data:

Excel Get External Data
  1. Create and open a new Excel file.
  2. Click the Data tab.
  3. Select Get External Data from the far left, then From Text from the drop-down menu.
From Text Excel
Export Wizard 1
  1. Locate and open the desired file.
  2. Select the radio button next to Delimited, enter the value for the row to start the import on, and click Next.
Export Wizard 2
  1. Leaving Tab selected, select the checkbox next to Comma under the Delimiters heading and click Next.
Export Wizard 3
  1. Under Data preview, scroll all the way to the right until the End column displays, then hold the shift key and click on the very last column.
  2. Under the Column data format options, select the radio button for Text.
  3. Click Finish.
  4. Select the desired location to save or open the worksheet and click OK.

For further reference on importing CSV files to Excel, please view the article found at https://www.ablebits.com/office-addins-blog/2014/05/01/convert-csv-excel/#open-csv-excel.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.