[WebToSpark](/)/Export field guide

Export field guide

# What is a CSV file? Open web exports in Excel

A CSV file stores table records as text. Learn how to import WebToSpark CSV into Excel, select UTF-8, preserve identifiers and inspect comment rows.

Updated 2026-10-18v1.2.0[Read this page as Markdown ↗](/docs/open-csv-in-excel/index.md)

On this page

[What is CSV format?](#section-1)[How to open a CSV file in Excel](#section-2)[UTF-8, quotes and nested columns](#section-3)[CSV vs Excel: keep the source and the working file](#section-4)

[Get WebToSpark](/download/)

## What is CSV format?

CSV means comma-separated values. It is a text representation of tabular data, not an Excel workbook. CSV does not store multiple worksheets, workbook styles or charts. Delimiters and quoting let a field contain punctuation or a line break, so counting visual text lines is not a reliable record count.

In WebToSpark, CSV exports extracted records, including different row types from a source. A discussion can produce several rows; the number of rows is not the number of source pages used by the free allowance.

[CSV format: RFC 4180 ↗](https://www.rfc-editor.org/rfc/rfc4180.html)

## How to open a CSV file in Excel

Menus differ by Excel version and operating system. Microsoft notes that direct opening of UTF-8 CSV is reliable when a BOM is present; otherwise its documented import route allows explicit decoding. Do not assume every application detects encoding correctly.

1.  Keep a copy of the original export before editing. Open Excel and use Data → Get Data → From File → From Text/CSV, or the Text/CSV import command available in your version.
2.  Select the exported .csv file. Review the preview, choose a comma delimiter and UTF-8 encoding if the importer asks.
3.  Before loading, treat identifiers and values you must preserve exactly as text. Check automatic type conversion for dates, long numbers and leading zeros.
4.  Load the table, filter record\_type, and inspect a few records against the original web source. Save as an Excel workbook if you need multiple sheets or formatting.

[Microsoft: Opening CSV UTF-8 files correctly in Excel ↗](https://support.microsoft.com/en-us/excel/opening-csv-utf-8-files-correctly-in-excel)

## UTF-8, quotes and nested columns

CSV describes the table representation; UTF-8 describes character encoding. “CSV UTF-8” is still CSV. If Chinese text or accented characters appear garbled, reimport the unchanged original with the correct encoding rather than saving over it. If all values appear in one column, check the delimiter.

WebToSpark uses a stable superset of columns. Filter record\_type=comment for captured comments. parent\_id and depth describe captured relationships; links\_json and metrics\_json can contain serialized arrays or objects. A comma inside quoted text does not necessarily create a new cell.

Cells beginning with spreadsheet-formula trigger characters are prefixed with an apostrophe by the exporter. Preserve that protection when handling untrusted web text. It is not a reason to remove prefixes in bulk.

[CSV format: RFC 4180 ↗](https://www.rfc-editor.org/rfc/rfc4180.html)

## CSV vs Excel: keep the source and the working file

Use the original CSV as an interchange copy and an .xlsx workbook as your analysis workspace. Do not repeatedly overwrite the source while experimenting with types, filters or transformations. Media remain URLs, not downloaded attachments. Missing page content cannot be recovered by opening the file in Excel.

[Compare export formats ↗](/docs/export-formats/)[Troubleshoot extraction ↗](/docs/troubleshooting/)

FAQ

## A few things worth knowing.

[Frequently asked questions](/faq/)

Why are there several rows for one Reddit page?+

The exporter can emit a document row, primary content and separate comment rows. Use record\_type to distinguish them; row count is not monthly page usage.

Why does CSV show everything in one column?+

The spreadsheet may be using a different delimiter. Import the original CSV explicitly, inspect the preview and select comma separation.

## Keep exploring

[Export Reddit comments](/supported-sites/reddit/)[Choose an export format](/docs/export-formats/)[Open CSV in Excel](/docs/open-csv-in-excel/)[Open JSON files](/docs/open-json-files/)

A small tool for your next big question.

## Your next idea is already  
somewhere in your tabs.

Keep the context. Follow the spark.

[Start collecting](/download/) Free local download. No account needed.

✳

Canonical: https://webtospark.com/docs/open-csv-in-excel/
Updated: 2026-10-18