Guide 06 of 12

How to Download Website Data as CSV

Download scraped website data as a CSV file the right way: UTF-8 encoding, delimiters, Excel compatibility, formula-injection protection and importing into other tools.

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

How to Download Website Data as CSV

CSV — comma-separated values — is the universal language of tabular data. Databases, CRMs, BI dashboards, Python, R and every spreadsheet app can read it. That makes CSV the best choice when your scraped data is going into another system rather than straight to a person.

CSV is also deceptively simple: most problems people have with it come from encoding, delimiters and quoting. This guide explains how the Instant Data Scraper tool writes CSV files, how to open them correctly everywhere, and how to import them into the tools you use.

What a CSV file is

A CSV file is plain text. Each line is a row, values are separated by commas, and the first line usually holds the column names:

Name,Price,URL
Aurora Desk Lamp,$43.99,https://shop.example.com/p/1
"Brass Lamp, Large",$59.00,https://shop.example.com/p/2

Because the second name contains a comma, it is wrapped in double quotes so it stays in one cell.

How our CSV exports are written

UTF-8 with BOM

Every file is UTF-8 encoded with a byte-order mark. Accents, currency symbols and non-Latin scripts display correctly, and Excel recognises the encoding automatically.

Standard quoting

Values containing commas, quotes or line breaks are quoted, and quotes inside values are doubled — the RFC 4180 convention most software expects.

Header row

The first row contains your selected column names, in the order shown in the preview.

Formula-injection protection

A scraped value starting with =, +, - or @ could be executed as a formula when the file is opened in a spreadsheet. Such text values are prefixed with an apostrophe so they display safely. Plain negative numbers like -5 are left unchanged.

CSV vs. Excel vs. JSON

FormatBest forNot ideal for
CSVImports, databases, scripts, large filesSharing with non-technical colleagues
Excel (.xlsx)Human analysis, sharing, filtersAutomated pipelines
JSONDevelopers, APIs, nested dataSpreadsheet users

Opening CSV files correctly

Microsoft Excel

Double-clicking usually works thanks to the UTF-8 BOM. If all data appears in column A (common where the regional list separator is a semicolon), use Data → From Text/CSV, choose 65001: Unicode (UTF-8) and the Comma delimiter.

Google Sheets

File → Import → Upload, then choose "Detect automatically" for the separator.

LibreOffice

Opening the file shows an import dialog — choose UTF-8 and comma separated.

Leading zeros

Spreadsheets may drop leading zeros from codes like 00123. When importing, set that column's type to Text.

Importing CSV into other tools

MySQL / MariaDB

LOAD DATA LOCAL INFILE 'export.csv' INTO TABLE products
CHARACTER SET utf8mb4 FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n' IGNORE 1 LINES;

Python (pandas)

import pandas as pd
df = pd.read_csv("export.csv", encoding="utf-8-sig")

R

df <- read.csv("export.csv", fileEncoding = "UTF-8-BOM")

CRMs and marketing tools

Most offer a CSV import wizard that maps columns to fields. Rename headers in the file first if the wizard expects specific names.

Working with large CSV files

  • Use the column picker to export only what you need — smaller files are faster everywhere.
  • Open very large files with Power Query, a database or pandas rather than double-clicking.
  • Keep one CSV per dataset; don't mix tables with different columns.

CSV rules worth knowing

  • Delimiter — the character between values; ours is a comma.
  • Enclosure — double quotes around values that contain delimiters, quotes or line breaks.
  • Escaping — a quote inside a value is written as two quotes: "He said ""hi""".
  • Line endings — each row ends with a newline; values with line breaks stay inside quotes.
  • Encoding — UTF-8 is the modern standard; the BOM helps Excel recognise it.

Using CSV in automated workflows

Scheduled reports

Save each export with a dated file name and load the folder into Power BI, Looker Studio or Excel Power Query to build trend reports.

Databases

CSV is the simplest way to bulk-load rows into MySQL, PostgreSQL or SQLite. Create a table whose columns match the header row, then import.

Scripts

Python, R and Node.js all have robust CSV readers. Always specify the encoding and let the library handle quoting — never split lines on commas yourself.

Version control

Because CSV is plain text, you can compare two exports with a diff tool to see exactly which rows changed.

More import examples

PostgreSQL

\copy products FROM 'export.csv' WITH (FORMAT csv, HEADER true, ENCODING 'UTF8');

SQLite

.mode csv
.import --skip 1 export.csv products

Node.js

// npm install csv-parse
import { parse } from 'csv-parse/sync';
const rows = parse(fs.readFileSync('export.csv'), { columns: true, bom: true });

Security: why formula injection matters

Scraped text comes from websites you don't control. A malicious page could contain a value like =HYPERLINK("http://bad.example","Click") or a formula that tries to run commands. When such a CSV is opened in a spreadsheet, the value could be treated as a formula. That's why our exports prefix risky values with an apostrophe. If you build your own CSV files from web data, apply the same protection and never enable "external content" prompts for files you don't trust.

Practical CSV tips

  • Name files clearly: site_dataset_YYYY-MM-DD.csv.
  • Keep one dataset per file with consistent column names.
  • Don't edit a CSV in Excel and save it back if another system needs UTF-8 — use "CSV UTF-8" as the save type.
  • Compress large CSV files (zip) before emailing them.
  • Document what each column means for colleagues who will use the file.

