The columns must be in this order and contain the first row. Furthermore, the update_token column may be avoided if you are not looking to regenerate any tokens. When a blank value is contained in this column, it will be ignored, otherwise adding a "y" (or "yes") value to this column will regenerate a new token for this user.
In your spreadsheet software (e.g. Excel or Google Sheets), start a new spreadsheet with these columns or download the attached file to get started.
Add the Private Feed listeners row by row as per the following screenshots.
When you have finished your editing, export it as a CSV file:
- In Microsoft Excel, go to File > Save As and in the dialog set the File Format as "CSV UTF-8 (Comma-delimited) (.csv)".
- In Google Sheets, go to File > Download > "Comma-separated values (.csv, current sheet)".
You will use the file in the following section.
Uploading a CSV File
With a completed CSV file, you may bulk update several records at once.
To begin the process, click the "Import Private Feeds" button and observe the popup dialog.
There are two ways to do this. You may either:
- Upload to append new records only; or
- Upload to update all records and append new records.
If you would like the former option above, select "Keep the existing values"; otherwise select "Update with the imported values".
You may also select to send an email to all updated and new users by checking the "Send email invitations to imported users" checkbox.
Select the file from your machine and ensure that it is the intended CSV file in the right format.
When you are ready, click "Import". The upload and processing will begin. Depending on the size of your list, the process should take a few minutes to complete.