Guide 05 of 12

How to Export Scraped Data to Excel

Export scraped website data to a clean Excel (.xlsx) workbook, then clean, convert and analyse it with formulas, filters, Power Query and pivot tables.

10 min read · Updated · By the Instant Data Scraper team

How to Export Scraped Data to Excel

Most scraped data ends up in Excel. It's where you sort, filter, calculate, chart and share. But getting from a web page to an analysis-ready workbook involves more than clicking "download": you need the right columns, correct number formats, no duplicates and a structure that formulas can work with.

This guide covers the full journey — exporting a genuine .xlsx file from the Instant Data Scraper tool, what the file contains, and the cleaning and analysis techniques that turn raw scraped rows into insight.

Why export to .xlsx

Better than copy and paste

  • One value per cell — no merged cells or pasted formatting.
  • Link URLs kept as their own columns instead of disappearing.
  • Special characters and non-English text preserved.
  • Plain numbers stored as numbers, ready for SUM and AVERAGE.

Better than CSV for people

CSV is ideal for software, but Excel workbooks open with the right encoding every time, keep a styled header row and include filters. If the file is going to a colleague, send .xlsx.

What's inside the exported workbook

  • One worksheet named after the dataset you exported.
  • A bold, coloured header row that stays frozen when you scroll.
  • Auto-filter buttons on every column.
  • Column widths sized to the content.
  • Numeric cells for plain numbers; everything else as text exactly as it appeared.
  • Only your selected columns from the selected dataset.

The file name includes the website and date, for example instant-data-scraper_shop.example.com_2026-11-17.xlsx, so exports stay organised.

Prepare the data before exporting

Pick the right dataset

If the page produced several datasets (products, navigation, links), select the correct tab before clicking Excel.

Choose columns

Open the Columns menu and untick anything you don't need — tracking links, icon images, duplicate text columns.

Spot-check rows

Use the search box to find a few items and compare them with the live page.

Cleaning scraped data in Excel

Convert prices and numbers

=VALUE(SUBSTITUTE(SUBSTITUTE(C2,"$",""),",",""))

Copy the formula down, then Paste Special → Values to replace the text with real numbers.

Extract a number from text

For values like 4.5 out of 5: =VALUE(LEFT(D2,FIND(" ",D2)-1)).

Split combined fields

When an element contained several values, they are joined with " | ". Use Data → Text to Columns with | as the delimiter, or TEXTSPLIT in Microsoft 365.

Trim stray spaces

=TRIM(A2) removes extra spaces; =CLEAN(A2) removes non-printing characters.

Remove duplicates

Paginated scraping can repeat featured items. Select the data and use Data → Remove Duplicates, using the URL column as the key.

Analysing the data

Sort and filter

The header filters let you sort by price, filter by category or show only "In stock" items.

Conditional formatting

Highlight the cheapest 10% or ratings below 4 with Home → Conditional Formatting.

Pivot tables

Insert a PivotTable to count products per brand, average price per category or listings per city.

Charts

Create a histogram of prices or a bar chart of listings by category in two clicks.

Repeatable cleaning with Power Query

If you scrape the same site regularly, use Data → Get Data → From File → From Workbook and record your cleaning steps (remove columns, change types, replace values) in Power Query. Next time, drop the new export into the same folder and click Refresh.

Google Sheets, LibreOffice and Numbers

  • Google Sheets: File → Import → Upload the .xlsx.
  • LibreOffice Calc: open the file directly.
  • Apple Numbers: open the file directly; filters may need re-applying.

Useful formulas for scraped data

GoalFormula
Remove currency symbol and commas=VALUE(SUBSTITUTE(SUBSTITUTE(B2,"$",""),",",""))
First number in a text=VALUE(LEFT(B2,FIND(" ",B2)-1))
Domain from a URL=TEXTBEFORE(TEXTAFTER(A2,"//"),"/")
Text after a label=TRIM(TEXTAFTER(B2,":"))
Flag rows containing a word=ISNUMBER(SEARCH("sale",C2))
Price band=IFS(D2<20,"Under 20",D2<50,"20–50",TRUE,"50+")

TEXTBEFORE, TEXTAFTER and TEXTSPLIT are available in Microsoft 365 and Excel for the web. In older versions use MID, FIND and Text to Columns.

Turn the data into an Excel Table

Select any cell and press Ctrl+T. Excel Tables give you:

  • Banded rows and automatic filters.
  • Formulas that fill down automatically.
  • Structured references like =[@Price]*1.2 that are easier to read.
  • Ranges that grow when you paste more scraped rows.

Combining several exports

Copy and paste

For two or three files with identical columns, paste the rows below each other and remove duplicates.

Power Query folder import

Put all exports in one folder, then Data → Get Data → From File → From Folder and choose Combine & Transform. Excel stacks every file into one table — perfect for monthly price snapshots.

Add a source column

When combining, add a column with the file name or extraction date so you know where each row came from.

Sharing your workbook

  • Delete helper columns and keep a clean "Data" sheet plus an "Analysis" sheet.
  • Add a "Source" note with the URL and extraction date.
  • Remove any columns you don't need to share — especially anything that could identify people.
  • Save to OneDrive or Google Drive to share a link instead of emailing attachments.

