The CSV from here https://en.www.inegi.org.mx/programas/endireh/2016/#open_data in /conjunto_de_datos_tb_sec_vi_endireh_2016/conjunto_de_datos/ loads very slowly because it has trailing newline chars in its tokens, which fools the CSV loader into thinking we have multiline text, which slows the parsing down a lot.
fix is here: https://gerrit.libreoffice.org/c/core/+/188286
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/749a312ea55eaa0c3dc352a0e8a1f32f8b6fd9cf tdf#167664 slow loading CSV with tokens ending in newline It will be available in 26.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.