Excel-Upload-Function: Prompt-Examples
The Excel upload feature in amber lets you upload Excel files and interact directly with the data inside them. Whether you want to analyze trends, extract specific information, or summarize data, this feature makes your workday much easier. Below, you’ll find practical examples of how you can use this feature effectively in the office.
How the Excel upload feature works
Upload your Excel file:
Drag and drop the file into the drop area or use the upload button.
Supported formats:.xlsx, .xls, .csv.
Make sure your Excel file has clear headers and consistent formatting; this increases the readability of your data.
Ask questions about your data:
After uploading, you can interact with your data in natural language.
Refine your prompt:
Be as specific as possible to achieve the best results.
Use the sample prompts below for guidance.
Examples of input prompts
1. Data analysis
“How high is the churn rate for Project X’s customer base?”
“Show me the outliers by monthly revenue.”
“What is the average revenue in the ‘Budget_T3’ column?”
2. Summaries
“Summarize the key insights from this table.”
“Create an overview of the monthly expenses.”
“Which trends can be identified in the sales figures for the last 12 months?”
3. Filtering and sorting
“Show all rows where the status is ‘Open’, please.”
“Sort the data by ‘Department’ in ascending alphabetical order.”
“Filter the table to display entries with a budget above $10,000.”
4. Calculations
“Calculate the total revenue for the year 2025.”
“How high is the percentage growth in sales compared to last quarter?”
“Find the sum of the ‘Budget’ column.”
5. Advanced analyses
“Create correlations between marketing spend and sales.”
“Break down revenue by region and product.”
“Which outliers are present in the data?”
Tips for optimal results
Check your file structure: Make sure your Excel file has clear headers and consistent formatting. This makes it easier to understand the content of your data.
Be specific: Use precise language in your prompts to get faster and more accurate answers.
Ask follow-up questions: If the first answer isn’t sufficient, ask follow-ups like:“Can you explain how this was calculated?” or “Show me the data used for this result.”
Frequently Asked Questions (FAQs)
Which file formats are supported?
Supported formats:
.xlsx,.xls,.csv.
Are my data safe?
Yes, all files are processed securely and comply with GDPR data protection standards as well as ISO 27001 certification.
With these prompt examples and tips, you can make full use of amber’s Excel upload feature. This will make working with your data more efficient and productive!