![Over 2 million rows on a CSV file, I need to remove around 800,000 lines. Only way I can think to get to the data is using Power Pivot : r/excel Over 2 million rows on a CSV file, I need to remove around 800,000 lines. Only way I can think to get to the data is using Power Pivot : r/excel](https://external-preview.redd.it/i0CaVU_2s32mrG83l2Ez8xR_FlrHqH1FyJxGO-lrKLY.jpg?auto=webp&s=a504d56ff0554113a7d67b2c917420b1bcb2f487)
Over 2 million rows on a CSV file, I need to remove around 800,000 lines. Only way I can think to get to the data is using Power Pivot : r/excel
![UK Covid-19 Track & Trace Excel snafu: Uncontrolled spreadsheets lead to data loss | Patrick O'Beirne @ sysmod UK Covid-19 Track & Trace Excel snafu: Uncontrolled spreadsheets lead to data loss | Patrick O'Beirne @ sysmod](https://sysmod.files.wordpress.com/2020/10/image.png?w=395)
UK Covid-19 Track & Trace Excel snafu: Uncontrolled spreadsheets lead to data loss | Patrick O'Beirne @ sysmod
![What really caused the Excel error in NHS Test and Trace COVID-19 system? An in-depth technical analysis. – City Short Courses What really caused the Excel error in NHS Test and Trace COVID-19 system? An in-depth technical analysis. – City Short Courses](https://blogs.city.ac.uk/cityshortcourses/files/2020/10/cannotHandleCSV.png)
What really caused the Excel error in NHS Test and Trace COVID-19 system? An in-depth technical analysis. – City Short Courses
![Microsoft Excel “File Not Loaded Completely" Error? Try 7 Quick Fixes! in 2024 | Excel, Microsoft excel, Excel spreadsheets Microsoft Excel “File Not Loaded Completely" Error? Try 7 Quick Fixes! in 2024 | Excel, Microsoft excel, Excel spreadsheets](https://i.pinimg.com/originals/5c/2b/df/5c2bdfa9cadbec728c9b4d38d72dfb68.png)