Exporting as CSV or Excel

When your cleaning is done, you'll usually want the data out of Dotwave and into whatever tool comes next — a BI platform, a notebook, a spreadsheet. Dotwave exports the fully cleaned version of your dataset as either a CSV file or an Excel workbook, both formatted for immediate use downstream. This article covers how to export, exactly what ends up in the file, the specifics of each format, and how Dotwave handles very large datasets.

How to export

Open the dataset you want, then use the Export dropdown. You'll find two download options:

• Download as CSV — a plain, universally readable text file.
• Download as Excel (.xlsx) — a formatted spreadsheet workbook.

Pick the one that matches your next tool and the download begins. There is no separate "prepare" step — the file Dotwave hands you already reflects all of your cleaning.

What is exported

Every export contains the fully cleaned version of your data. All the cleaning operations in your recipe are applied to the data before it is written out, in the order you defined them, so what you download matches exactly what you see after cleaning. Crucially, the original file is not affected — Dotwave cleans by layering a reusable recipe on top of the untouched source, so exporting the cleaned result never overwrites or alters the raw upload you started from.

CSV format

The CSV export is built for maximum compatibility:

• UTF-8 encoding, so accented characters and non-Latin text survive intact.
• No index column — you get only your real columns, with no extra row-number column bolted on the left.
• Filename of the form DatasetName_cleaned_YYYYMMDD.csv, so the date of the export is baked into the name and files don't collide as you re-export over time.

Excel format

The Excel export is a tidy, ready-to-present workbook:

• A single sheet named Cleaned Data.
• Auto-sized columns, so values are readable the moment the file opens rather than clipped behind default column widths.
• No index column — just your data.
• Filename of the form DatasetName_cleaned_YYYYMMDD.xlsx, matching the CSV naming convention.

Large files

Big datasets export fine, but Dotwave sets expectations first. Files over 100,000 rows show a warning — Large file — export may take a few seconds — so a brief pause on a heavy dataset reads as normal rather than a hang. To keep memory in check on large exports, CSV downloads stream in chunks rather than building the whole file in one block, which lets Dotwave handle sizable datasets reliably.