PRACTICAL GUIDE · 22 NOVEMBER 2026
How to export a web table to Excel without breaking the numbers.
A supplier price such as €1.234,56 can become text or the wrong amount when pasted into a spreadsheet with different regional settings. Here is a small table you can use to check the entire export before taking your own data.
1. Install Rowverge and try this table
Add Rowverge from the Chrome Web Store, return here and click its toolbar icon. Select the sample table below. These are synthetic examples, not live supplier prices.
| Item | Displayed price | Format |
|---|---|---|
| Desk lamp | €1.234,56 | European |
| Office chair | $1,234.56 | US |
| Storage unit | ₺1.234,56 | Turkish |
2. Decide whether to clean numbers
Turn on number cleaning to remove currency symbols and thousands separators from recognised numeric cells. The three sample prices should become 1234.56. Leave cleaning off when you need the original display text. Check identifiers, dates and totals before relying on an exported file.
3. Choose CSV for Excel, or copy for Sheets
For Excel: download CSV. Rowverge creates a text-based CSV file, not an .xlsx workbook. In Excel choose Data → From Text/CSV, select UTF-8 and a comma delimiter, then check the preview. If the cleaned numbers are treated as text, use the import column type or locale that recognises a dot decimal separator, such as English (United States).
For Google Sheets: choose Copy for Sheets in Rowverge and paste into an empty cell. This uses tab-separated clipboard data so the columns stay separate. Sheets still interprets numbers using the spreadsheet's locale. If needed, set a matching locale under File → Settings before importing. No Google account connection to Rowverge is required.
4. Check the result before exporting more
For this sample, all three numeric prices should equal 1234.56; their sum should be 3703.68. If the total is wrong or the values remain text, correct the spreadsheet's import settings and try again. CSV does not carry the source website's number-format or styling settings.
What about multiple pages?
Add the current table to the collector, navigate to the next page yourself, and add its rows. Export the collection when finished. Keep the column structure consistent across pages. Rowverge does not automatically click through an entire website.
When this approach will not work
The page needs a detectable HTML table or supported repeating list. Text inside an image, a scanned PDF or a protected browser page cannot be exported with Rowverge. Lazy-loaded rows must be loaded on the page first. Free exports include up to 50 rows, which is enough to test this three-row example; Pro removes the row limit.
Try your actual table for free.
The table stays in your browser. You can check the result before deciding whether Pro is useful.
Install Rowverge ↗For import settings, see Microsoft's CSV import instructions and Google Sheets locale settings.