Common Excel issues and fixes

  • Long numbers turn into scientific notation — format the column as Text or Number with no decimals.
  • Dates in the wrong format — use Text to Columns and choose the correct date order (DMY or MDY).
  • URLs not clickable — use =HYPERLINK(A2) in a helper column.
  • Workbook feels slow — remove unused columns and convert formulas to values when you're done.

Walkthrough: a price-comparison workbook

  1. Extract a public category page with pagination (three pages, 72 products) and export to Excel.
  2. Press Ctrl+T to turn the range into a Table named Products.
  3. Add a column PriceNum with =VALUE(SUBSTITUTE(SUBSTITUTE([@Price],"$",""),",","")).
  4. Add a column RatingNum with =VALUE(LEFT([@Rating],FIND(" ",[@Rating])-1)).
  5. Remove duplicates on the product URL column.
  6. Insert a PivotTable: Brand in Rows, average PriceNum and average RatingNum in Values.
  7. Add a scatter chart of PriceNum against RatingNum to spot good-value products.
  8. Add a "Notes" sheet with the source URL, extraction date and any cleaning steps.

Excel export checklist

  • Correct dataset selected before export.
  • Only needed columns included.
  • Prices and ratings converted to numbers.
  • Duplicates removed using a unique key.
  • Columns renamed to clear, business-friendly names.
  • Source URL and extraction date recorded.
  • No personal data included.
  • Original export kept unchanged as a backup.

.xlsx vs. older .xls files

The modern .xlsx format (used since Excel 2007) supports over one million rows, smaller file sizes and better compatibility with Google Sheets and LibreOffice. The old .xls format is limited to 65,536 rows. All exports from Instant Data Scraper use .xlsx.

Why a clean structure matters for analysis

Excel is extremely powerful, but only when the data follows a few simple rules: one header row, one record per row, one value per cell, and the same type of data in every cell of a column. Scraped data exported from Instant Data Scraper already follows the first three rules. The fourth — consistent data types — is where most of the cleaning effort goes, because websites mix numbers with symbols, units and words.

It is worth getting this right before you start building formulas. A price column stored as text will sort alphabetically ("$100" before "$20"), will be ignored by SUM, and will break charts. Converting it once to a proper number column means every later step — sorting, filtering, pivoting and charting — simply works. The same applies to dates and ratings. A few minutes of cleaning at the start saves a lot of confusion later, especially when you share the workbook with colleagues who did not see the original page.

Finally, remember that scraped data is a snapshot. Prices, stock levels and rankings change constantly. Keeping the extraction date next to your data, and re-extracting rather than editing old values by hand, keeps your analysis honest and easy to update.

Who exports scraped data to Excel, and why

Small-business owners use Excel to compare competitor prices or build lists of public suppliers, because it is the tool they already know. Filters and conditional formatting answer most of their questions without any formulas.

Analysts combine several exports with Power Query, build PivotTables and present charts in reports. The consistent structure of scraped exports makes their monthly refresh a single click.

Students and researchers turn published statistics into charts for assignments and papers, keeping the source URL in the workbook so their figures can be checked.

E-commerce teams track assortment and availability across categories, using Excel Tables and slicers to explore the data interactively during meetings.

Common mistakes when working with scraped data in Excel

  • Editing the only copy — always keep the original download untouched.
  • Typing over formulas — convert helper columns to values once they are final.
  • Mixing snapshots — combining files from different dates without a date column makes trends impossible to read.
  • Sorting part of the table — select the whole table (or use an Excel Table) so rows stay together.
  • Forgetting units — note the currency and whether prices include tax.

Key takeaways

  • Export a real .xlsx file with only the columns you need.
  • Convert text numbers to real numbers before analysing.
  • Use Excel Tables, PivotTables and Power Query for repeatable work.
  • Record the source URL and extraction date.
  • Keep the original export as a backup.

Conclusion

Exporting scraped data to Excel is only the first step; the real value comes from turning raw rows into reliable numbers and clear answers. Start with a clean export that contains only the columns you need, convert prices, ratings and dates into proper types, remove duplicates using a unique URL, and then use Excel Tables, PivotTables and charts to explore the data. For recurring work, record your cleaning steps in Power Query so each new export updates your analysis with a single refresh. Keep the source and date with every workbook, and you'll have a dependable, repeatable process from web page to insight.

Step-by-step instructions

  1. Run the extraction

    Use the tool with the mode that fits the page.

  2. Select the dataset

    Click the tab for the data you want.

  3. Choose columns

    Untick columns you don't need.

  4. Click Excel (.xlsx)

    The workbook downloads immediately.

  5. Clean

    Convert prices, split combined fields, remove duplicates.

  6. Analyse

    Use filters, formulas, pivot tables and charts.

Example

Product titlePrice (text)Price (number)Rating
Aurora Desk Lamp$43.9943.994.1
Nimbus Wireless Mouse$19.4919.494.5

The "Price (number)" column was added with =VALUE(SUBSTITUTE(B2,"$","")), then used in a PivotTable for average price per category.

Best practices

  • Export only the columns you need.
  • Keep the original export and clean a copy.
  • Use the URL column as a unique key when removing duplicates.
  • Record repeat cleaning steps in Power Query.
  • Write the source URL and date in the workbook.
Try it on a real page

Open the Instant Data Scraper tool and extract your first dataset in seconds.

Start Extracting

Frequently asked questions