Overview
The Broadstripes Reports function allows you to download a list to your local machine as a spreadsheet (.xls or .csv) where it will be accessible to you even if you are offline.
Once the information is in a spreadsheet format, you can manipulate and edit it as you see fit. Changes made to the downloaded spreadsheet will have no effect on the data in your Broadstripes project.
Your Broadstripes admin must grant you the proper permission to be able to download report files. See your admin if you need your project member permission settings edited to allow downloading CSV / Excel files.
Download a spreadsheet list
- To download a list in spreadsheet format, start by running a search for the workers on your list. (Learn about running a search in the Search by workplace or Create and save a search articles.)
- When your search results appear, click all to select all the results in the list below.
-
- All contacts will be selected (indicated by a check next to their name). Uncheck any person you want to exclude from your list.
- Once your contacts are selected, click the Reports menu and choose the spreadsheet format you want: either Spreadsheet (XLS) or Spreadsheet (CSV).
- A Spreadsheet options window will open.
- Give the file a Title and choose a Column Layout to determine which columns of data (fields) will be included in your printed list. (For more information about using layouts, see the Choose a layout or Create and save a layout articles.)
- Choose additional options as needed:
- Checking One row per contact will create one spreadsheet row for each contact; if a contact has multiple addresses they will each be listed together in the address column, separated by dashes (the same will happen for multiple employments or any other field that allows multiple values).
- Leaving this unchecked will create a spreadsheet where multiple addresses are each on a separate row.
- Checking Show Followers or Employees will create a spreadsheet row for each person (or organization), and additional rows for each of their followers (or employees).
- Checking One row per contact will create one spreadsheet row for each contact; if a contact has multiple addresses they will each be listed together in the address column, separated by dashes (the same will happen for multiple employments or any other field that allows multiple values).
- Click Generate. This will create the spreadsheet “report” you can download.
- You’ll see a message explaining that your spreadsheet report is being created and will download automatically.
- To download your speadsheet, you have two choices:
1. You can stay on the current page and wait for the report’s download dialog to appear.
When the report is ready, this dialog box will appear.
2. You can leave the current page and check in later to see if the report is ready. To check for the report later, click the Reports link in the navigation panel. That link brings you to the Requested Reports page where you can select and download the report.
Click the Reports link to view a list of reports.
Click the file’s name to download it from the Requested Reports page.
- Once you’ve downloaded your spreadsheet list, you can open and edit it just as you would any other .XLS or .CSV document.