Export to CSV

Export your data out of Lexer to use in other tools, cut it up your own way, and find new insights

The CSV export feature allows you to get your hands on the data behind your charts, streams of content, tables, and forms. Using export will prepare a file specific to your search, and return it to you as a CSV file, which is a common format for importing into other programs such as Microsoft Excel, or Google Sheets.

Exporting your charts, streams of content, and tables

2984
  1. To export your charts, streams of content, and tables first navigate to Measure > Listen.
  2. Then create a new search using your Deep Dive and click Search at the bottom of the Deep Dive to generate your results.
Date range
If you are looking to download messages from a period of time that exceeds 90 days, you will have to download these records in 90 day increments. Set the date range on the dive for the first 90 days of the period you need, export the CSV as shown and repeat the process until you have all required records.

        3. In the top, right corner of each of your results, click on the dropdown arrow and select Export to CSV.

The option to export will appear on most charts, providing different data for each. Charts will generate an export for the data they represent.

Some examples of different exports are:

Data to export Location to export
Social media content Export from the "Mentions" table in Listen.
Influencer lists Export from the "Top Authors" chart in Listen.
Geolocation of customers Export from the heat map in the "Location" page in Listen.
Every interaction your team have had Export from the "SLA" report in Activity.
Every start to finish conversation your agents have had Export from the "Cases" report in Activity.

Exporting your forms

You can also export your Lexer form submissions in Listen.

2984
  1. Navigate to Measure > Listen > Live Stream.
  2. Then create a new search using your Deep Dive and click Search at the bottom of the Deep Dive to generate your results.
  3. In the Matches section, select the dropdown arrow in the top, right corner and click Export Forms to CSV.

And your CSV should be ready to go!

The CSV file will contain the following data:

  • Date of submission
  • Form name
  • Form title
  • Author
  • A column for each question in the form

And it also supports exporting multiple answers to a single question!

Why are the dates wrong on my export?

Lexer’s native timezone is UTC. UTC is generally in sync with GMT, so it’s good to use this as a guide.

Any exported data is automatically converted to UTC. So if you’re based in Melbourne, for example, the time will appear to be out by +10 hours.

Simply adjust the time accordingly with a formula, and you’ll have the time and dates converted to your local time.

To apply this, create a new column in your spreadsheet alongside that which contains the current timestamps. Then apply the below formula (assuming cell A2 on your spreadsheet is the date/time) to the first cell, and drag down to apply to the whole column:

=A2+TIME(10,0,0)

This formula doesn’t account for Daylight Savings Time, so it’s best to look up the current difference between UTC/GMT and your local time.

Export complete

And that's all your need to know about exporting your charts, streams of content, tables, and forms from Listen! If you run into any difficulties, reach out to our Support team (support@lexer.io).

That's a wrap

That's it for SCV exports! If you get stuck, try following the steps above and please don't hesitate to reach out to Lexer Support using the chatbot in the bottom right of the page.

Updated:
September 23, 2022
Did this page help you?
Thank you! Your feedback has been received!
Oops! Something went wrong while submitting the form, for assistance please contact support@lexer.io