• Home
  • About
  • Value 
    • For Events
    • For Teams
    • For COVID-19
  • NFT Tickets
  • Smart Tickets
  • …  
    • Home
    • About
    • Value 
      • For Events
      • For Teams
      • For COVID-19
    • NFT Tickets
    • Smart Tickets
    BOOK YOUR DEMO
    • Home
    • About
    • Value 
      • For Events
      • For Teams
      • For COVID-19
    • NFT Tickets
    • Smart Tickets
    • …  
      • Home
      • About
      • Value 
        • For Events
        • For Teams
        • For COVID-19
      • NFT Tickets
      • Smart Tickets
      BOOK YOUR DEMO

      Exports

      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:

      Graphical user interface, application

Description automatically generated

      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.

      Text to Columns in Excel - Easy Excel Tutorial

      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:

      Graphical user interface, text, application, email

Description automatically generated

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

      Table

Description automatically generated

      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'.

      Previous
      Organisation Sales
      Next
      Reports (Exports)
       Return to site
      All Posts
      ×

      Almost done…

      We just sent you an email. Please click the link in the email to confirm your subscription!

      OK