CSV Export: Convert text to columns and filter data

Many exports at Jeike, for example, the attendees export are CSV files, making it easy for you to import a CSV file into your email platform or your CRM system.

You can open the CSV in programs such as Excel and convert the data to columns. You can then filter per column to find the information you want without being bothered by information that is not relevant.

How you do this looks slightly different for each program. That's why we've explained Excel and Google Spreadsheet separately.

Excel - Text to column

Open your CSV in excel, select column A. In the menu at the top, go to Data. Click on the icon with Text to columns to open the wizard:

In step 1 of the wizard, you check the box 'Delimited'. Then click on Next at the bottom.

In Step 2 of the wizard, Tab is checked by default under Delimiters. Also, check Comma. If the view in the preview screen at the bottom looks good, choose Finish to complete.

Excel - Filter

Use filters to temporarily hide some data in a table so you can focus on the data you want to see.

Select all your information in your excel tab, go to Data and choose Filter.

All columns have a filter option. Choose the column where you want to filter, click on the arrow of this column header. You now get the choice to filter things out.

Google spreadsheet - Text to columns + filter data

When you upload a CSV in Google Drive and then open it with Google Spreadsheet, all data will automatically be in columns:

Select the first row, and go to 'Data' and then ‘Create a filter’:

All columns have a filter option. Choose the column you want to filter, click on the pyramid of this column header, and click on what you want to see. For example, all your 'guest tickets'.