Walkthrough: loading scraped data into a database

  1. Extract a public directory with pagination and choose the listing dataset.
  2. Untick image and icon columns, leaving name, category, city and website.
  3. Download CSV. The file name tells you the site and date.
  4. Create a matching database table with columns name, category, city and website.
  5. Import with the database's CSV loader, skipping the header row and using UTF-8.
  6. Run a quick check: SELECT COUNT(*) should match the row count shown in the tool.
  7. Add a unique index on the website column to prevent duplicates in future imports.

CSV checklist

  • Correct dataset and columns selected.
  • Opened or imported as UTF-8.
  • Comma chosen as the delimiter.
  • Code-like columns imported as text (to keep leading zeros).
  • Row count verified after import.
  • File named with the site and date.
  • Stored securely and deleted when no longer needed.

CSV glossary

  • BOM — byte-order mark, an invisible marker at the start of the file that identifies UTF-8.
  • Delimiter — the character separating values (comma, semicolon or tab).
  • Enclosure — the quote character that wraps values containing delimiters.
  • RFC 4180 — the common specification describing CSV formatting.
  • TSV — tab-separated values, a close relative of CSV.

Why CSV is still the standard

CSV has been around for decades and newer formats exist, yet it remains the most widely supported way to move tabular data. The reasons are simple: it is plain text, so any system can read it; it is compact, so even large datasets stay manageable; and it has no hidden formatting or formulas that could change your values. When a data import fails, you can open the CSV in a text editor and see exactly what is inside.

That simplicity is also why small details matter so much. A CSV file has no built-in way to say which encoding it uses, which delimiter separates values or whether a column holds numbers or text. Different programs make different assumptions, and that is where garbled characters, merged columns and lost leading zeros come from. Instant Data Scraper removes most of the guesswork by always using UTF-8 with a byte-order mark, commas as delimiters and standard quoting. When you import the file, telling the receiving program those same three facts is usually all it takes to get a perfect result.

If you only need to read the data yourself, the Excel export is often more convenient. Use CSV whenever another system, script or colleague's tool will process the file.

Who uses CSV exports, and how

Analysts load CSV files into BI dashboards such as Power BI or Looker Studio, where each new export becomes another data point in a trend line. Because the column names stay the same between exports, dashboards refresh without any rework.

Developers prefer CSV or JSON because every programming language can read them. A short script can load a CSV, filter rows, enrich them with other data and write the result to a database in a few lines of code.

Marketing and operations teams use CSV to move lists between tools — for example importing a list of public partner websites into a project tracker. The import wizards in these tools map CSV columns to fields, so clear, consistent headers make the process painless.

Researchers archive CSV files alongside their notes because plain text remains readable for decades, long after proprietary formats change. Adding the source URL and extraction date to the file name gives every dataset a clear provenance.

Common CSV mistakes

  • Re-saving in the wrong encoding — when saving from Excel, choose "CSV UTF-8 (Comma delimited)".
  • Splitting on commas manually — values with commas inside quotes break naive scripts; use a proper CSV parser.
  • Losing leading zeros — import code columns as text.
  • Mixing datasets in one file — keep one table per CSV with consistent columns.
  • Opening untrusted CSVs carelessly — be cautious with formulas and external content prompts.

Key takeaways

  • Use CSV for imports, databases and scripts; Excel for people.
  • Our CSV files are UTF-8 with BOM, comma-delimited and properly quoted.
  • Formula-like values are neutralised for safety.
  • Import with UTF-8 and the comma delimiter.
  • Verify row counts after every import.

Conclusion

CSV is the most portable way to move scraped data into databases, dashboards, scripts and business tools. Instant Data Scraper produces clean, standards-compliant CSV files — UTF-8 encoded, properly quoted and protected against formula injection — so most import problems disappear. Remember the three settings every receiving program needs to know (UTF-8, comma delimiter, header row), keep one dataset per file with stable column names, and verify the row count after each import. With those habits in place, your scraped data flows smoothly from a public web page into any system you use, and the same process can be repeated reliably whenever you need fresh data.

Step-by-step instructions

  1. Extract the page

    Run the tool and confirm the preview is correct.

  2. Choose dataset and columns

    Select the right tab and untick unneeded columns.

  3. Click CSV

    The UTF-8 CSV file downloads immediately.

  4. Open or import

    Double-click to open, or import with the correct encoding.

  5. Verify

    Check a row with special characters and a quoted value.

Example

Product title,Price,Rating,URL
"Aurora Desk Lamp, Brass",$43.99,4.1 out of 5,https://shop.example.com/p/1
Nimbus Wireless Mouse,$19.49,4.5 out of 5,https://shop.example.com/p/2
'=HYPERLINK(""x""),n/a,,https://shop.example.com/p/3

The quoted first value keeps its comma; the third row's formula-like text is neutralised with an apostrophe.

Best practices

  • Use CSV for software and imports, Excel for people.
  • Always import with UTF-8 encoding.
  • Keep the header row — imports depend on it.
  • Set code-like columns to Text to keep leading zeros.
  • Keep column names stable when a system imports your files regularly.
Try it on a real page

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

Start Extracting

Frequently asked questions