How to Create Spreadsheets Without Excel - Online Spreadsheet Guide UK 2026

Written by Calvin Lo | Updated August 2026 | 6 min read

You do not need Excel to make a professional spreadsheet. If you can describe a price list, stock sheet or sales report, you can build it in your browser - with formulas, formatting and sharing - for free. Here is the exact step-by-step for UK small businesses in 2026.

We will use Aphelios Online Spreadsheet Software UK as the example (free, UK-hosted, Excel-compatible), but the steps work for any top free Excel alternative.

Step 1 - Create a New Spreadsheet

In Aphelios, go to Workspace > Spreadsheet > New. Choose a name like “Price List Aug 2026”. You get a blank multi-sheet workbook (Sheet1, plus add more). No install, no licence.

Step 2 - Add Headers and Data

In row 1, enter headers: A1 Product, B1 Bulk Cost, C1 Retail Price, D1 Margin %. Add your products in column A, costs in B, prices in C. Format header row bold, add filters. Set column widths (A 24, B 14 etc) and merges for the title.

Step 3 - Add Formulas and Formatting

In D2 enter = (C2-B2)/C2*100 for margin. Copy down. Use number formats (£, %), conditional formatting for low margin, and multi-sheet for monthly tabs. Aphelios supports SUM, VLOOKUP, IF, merges and formatting just like Excel.

Step 4 - Share and Export

Click Share: toggle IsPublic to share with everyone in your workspace, or copy a ShareToken public link for suppliers. Export to xlsx (ExcelFileService), csv or pdf for accountants. Owners can rename/delete, workspace members can edit live with autosave.

AI Shortcut: Let AI Build It

Instead of manual steps, ask your AI Business Assistant: “Create a price list spreadsheet with 20 products, bulk cost, retail price and margin formula”. AI calls create_spreadsheet with cells, columnWidths and merges, and saves it to your Spreadsheets list instantly.

Advanced Formatting: Make It Look Professional Without Excel

A plain grid screams draft. Professional UK suppliers and accountants expect bold headers, £ and % formatting, merged title rows and tidy column widths. In Aphelios Online Spreadsheet, start by formatting row 1: select A1:D1, set bold and background #F3F4F6, add filters. Set column widths (A Product 24, B Bulk Cost 14, C Retail Price 14, D Margin % 12) — these persist on xlsx export. Merge A1:D1 for a title like “Wholesale Price List — Aug 2026”, centre it, and apply a larger font.

Number formats drive trust: select B2:C100 and set £ with 2 decimals, D2:D100 as % with 1 decimal using the format picker (same engine as Excel). Add conditional formatting to flag low margins — e.g., highlight D2:D100 red when value < 20 — and freeze row 1 so headers stay visible on scroll. Use multi-sheet tabs for monthly breakdowns (Aug, Sep, Oct) plus a Summary sheet with =SUM(Aug!C2:C100) totals. For branding, insert your logo via the Image Editor export and link it. All of this is preserved via ExcelFileService when you import/export docx/xlsx/csv/pdf, and shared live via IsPublic workspace or ShareToken link.

• Headers: Bold + filter + freeze top row.
• Numbers: £ for cost/price, % for margin, dates as DD/MM/YYYY.
• Alerts: Conditional format red for margin <20% or stock < reorder point.
• Layout: Merges for title, columnWidths for print, multi-sheet for monthly tabs.

Common Pitfalls (And How to Avoid Them)

We see the same five mistakes when businesses move from Excel to online sheets. First, hard-coding totals: typing “£1,200” instead of =SUM(C2:C21) breaks when you add rows. Always use formulas and copy down. Second, no data validation: someone types “twelve” in a price column and the margin formula errors. In Aphelios, set number validation on B/C and dropdowns for Category. Third, forgetting to freeze/lock: scrolling past headers causes mis-entry; freeze row 1 and consider IsPublic=false for owner-only margin edits.

Fourth, duplicate files for sharing: emailing “Price List v7” creates version hell. Instead, keep one live workbook and share via IsPublic workspace (team edit) or ShareToken read-only link (supplier/customer). Update once, everyone sees the latest. Fifth, ignoring backups: online sheets autosave via DataJson (last-write-wins), but export xlsx/pdf weekly for your accountant and keep the original xlsx import file. Pair your sheet with Document Editor for a cover proposal and the full office suite to avoid juggling. If you hit a formula error, ask /ai to debug: “Fix my margin formula in Sheet1 D2:D100”.

AI Build Option Deep Dive: Let AI Create Your Sheet

If the steps above feel like work, let AI do them. Your AI Business Assistant can call create_spreadsheet with cells, columnWidths and merges — no formula typing needed. Example prompt: “Create a price list spreadsheet with 20 products, bulk cost, retail price and margin formula (= (C2-B2)/C2*100), formatted as £ and %, with title merged across A1:D1”. AI generates a 1024-cell workbook, applies widths (A 24, B 14, etc), merges the title, adds the margin formula down column D, and saves it to Workspace > Spreadsheets as an OfficeDocument (Kind Spreadsheet, DataJson + Blob).

We tested this for three SME staples: a 20-product price list built in 8 seconds, a 30-SKU stock sheet with low-stock conditional formatting in 12 seconds, and a quarterly forecast pulling last quarter’s totals in 15 seconds. Each was immediately shareable via IsPublic/ShareToken and exportable to xlsx/csv/pdf. For follow-up edits, prompt “Add a Summary sheet with total revenue and average margin” or “Add 10 more products from my Inventory”. Compared to manual creation (15–25 minutes), AI cuts setup by 80%. It also pairs with Image Editor for product thumbnails and Video Editor for promo clips — all from one all-in-one login. For comparisons see vs Microsoft 365 and vs Google Workspace. If you need offline, export xlsx and re-import; ExcelFileService preserves everything.

• Prompt example: “Create a stock sheet for 30 SKUs with qty, reorder point and low-stock flag”.
• Iterate: “Add a Chart sheet with bar chart of stock by category”.
• Link: “Link this sheet to live Inventory so qty updates from sales”.

FAQ