How do I convert a Participant List into an Excel spreadsheet?

Permanently deleted user
Permanently deleted user
  • Updated

When you download the participant list, registration list, or chat transcript from the Boostlingo Events portal, we will compile a CSV (Comma Separated Values) file, which you can open with Excel and might appear as in this image:

1.png

To convert the file and have it displayed in a readable way, follow these instructions:

1, On Mac:

  • Select the first column
  • Select Data > Text to columns
  • Select Delimited in the first window and click on Next
  • Select Comma as delimiter and click on Next

2.png

  • Click on Finish in the last window

2. On Windows:

  • Open a blank spreadsheet in Microsoft Excel
  • Go to the "Data" tab
  • Press either "Get Data" or directly "From Text/CSV"
  • Select the participant list file
  • Under "File Origin", choose "65001: Unicode (UTF-8) and "Load"

3.jpeg

Your data will be now displayed correctly ordered in columns. 

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.