# Edit a large CSV. Keep the original. CSV editing workflow · Windows and macOS A mislabeled record should not become a manual file-splitting project. Find the record, review its complete value and save your correction in a separate copy, with local processing on Windows and Mac. [Download for Windows ↓](https://rowcove.com/download/windows) [Download for macOS ↓](https://rowcove.com/download/macos) Version 0.1.1 · Windows x64 · macOS Apple Silicon · [Install guide →](https://rowcove.com/download) Free Preview is read-only, up to 100 records. Supported editing and saving require Pro. Saving even a small correction can read and write the complete source. Updated Nov 1, 2026 · [RowCove](https://rowcove.com/) **How do I edit a large CSV without overwriting the source?** Open the file in RowCove, verify its delimiter, headers and encoding, then use a supported full-file filter to locate the intended record. In Pro, switch to Edit, review the cell in the inspector and choose Stage edit. Use Save copy with a new destination, then reopen the output to check the changed value and unaffected records. **In this guide** [Check the CSV setup](https://rowcove.com/guides/edit-large-csv#setup) [Locate the source record](https://rowcove.com/guides/edit-large-csv#locate) [Stage a reviewed change](https://rowcove.com/guides/edit-large-csv#stage) [Check the output scope](https://rowcove.com/guides/edit-large-csv#scope) [Save and verify the copy](https://rowcove.com/guides/edit-large-csv#save) [Plan time and disk space](https://rowcove.com/guides/edit-large-csv#resources) [All practical guides ↗](https://rowcove.com/guides) ## 1. Check headers, separators and encoding Choose Open data and select the file in the native file picker. Review the detected source before opening. If all fields appear in one column, check the separator; if text looks wrong, check encoding. An incorrect header choice can turn the first record into field names. Inspect a few complete values in free Preview before planning an edit. Quoted commas, embedded line breaks, empty values and long identifiers deserve attention. Follow the [large CSV opening guide](https://rowcove.com/guides/large-csv-files) if the detected structure does not match your source. ## 2. Locate the intended source record Find loaded rows searches the page already loaded. Use the supported Pro full-file filter when the record could be elsewhere in the source. Choose a meaningful identifier, category or time interval, inspect the result and add sorting only when it helps the investigation. Keep the original source-record context with the selected cell. The first row in a sorted or filtered result is not automatically the first row of the original file. A stable identifier is useful for checking the saved output independently. For a research export, the [backtest investigation guide](https://rowcove.com/guides/backtest-results) explains how to retain the source population and metric meaning. The example below is synthetic mock data, not a real strategy result. ## 3. Stage a small, reviewed cell change 1. Switch from Inspect to Edit. 2. Select the field in the intended record and read its complete value in the inspector. 3. Enter the replacement and choose Stage edit. 4. Review the staged change. Use undo if it affects the wrong record or field. 5. Repeat only for the records you have checked. Reviewed change · synthetic (mock) data | Record identifier | Field | Original value | Expected saved value | | --- | --- | --- | --- | | mock_002 | label | review | accepted | | mock_003 | label | review | review | Scroll horizontally to compare every field. Keyboard: focus the table and use the arrow keys. For this mock task, only the label belonging to mock_002 should change. Inspect mock_003 afterward as an unaffected record. Enter the intended cell value; CSV delimiters and quote escaping are part of writing the output file, rather than instructions to concatenate fields by hand. ## 4. Distinguish editing scope from export scope In the CSV cell-edit workflow, Save copy writes a copy of the source with the staged source-record edits. The current filter or sort helps you find records; it does not automatically make the saved artifact a filtered-only or sorted export. If you need only a subset or a different output order, establish an explicit supported export workflow for that result. Check the output's row count, identifiers and order. Seeing a narrow grid is not evidence that the saved file contains only those visible records. ## 5. Save to a new destination and reopen it Choose Save copy and use the native save dialog to select a separate output path. Keep enough space for the new file. Review progress while the save runs; avoid repeatedly starting the same output operation. After completion, open the saved file as another source and verify: - The intended identifier and field contain the replacement. - Representative unaffected records retain their values. - Headers, column alignment, delimiter and text decoding match the intended output. - The saved file's scope and ordering match your task. Check values that other tools might interpret differently. For example, a mock identifier `000127`, a long numeric identifier and a decimal written as `1000.00` deserve a complete-value check in both source and output. A shortened grid label is not enough to verify them. When your downstream task requires the original text representation, compare the decoded fields with an independent CSV reader as well. The original remains available for comparison. A separate data copy is not a byte-for-byte formatting guarantee: CSV quoting and line-ending representation can be rewritten, and output encoding should be checked when moving between tools. ## 6. Budget a complete output operation Even one cell change can require reading and writing the complete source when you save an independent CSV copy. Its duration and disk requirements differ from showing a first page or running a selective filter. Allow space for the output, file indexes and any query work. The [20 GB mock CSV comparison](https://rowcove.com/compare) reports its measured access, filter and sort tasks. Those numbers are not a measured save-copy time. Use the [performance model](https://rowcove.com/performance) , visible progress and cancellation for the actual operation. This guide covers the CSV workflow. [JSON document editing](https://rowcove.com/json-viewer) and [bounded Parquet editing](https://rowcove.com/parquet-viewer) have different limits; review [the format-operation matrix](https://rowcove.com/formats) . See [current Pro introductory and renewal terms](https://rowcove.com/pricing) before purchasing for a repeated task. ## Continue your workflow - [Large CSV viewer and editor](https://rowcove.com/csv-viewer) - [Check source setup and opening](https://rowcove.com/guides/large-csv-files) - [Measured 20 GB mock CSV tasks](https://rowcove.com/compare) - [Use authorized local data tools](https://rowcove.com/docs-mcp) ## Try the first page on your own data. Start on Windows or macOS: source information and up to 100 records, read-only. Review reader capabilities before planning a full-file Pro workflow. [Download for Windows ↓](https://rowcove.com/download/windows) [Download for macOS ↓](https://rowcove.com/download/macos) Version 0.1.1 · Windows x64 · macOS Apple Silicon · [Install guide →](https://rowcove.com/download) [Reader capabilities →](https://rowcove.com/formats) ## CSV editing and output scope Questions, answered [Contact support →](https://rowcove.com/support) ### Will editing overwrite my original dataset? Sources open read-only by default. Where the reader supports editing, switch to Edit and stage your changes. Save copy writes the result to a separate destination, keeping the original available for comparison and recovery. Before saving a large result, check the destination and free disk space. Open the new copy and verify representative records, types and the intended changes. Some readers are read-only or expose metadata rather than editable records; use the operations shown for the detected source. [Follow the save-copy workflow](https://rowcove.com/docs#edit) [Check editing support](https://rowcove.com/formats) ### Does Save copy save only the filtered CSV rows? In the CSV cell-edit workflow, Save copy writes a copy of the original source with the staged source-record edits. The current filter or sort helps locate records; it does not automatically turn that copy into a filtered-only or sorted export. If a subset or different output ordering is required, establish an explicit supported export workflow for that result. Reopen the output and check its row count, record identifiers and order. A narrow grid alone does not establish the saved file’s scope. [Check editing and output scope](https://rowcove.com/guides/edit-large-csv#scope) [Check the source before editing](https://rowcove.com/guides/large-csv-files) ### Why can saving one CSV cell change still take time? Saving an independent CSV copy can require reading and writing the complete source even when only one cell changes. Allow free disk space for the output, indexes and any query work. The cost differs from displaying a first page or running a selective filter. Review progress and use cancellation when the scope is wrong. Reopen a completed output to verify the intended change and unaffected records. The published mock CSV access, filter and sort timings are not save-copy measurements. [Plan the output operation](https://rowcove.com/guides/edit-large-csv#resources) [Understand performance scope](https://rowcove.com/performance) ### How do I check that a small CSV correction kept the other values intact? Reopen the saved copy and locate the changed record by a stable identifier. Verify the replacement and several unaffected records, using complete cell values rather than shortened grid labels. Include leading-zero identifiers, long numbers, date-like text and decimal representations where those matter to your task. Keep the original for comparison and use an independent CSV reader when downstream processing depends on exact field text. Save copy preserves the source as a separate file, but it is not a promise of identical quoting, line endings or encoding. The CSV editing guide explains the output scope and checks before you use the new file. [Verify a saved CSV copy](https://rowcove.com/guides/edit-large-csv#save) --- Canonical page: https://rowcove.com/guides/edit-large-csv Updated: 2026-11-01 [Related Agent reference](https://rowcove.com/agent/workflows.md)