[Skip to main content](#vessel-content) # Large CSV file - how to downsize ## - **[davidvan](/forum/user/41992-davidvan "View davidvan's Profile")** - [![davidvan's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/41992-davidvan "View davidvan's Profile") Topic Author - [ Offline](/forum/user/41992-davidvan) Less More - Posts: 10 - Thank you received: 0 - - 9 years 7 months ago [\#265391](#265391) by [davidvan](/forum/user/41992-davidvan "View davidvan's Profile") *[Large CSV file - how to downsize](/forum/37-import-export-csv-xls/889431-large-csv-file-how-to-downsize#265391 "Hi, I have an excell file with 1100 rows. The excell file size is 500kb, but when i export it to csv it's about 18MB. When i import it in hikashop it takes a very long time to process it. Is there a way to downsize it? When I open the csv in wordpad i see that between every product, there are about sixteen thousend ; characters. Probably for every empty colomn? Is there a way to leave them out when i export to a csv file and would that have an influence on the processing time in hikashop? Thanks in advance")* was created by *[davidvan](/forum/user/41992-davidvan "View davidvan's Profile")* Hi, I have an excell file with 1100 rows. The excell file size is 500kb, but when i export it to csv it's about 18MB. When i import it in hikashop it takes a very long time to process it. Is there a way to downsize it? When I open the csv in wordpad i see that between every product, there are about sixteen thousend ; characters. Probably for every empty colomn? Is there a way to leave them out when i export to a csv file and would that have an influence on the processing time in hikashop? Thanks in advance Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODk0MzEtbGFyZ2UtY3N2LWZpbGUtaG93LXRvLWRvd25zaXplP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 9 years 7 months ago [\#265398](#265398) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Large CSV file - how to downsize](/forum/37-import-export-csv-xls/889431-large-csv-file-how-to-downsize#265398 "Hi, I have an excell file with 1100 rows. The excell file size is 500kb, but when i export it to csv it's about 18MB. When i import it in hikashop it takes a very long time to process it. Is there a way to downsize it? When I open the csv in wordpad i see that between every product, there are about sixteen thousend ; characters. Probably for every empty colomn? Is there a way to leave them out when i export to a csv file and would that have an influence on the processing time in hikashop? Thanks in advance")* Hi, Delete the columns you don't need in Excel and then export it to CSV. That should significantly reduce the size. Also note that the fact that it takes a lot of time to process the CSV might not be linked to the size of the CSV itself. For example, if you have URLs for the images of the products, HikaShop would have to download each image one after another. With more than a thousand images to download, it would be logical that it would take time to import the CSV. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84ODk0MzEtbGFyZ2UtY3N2LWZpbGUtaG93LXRvLWRvd25zaXplP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.114 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)