Skip to content
FileMoat

Guide

How to make a large CSV file smaller — to upload, email or share it

A CSV too big for an upload form, an email or an AI chat? Zip it, drop duplicate rows and unused columns, or split it into parts — without losing data you need.

Updated 18 October 2026 3 min read

The upload form says the file is too large, the email bounces, or the AI assistant refuses the attachment. CSV exports grow fast — but they also shrink well, once you pick the right method.

1. Zip it (keeps everything)

CSV is plain, repetitive text, so it compresses extremely well — often 5 to 10 times. Right-click the file and choose Compress (Mac) or Send to → Compressed (zipped) folder (Windows). Use this whenever the destination accepts .zip files.

2. Remove duplicate rows

Exports merged from several sources often contain the same rows or the same customers several times. Removing them shrinks the file and fixes your totals at the same time.

3. Drop the columns you don't need

Exports usually include dozens of technical columns: internal IDs, timestamps, URLs. Deleting them can halve the size. It is also the moment to remove personal data the recipient doesn't need — names, emails, phone or account numbers. In Excel, delete the columns and save as CSV UTF-8; for files over a million rows, use Data → From Text/CSV → Transform Data and Choose Columns in Power Query instead.

4. Split it into parts

When the destination has a hard size limit per file, cut the CSV into several smaller files. The header row is repeated in each part, so every file works on its own.

5. Send a sample

To show someone the structure of a file or ask for help with it, the first few thousand rows are usually enough. Split the file and send only the first part.

Which method to choose?

  • You need every row and the destination accepts ZIP: zip it.
  • The data is messy or repeated: remove duplicates first, then zip.
  • Strict size limit per file: split it.
  • Sharing with a third party: drop columns you don't need, especially personal data.

Frequently asked questions

How much does zipping shrink a CSV?

A lot: CSV is plain, repetitive text, so a ZIP is often 5 to 10 times smaller. It is the only method that keeps every byte of the original.

Can I just delete columns in Excel?

Only if the file fits in Excel. Above 1,048,576 rows, Excel loads a cut-off copy, so saving it would lose rows. Use Power Query, or split the file first.

Is it safe to upload my CSV to an AI assistant?

Check what the file contains first. Customer lists, bank exports and HR data are personal data; remove the columns you don't need — names, emails, account numbers — before sharing the file with any online service.