Table of Contents

How to export the data from your bots

DesirΓ©e M Updated by DesirΓ©e M

One of the biggest values of chatbots is the data they collect. Landbot saves user input in Fields (e.g., @name, @email), which you can export or connect to your database.

This guide covers all the ways you can export data from your bots. All CSV files are sent to the email address you use to log in to Landbot.

πŸ“Š From the Metrics Section

Go to Metrics > Conversations Data to access account-level exports, divided into three subsections:

Overview lets you export raw data from all your bots in a single CSV file by clicking Raw Data Export.

Channels lets you filter by bot and export its data as a CSV via Raw Data Export.

Team Reports lets you export agent chat management data as a CSV via Raw Data Export.

For more details, check the Metrics section article.

πŸ€– From a Specific Bot (Analyze Section)

Open the bot, go to Analyze in the top menu, and click Conversations Data. From there, click Raw Data Export to receive a CSV with all user interactions and saved fields for that bot.

You can also export all chat transcriptions in bulk by clicking "Chat Transcript Export". We recommend choosing periods of no more than 30 days at a time. The file will be sent to your email once it's ready.

πŸ’‘ Depending on how large the list is, it may take a few minutes to arrive.

You can also access Flow Analytics to see block-by-block conversion and drop-off data. If needed, export the entire flow as a PNG using the Export Flow button at the bottom of the screen.

Learn more in the Analyze section article.

πŸ’¬ From the Inbox (Transcripts)

To export a single full conversation transcript, go to Inbox, open the conversation, click the three dots on the right, and select Send transcription. The transcript will be sent as a TXT file to the agent assigned to that conversation.

Check the Inbox section guide for more details.

βš™οΈ Advanced: Real-Time Export via Integrations

If you want data to sync automatically instead of exporting manually, Landbot offers a few options. These are available on Professional and Business plans.

Google Sheets

Using the native Google Sheets integration, you can send data collected by your bot directly to a spreadsheet in real time. Note that Google Sheets has a limit of 200 sheets per workbook, so if you need a more advanced database setup, Airtable might be a better fit.

Airtable

The native Airtable integration lets you connect your account and update your database in real time. It's a great option if you need more structure and flexibility than Google Sheets offers.

Webhooks

If you need a fully custom setup, you can use the Webhook block to send data to any external system or trigger advanced automations.

πŸ“‚ How to Open Your CSV File

A CSV (Comma-Separated Values) file stores plain data with each value separated by commas. You can open it in Google Sheets or Excel.

Google Sheets automatically detects the CSV format, so no manual setup is needed.

1️⃣ Once you receive the email, download the CSV file to your computer.

2️⃣ Open Google Sheets and go to File > Import.

3️⃣ Select the CSV file and click Import data when the prompt appears.

πŸ’‘ If you're using Gmail in Chrome, you'll see a direct option to open the attachment with Google Sheets β€” this skips the download step entirely.
Open in Excel

1️⃣ Open a new Excel sheet and go to Data > From Text.

2️⃣ Select your CSV file. The Import Wizard will open.

3️⃣ Select Delimited, then Comma as the delimiter. Click Next.

4️⃣ Select General data format and click Finish.

5️⃣ Choose where to place the table (A1 is recommended) and click OK.

⚠️ If your data has fields with leading zeros, double-check they came through correctly after the import.

πŸ’‘ Tips

If the file has over 100 columns, try filtering by specific fields or selecting a smaller date range to reduce the number of rows.

If data looks broken, semicolons (;) in your data may be the cause. Open the CSV in Notepad or TextEdit, use Find and Replace (Ctrl+H on Windows, Cmd+H on Mac) to replace all semicolons with commas, save the file, and re-import.

If you want to get more information about how Landbot processes the data, please check our Trust Center.

Was this article helpful?

Metrics Section

Bot's Analyze Section

Contact