Made for UK offices · 123 tools

Every office tool you need,
in one place.

PDFs, spreadsheets, HR, tax and accounting. Nothing to install, and your files never leave your browser. Use every tool online; download your files with Pro.

🔒 Files stay on your device⚡ Instant, no waiting👤 No sign-up to use📲 Works on phone

All tools

Spreadsheet tools, business calculators, UK HR & payroll, tax & accounting, ACCA/CA student tools, plus PDF, document and everyday office tools.

📊

Data analysis & spreadsheet tools

36 tools
📊
Excel Data AnalyserInstant KPI dashboard, insights, report & slides
📈
Instant DashboardPower BI style dashboard from any Excel file
🔁
CSV ↔ Excel ConverterConvert CSV, XLSX, XLS, ODS and JSON
🧩
Excel File MergerCombine many spreadsheets into one
🧹
Duplicate RemoverFind and delete duplicate rows
📈
Chart MakerPaste data, get a chart, download PNG or PowerPoint
🗄️
Excel to SQLCREATE TABLE & INSERT statements from any spreadsheet
🧮
SQL Query BuilderBuild SQL with clicks, explained in English, run on your data
✨
SQL FormatterMake messy SQL clean and readable
🧽
Data CleanerFix spaces, capitals, text numbers, dates, blanks and duplicates
🔗
VLOOKUP / Merge Two SheetsMatch two files on a shared column, no formulas
🆚
Compare Two Excel FilesSee added, removed and changed rows and cells
🧊
Pivot Table BuilderGroup, total and chart your data with clicks
🌐
Web Table to ExcelCopy tables from websites into clean Excel
🔣
JSON ↔ Excel ConverterFlatten JSON into a spreadsheet, or Excel into JSON
📍
UK Postcode Lookup (Bulk)Add council, region and lat/long to postcodes
🔄
Unpivot / Reshape DataColumns to rows and back, ready for Power BI
🎯
Outlier FinderSpot unusual values, typos and errors
📐
Statistics CalculatorMean, SD, correlation, t-test, chi-square explained
🎲
Random Sample PickerRandom rows for audits, surveys and prize draws
🧠
DAX Measure GeneratorYTD, YoY %, rank and % of total for Power BI
📅
Date Table GeneratorPower BI / Excel calendar with UK bank holidays
🧩
Excel Formula BuilderXLOOKUP, SUMIFS, IF and more in plain English
⚙️
Power Query SnippetsCopy-paste M code to clean and reshape data
🗄️
SQL PlaygroundRun SQL queries and JOINs on Excel & CSV files
🐘
Large CSV ViewerOpen & filter CSVs with millions of rows
✂️
Split Excel by ColumnOne sheet or file per region, rep or month
🔗
Fuzzy Match (Fuzzy VLOOKUP)Match similar names between two lists
🛡️
Data AnonymiserMask, hash or code personal data for GDPR
📇
Extract Emails, Phones & PostcodesPull contact details out of any text or file
🔮
Forecast & RegressionSales forecast and what drives your numbers
👑
RFM Customer SegmentsFind champions, loyal and at-risk customers
📊
Cohort RetentionHow many customers come back month by month
🅰️
ABC / Pareto AnalysisThe 20% of products that make 80% of sales
⚖️
A/B Test CalculatorIs version B really better? p-value and sample size
🧪
Test Data GeneratorRealistic fake UK data for testing and demos
🏪

Business manager (stock, orders, money)

6 tools
💷

Money & business calculators

4 tools
👥

HR & payroll tools

19 tools
🧾

Tax & accounting tools

10 tools
📈

Finance & analysis tools

8 tools
🎓

ACCA & CA student tools

4 tools
📄

PDF tools

10 tools
🗂️

Invoices & business documents

5 tools
🗓️

Time & planning

6 tools
✍️

Text & writing

6 tools
🧰

Converters, images & utilities

9 tools

Why people use AllOfficeTools

🔒Private by designTools run inside your browser. Your PDFs, payslips and spreadsheets are not uploaded to us.
Built for UK rulesTax, NI, VAT, SSP, holiday and wage tools use 2026/27 UK rates and plain-English explanations.
⚡Fast and simpleNo accounts, no installs and no waiting in a queue. Open a tool and get the answer straight away.
⭐Pro when you need itDownload Excel, PDF, Word and PowerPoint files and remove ads for £4.99 a month. Cancel any time.
📊 Try it now

Excel data analyser

Drop any Excel or CSV file and get instant charts, a data-quality check and plain-English insights, then download a PDF report or a PowerPoint deck.

Dashboard on screenPDF & PowerPoint with Pro · £4.99/mo .xlsx · .xls · .csv Your data never leaves your browser

Dataset overview

KPI dashboard

ON SCREENUse the filters and every number and chart updates instantly.

Key insights

    Insights are generated automatically and may misread some data. Please check important figures. Disclaimer

    Charts

    Column profile & data quality

    Data preview (first 20 rows)

    How the analyser works

    1UploadDrop in an Excel (.xlsx, .xls) or CSV file. Multi-sheet workbooks are supported.
    2Automatic profilingEach column is detected as numbers, categories, dates or text, then checked for missing values, duplicates and outliers.
    3Insights and chartsTrends over time, top performers, distributions and correlations, explained in plain English.
    4ExportDownload a polished PDF report or an editable PowerPoint deck with Pro.

    Frequently asked questions

    Are the tools free to use?

    Yes. You can use every tool on the site and see your results on screen without paying or signing up. Downloading files (Excel, PDF, Word, PowerPoint and images) needs Pro at £4.99 a month, which also removes ads.

    Is my data uploaded to a server?

    No. The tools run inside your web browser. Your files are never sent to or stored on our servers.

    Can I use it on my phone?

    Yes. Every tool works on phones and tablets, and you can install AllOfficeTools as an app from your browser menu or the Install app link.

    What kind of files work best in the Excel analyser?

    Tables with one header row and one record per row, such as sales, orders, survey responses, stock lists or finance exports. Files up to roughly 100,000 rows work well on most computers.

    Can I cancel Pro?

    Yes, any time from your account. Pro stays active until the end of the period you paid for. Payments are not refundable; see the Terms.

    Privacy

    Files you analyse are processed locally in your browser and are not uploaded or stored by AllOfficeTools. This site may use cookies from advertising partners such as Google AdSense to show and measure ads. Google's use of advertising cookies lets it and its partners serve ads based on your visits to this and other websites. You can opt out of personalised advertising in Google's Ad Settings. For questions, contact info@allofficetools.com.

    Working…