Download Phone Numbers to CSV

Excel and other spreadsheets have a habit of removing leading zeros from numbers. That can be annoying when you want to view a downloaded report that contains phone numbers or bank details. Here’s a tip to get round it:

Run your report in Eventotron and export to csv

Open a blank spreadsheet in excel 

file->import 

Choose the file you’ve downloaded from Eventotron 

Choose ‘delimited’ 

then ‘comma’ 

then choose the column(s) with the numbers and make the data format ‘text’ 

More helpful guides…

×
×





Please Wait
Talking to the Box Office...