What you can do
Use Langdock for data analysis when you want to:- Read tabular data from CSV, Excel, and Google Sheets files
- Calculate metrics, correlations, distributions, and deviations
- Compare segments, columns, regions, time periods, or categories
- Create charts and visualizations from data
- Generate files such as Excel, CSV, Word, PDF, JSON, and text files
Analyze a spreadsheet
Add your data
Upload a CSV or Excel file, connect a Google Sheet, or select a spreadsheet from your integrations.
Ask a specific question
Describe the metric, grouping, time period, and output format you need. For example, ask Langdock to summarize trends, calculate totals, compare columns, or create a chart.
Review the result
Check whether the answer uses the right columns, filters, and assumptions. If anything is missing, ask a follow up question with the exact correction.
Example prompts
Use specific prompts that name the data, calculation, and expected output:- “Analyze monthly sales trends over the last 12 months and identify seasonal patterns”
- “Calculate the average deal size by region and return the result as a table”
- “Find the top 5 products by revenue and create a bar chart”
- “Compare churn rate by customer segment and explain the largest differences”
- “Create an Excel file with one sheet per region”
Statistical analysis examples
Langdock can help with common statistical tasks on tabular data:| Task | Example request |
|---|---|
| Correlation | ”Calculate the correlation between ad spend and revenue” |
| Distribution | ”Show the distribution of order values and identify outliers” |
| Deviation | ”Find rows where actual spend differs from budget by more than 10 percent” |
| Segment comparison | ”Compare average revenue by customer segment” |
| Trend analysis | ”Show month over month growth for the last year” |
| Histogram | ”Create a histogram of customer ages with 20 bins” |
| Scatter plot | ”Create a scatter plot of discount percentage and order value” |
| Heatmap | ”Show a heatmap of the correlation matrix” |
Output formats
Langdock can return analysis results in several formats:| Output | Use when |
|---|---|
| Text | You need a summary, explanation, or recommendation |
| Table | You need structured results in the chat |
| Chart | You need a visual comparison, trend, or distribution |
| Generated file | You need a downloadable spreadsheet, report, JSON file, or image |
Data analysis vs document search
Use data analysis for structured rows and columns. It works best for calculations, comparisons, transformations, charts, and generated spreadsheet files. Use document search for prose documents, contracts, reports, and files where you need text extraction or source based answers.In Agents, add Create & work with files under Actions > Capabilities when this capability is available in your workspace.
Best practices
- Use descriptive column names. Refer to the full column title instead of labels like “Column K”.
- Keep column titles in the first row whenever possible.
- Avoid empty cells when you can.
- Include the metric, grouping, time period, and preferred output format in your prompt.
- Break complex analysis into multiple prompts when the first result is incomplete or incorrect.