Most people who search "how to scrape a website to Excel" do not want a programming lesson. They want a table from a web page in a spreadsheet, or a set of articles in a Word file they can edit. This guide walks through each export format, when to use it, and the cleanup steps that turn raw scraped content into something you can hand to a client or a team.
Pick the right format first
| Format | Best for | Keeps | Watch out for |
|---|---|---|---|
| Excel (.xls) | Tables, price lists, specifications, schedules | Rows and columns | Long paragraphs land in a single cell |
| Word (.doc) | Articles, service pages, policies, content audits | Headings, paragraphs, lists, tables | Very long pages make big files |
| Sharing a fixed snapshot, printing, records | Exactly what you see in the preview | Not editable without a PDF editor |
Website to Excel: extracting tables
- Open the free web scraper and paste the URL of the page that contains the table.
- Click Extract data and confirm the table appears in the preview.
- Click Download Excel.
- Open the file. Excel may warn that "the file format and extension don't match" — this is normal for HTML-based spreadsheets. Click Yes.
- Use File → Save As → Excel Workbook (.xlsx) so the file behaves like a normal spreadsheet from now on.
If numbers come through as text (left-aligned, green triangles), select the column and use Data → Text to Columns → Finish. Excel will convert them into real numbers you can sum and sort.
Website to Word: content you can edit
Word export is the most useful format for content work. Every page is separated by a page break and starts with a dark "Source:" label, so a 10-URL run becomes a neat 10-section document — and there is no limit on the number of URLs.
- Content audit: scrape every page of your current site before a redesign, then mark what to keep, rewrite or delete.
- Competitor outline: scrape the top results for a keyword and turn on the Navigation Pane to compare their H2 structure.
- Client approvals: share the Word file so the client can comment with Track Changes.
Website to PDF: a clean snapshot
The PDF download is created in your browser from the preview, so what you see is what you get. It is ideal when you need a record of what a page said on a specific date — for example, a supplier's published terms or a rate table — or when you want to print content without ads and menus.
Cleanup checklist
- Remove cookie banners, "subscribe" boxes and repeated footer text.
- Check that tables kept their header row; add one if not.
- Keep the source URL next to every section.
- For research, add a date — web pages change.
- Never republish scraped text as your own; rewrite it in your own words.
Common mistakes
- Pasting URLs without https:// — the tool needs full, valid addresses.
- Scraping a page that loads with JavaScript — check the page source first; see our no-code scraping guide.
- Expecting images — the export keeps text structure, not image files.
- Scraping hundreds of pages by hand — at that scale, a custom scraper with a database is cheaper than your time.
Quick answers
Which format keeps tables best?
Excel keeps rows and columns, so it is best for tables. Word keeps headings and paragraphs for reading and editing. PDF is best for sharing a fixed copy.
Why does Excel show a warning when I open the file?
The download is an HTML-based .xls file. Excel shows a format warning; click Yes to open it, then use File → Save As → .xlsx to convert it permanently.