How to import large CSV files? It may be necessary to import files with tens of thousands of rows and several MB into a management system or your e-commerce. The time required in this case could be excessive, and especially in online applications, this can cause either a server timeout or a browser freeze.

This forces us to start over. In the case of PrestaShop, by using PrestaXLS, we can filter our CSV and resume from the last imported product, but with large files, even this operation becomes very difficult. Except for the use of specific modules that utilize ajax for the import. A simple option is to split the CSV into multiple parts ...

In this case, we can use Simple Text Splitter, a software that allows you to split text files (CSV files are nothing more than text files) into multiple parts. It is open-source software and can be downloaded from here: http://sourceforge.net/projects/simpletextsplit/files/

Author: Loris Modena

SENIOR DEVELOPER

Per Ind Loris Modena, owner of Arte e Informatica, started working in the IT sector in 1989 as a system administrator responsible for the maintenance and installation of computer systems. He began programming for the web in 1997, focusing on CGI programming in PERL and later transitioning to programming in PHP and JavaScript. During this time, he became familiar with the Open Source world and the management of Linux servers.

Product added to wishlist