Simple checklist
- Keep one row per sale, order or order line.
- Make sure an amount or quantity/price pair exists.
- Add a date if you want a trend.
- Add customer, product, area or salesperson if you want a richer view.
Prepare a file
How to prepare a sales file before analysis?
You do not need a perfect file, but a few clean columns make the report much more useful: date, amount, customer, product, quantity, area and order number when available.
In short
This page helps avoid blockers and get a more reliable report from the first upload.
Simple method
What to check
Avoid this
- Merged cells in headers.
- Several tables in the same sheet.
- Comments inserted inside data rows.
- Using a customer ID as an order number.
RGAnalyzer
What RGAnalyzer accepts
RGAnalyzer shows what the file can support and flags limits that may change the conclusion.
1
CSV or Excel files.
2
Varied column names, with review when needed.
3
Optional columns used only when reliable.
4
Re-importable cleaned CSV export to start from a clean base.
FAQ
Frequently asked questions
Should the file be anonymized?
For testing, fictional or anonymized data is safer if the data is sensitive.
What if the format is very specific?
Use the specific request page to describe the need.
Can I test without a file?
Yes, the live demo shows a full report on fictional data.