How to scan using an iPhone - .CSV file export

There are many apps on the market for scanning bar and QR codes. Scan to SS is the only one we have found that exports a properly formatted .CSV file.

If you're scanning attendees as they arrive for your event, then you will only need to make one spreadsheet (this scan app creates spreadsheets) which will contain scanned data. If you're scanning attendees as they arrive for a session, then you will need a new spreadsheet for each session. This app allows you to create and save many spreadsheets (ultimately, a .CSV file).

CAVEAT: Scanning with a phone app will not be able to verify that the attendee has actually registered for the event/session.  However, the scan gun, connected to a computer with wi-fi access, will be able to verify whether or not the attendee actually registered.

Where do I obtain this scan app?

Go to this link on your iPhone: http://berrywing.com/

Click the Scan to Spreadsheet  icon and make the purchase.

Where do I obtain this scan app?

Open the Scan to SS app on your iPhone

Always make sure your iPhone has a large charge; turn off other apps to conserve battery juice.

Open the Scan to SS app on your iPhone

Opening screen ...

Create a spreadsheet to start.

Opening screen ...

Name the new spreadsheet ...

When choosing a name for the spreadsheet, make it meaningful.  For example,

  • If you're scanning event attendees, include the name of the event (or a portion of it so that you don't get mixed up when uploading the .CSV file)
  • If you're scanning session attendees, include the name of the session (or a portion of it so that you don't get mixed up when uploading the .CSV file)
Name the new spreadsheet ...

Not ready to scan yet ...

Nothing to do on this screen, yet.  Just tap the < Back button.

Not ready to scan yet ...

Set the .CSV file delimiter ...

Now we need to set the delimiter for the .CSV file.  What is a delimiter?  A delimiter is a character that is used by a .CSV file to separate the data so that each datum goes into it's own column when imported into a spreadsheet program.

rsvpBOOK uses the pipe character to separate cells of data: | <-- (this key is just above the Enter key - its the character above the backslash)

Set the .CSV file delimiter ...

Set the delimiter character: the pipe - |

  1. Enter the pipe character: |
  2. Tap Done
Set the delimiter character: the pipe - |

Almost ready to begin scanning ...

Tap the spreadsheet name.

Almost ready to begin scanning ...

Launch the scanner screen ...

Tap the barcode icon to begin scanning.

Launch the scanner screen ...

The scan screen opens

Point the iPhone to the bar or QR code. It will autofocus and then automatically scan the code and save it to a new row in the spreadsheet. It will beep, indicating a successful scan.

After a scan, it will be ready to scan the next code. Continue scanning attendees as they come through the door. When finished scanning, tap the X in the upper left corner.

The scan screen opens

When finished scanning and you tapped the X in the previous step, you will land on this screen ...

Now its time to export your .CSV file containing the scans.  The easiest way to export is to email the file to yourself.

When finished scanning and you tapped the X in the previous step, you will land on this screen ...

It's time to export the spreadsheet

The easiest way to export the .CSV file is to email it to yourself.

It's time to export the spreadsheet

Send it to yourself ...

  1. Enter your email address in the To: field
  2. Enter a From: address - will be remembered until you change it
  3. Tap the Send button
Send it to yourself ...

Open the email message with the .CSV file as an attachment

You will want to pick up this email mssg on your computer or tablet so that you can upload it from your event's Admin Dashboard.

Save the .CSV file to your computer and upload it into rsvpBOOK - attendees will be marked Attended after the upload process completes.

Open the email message with the .CSV file as an attachment

What does the .CSV file look like?

A .CSV file is a plain text file and therefore can be opened in any text editor, including Word. It's not a good idea to open it in case you accidentally change something and save it.  You really don't need to open this file.  

What does the .CSV file look like?

What does the .CSV file look like when imported into Excel (or any spreadsheet program)?

This is the first screen seen when importing.  Have a look at the preview and set the Other delimiter to the pipe character. Then click OK.

What does the .CSV file look like when imported into Excel (or any spreadsheet program)?

This is the .CSV file, viewed from within a spreadsheet program.

Four rows of data plus a header row. There is no reason to import the file into a spreadsheet program.

We do it here so that you can see what it looks like.

This is the .CSV file, viewed from within a spreadsheet program.

Deleting spreadsheets

  1. Tap Edit to expose a Delete button
  2. Tap the plus sign (+) to create a new spreadsheet
  3. As you create spreadsheets, they will add to this list until you delete them - once you've exported the .CSV file to your computer, you can safely delete them here
Deleting spreadsheets

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.