Today I did an Enhanced FTP export from a Data Extension that was holding 8,498,752 records with 166 MB. In the Enhanced FTP directory, a file for it was generated with the size of 203,632 KB. I transferred it to my local folder & when I opened it, I got to see only 1,046,574 records & the rest weren't there. I tried exporting a couple of times compressing the file but nothing helped me. I couldn't figure out the solution. Can someone help me understand why this is happening? Is there a size restriction for export? What steps I need to take to export all of the records?

Thanks in advance!

1 Answer 1


As long as the export was executed correctly (if there is a file - yes), the file will contain all the records the Data Extension has. You can verify that by importing the exact same file back to another DE and receiving an email notification with the import results.

As for the opening of large files, there is a limitation of Excel to only open up to 1 048 576 rows by 16 384 columns. To avoid that you would need either to split the file into smaller ones or use some dedicated application for opening large .csv files (e.g. Gigasheet)

  • Thanks for your response! It helped me understand where I was stuck. Commented May 5, 2022 at 6:09

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .