Simple problem - Trying to export my ClearPass endpoints to a readible format (Excel) for sorting and filtering etc. I exported my endpoints, which comes across as a CSV file. File size is roughly 405MB, which I cannot import into Excel natively, it won't allow the file size. My option is to figure out an efficient way to do this or to break the entire file up into bits (about 30MB at a time) and import all seperately into Excel.
What's the best way to do this and what have others done?