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.