Print this page

Data export CSV file is too big to open

Knowledge Article Number 000206083
Description After running Data Export and unzipping files, you may find some CSV files are too large to open in Excel.  For example, task.csv file may contain over 1 million records and Microsoft Excel cannot successfully open the file.
Resolution There are various free tools that will split one CSV file into many smaller CSV files.  Please use your favorite search engine to search: "CSV Splitter" to find, download, and install your favorite CSV splitter program.

Suppose you have a task.csv file that contains 1 million records.  You could use your favorite CSV splitter program to split 1 task.csv file into 10 smaller files each containing 100K records.  Once you have smaller CSV files, you can open them with Microsoft Excel or similar program.

promote demote