Preparing CSV Files
Learn the steps to follow in order to prepare a spreadsheet file.
Each column in a template corresponds to a field in the associated Add/Edit
dialog box. Create new rows in the template by supplying appropriate values
in the fields under each column. After you finish entering data, replace all empty cells
in the spreadsheet with a space to ensure that the cells will be included in the CSV.
When you are finished, delete the header row, and save the template as a CSV file.
To prepare a CSV file:
Open the appropriate template in Microsoft Excel.
Provide information for each entry you want to import on a separate row of the
spreadsheet. For example, if you are importing user data, you provide information for
each user on a separate row of the users-template.xls
See the Vocera Voice Server Data-Loading Reference for information about the data you should provide.
When you finish entering data, follow these steps to replace all empty cells in the
spreadsheet with a space.
Note: If the last column of data in your spreadsheet is empty, Excel produces
inconsistent results when you save to CSV. These steps provide a simple workaround
and ensure that all empty cells will be included in the CSV.
Select a cell in the header row.
Press Ctrl+A to select the current region.
Choose Edit > Replace. The Find And
Replace dialog box displays, with the Replace
Make sure the Find What box is completely empty.
In the Replace With box, enter a single space.
Click Replace All.
A message box displays showing how many replacements were made. Click
Click Close to close the Find And
Replace dialog box.
Delete the row of column headings—you do not want to load the headings into the
Save the spreadsheet as a CSV file:
Choose File > Save As. The Save
As dialog box displays.
In the Save As Type drop-down list, select
CSV (Comma delimited).
In the File Name box, type the filename.