Title: problema csv Last modified: November 27, 2023 --- # problema csv * Resolved [erbenda](https://wordpress.org/support/users/hellsbrigade/) * (@hellsbrigade) * [2 years, 5 months ago](https://wordpress.org/support/topic/problema-csv/) * Buongiorno vorrei sapere perchè il csv che viene esportato genera delle anomalie come nel peso indica un valore ‘4.2 invece di 4.2 come peso oppure nel peso di 1kg lo conteggia come 100 kg se lo apro con lingua predefinata italiana invece se lo apro con lingua predefinita inglese il problema si presenta nei prezzi * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fproblema-csv%2Fpage%2F3%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 15 replies - 31 through 45 (of 58 total) [←](https://wordpress.org/support/topic/problema-csv/page/2/?output_format=md) [1](https://wordpress.org/support/topic/problema-csv/?output_format=md) [2](https://wordpress.org/support/topic/problema-csv/page/2/?output_format=md) 3 [4](https://wordpress.org/support/topic/problema-csv/page/4/?output_format=md) [→](https://wordpress.org/support/topic/problema-csv/page/4/?output_format=md) * Thread Starter [erbenda](https://wordpress.org/support/users/hellsbrigade/) * (@hellsbrigade) * [2 years, 5 months ago](https://wordpress.org/support/topic/problema-csv/page/3/#post-17274618) * andando per cose semplici ” Also, I want to ask about this screenshot: [https://d.pr/i/x1pmps](https://d.pr/i/x1pmps). Are you using a specific software here to do that? il programma come si può vedere è [https://www.openoffice.org/it/](https://www.openoffice.org/it/) * 2 ” Finally, please note that you can change the decimal separator in WooCommerce > Settings > General: [https://d.pr/i/UgJg1h](https://d.pr/i/UgJg1h) questo è già stato verificato ma il delimitatore sul peso non può essere modificato quella impostazione è relativa al prezzo * e infine [https://youtu.be/VCbOU0OQonw](https://youtu.be/VCbOU0OQonw) nuovo video dell’esportazione * Plugin Support [Feten L. a11n](https://wordpress.org/support/users/fetenlakhal/) * (@fetenlakhal) * [2 years, 5 months ago](https://wordpress.org/support/topic/problema-csv/page/3/#post-17276912) * Hi there! * Thank you for your answer. * > il programma come si può vedere è [https://www.openoffice.org/it/](https://www.openoffice.org/it/) * If you don’t use this software and upload the downloaded CSV file straight to Google Drive and open it there, do you still see the same issue? * > questo è già stato verificato ma il delimitatore sul peso non può essere modificato > quella impostazione è relativa al prezzo * This setting is both the price and for the weight. * > e infine [https://youtu.be/VCbOU0OQonw](https://youtu.be/VCbOU0OQonw) nuovo > video dell’esportazione * Sorry, but I still don’t see the CSV file when you open it after the download. * Thread Starter [erbenda](https://wordpress.org/support/users/hellsbrigade/) * (@hellsbrigade) * [2 years, 5 months ago](https://wordpress.org/support/topic/problema-csv/page/3/#post-17278251) * > questo è già stato verificato ma il delimitatore sul peso non può essere modificato > quella impostazione è relativa al prezzo * Questa impostazione è sia per il prezzo che per il peso. * infatti adesso è impostato con la , ma il peso lo esporta con il . * Plugin Support [Feten L. a11n](https://wordpress.org/support/users/fetenlakhal/) * (@fetenlakhal) * [2 years, 5 months ago](https://wordpress.org/support/topic/problema-csv/page/3/#post-17278761) * Hi there! * Now I understand the issue so let me take a step back again. * When you export your products, the CSV file you download has . instead of , * And when you use [https://www.openoffice.org/it/](https://www.openoffice.org/it/) to open the CSV file and convert it . to ,, you see the issue. * Is that correct? * Can I suggest to use Google Drive instead? Here is a video: [https://d.pr/i/uWwGP7](https://d.pr/i/uWwGP7) * Can you please try that? * Thanks! * Thread Starter [erbenda](https://wordpress.org/support/users/hellsbrigade/) * (@hellsbrigade) * [2 years, 5 months ago](https://wordpress.org/support/topic/problema-csv/page/3/#post-17279795) * si conosco google drive ma non è possibile utilizzarlo in quanto il csv su cui devo lavorare è di circa 25000 righe per 10 colonne e lavorare online quella mole di dati non è fattibile in quanto non funzionano le macro e le query invece funzionanti con altri programmi in locale. * Plugin Support [Feten L. a11n](https://wordpress.org/support/users/fetenlakhal/) * (@fetenlakhal) * [2 years, 5 months ago](https://wordpress.org/support/topic/problema-csv/page/3/#post-17280309) * Hi there! * Thank you for your answer. * I totally understand your request but the issue here is the software you are using,  [https://www.openoffice.org/it/](https://www.openoffice.org/it/) , is the one that creates the issue with your CSV file and adds that ‘ * We suggest to reach out to their support team to report the problem. * Or you can still use Google Drive to convert the . to , and then download the CSV file again and work with your software for any other requests. * There is not much we can do here as WooCommerce does not create the issue. * I hope this helps and let us know if you’ll have any further questions! * Thread Starter [erbenda](https://wordpress.org/support/users/hellsbrigade/) * (@hellsbrigade) * [2 years, 5 months ago](https://wordpress.org/support/topic/problema-csv/page/3/#post-17280433) * se fosse un problema del software lo avrei soltanto con quello invece il problema si presenta su openoffice libreoffice e su office 2016 quindi il problema è sul file esportato * [Sean O))) a11n](https://wordpress.org/support/users/seanomattic/) * (@seanomattic) * [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/3/#post-17292726) * Hey there, * It seems to be the issue still appears to be the way these programs interpret the CSV. It’s fine to continue using them, but you’ll need to perform the extra step of ‘cleaning’ the CSV to convert “. ” to ” , ” – and download the CSV file for this software. * Hope this is helpful, best of luck! * Thread Starter [erbenda](https://wordpress.org/support/users/hellsbrigade/) * (@hellsbrigade) * [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/3/#post-17307783) * oggi ho provato google shetts e ho potuto constatare che il problema è presente anche lì se si toglie la spunta presente nello screen il problema si presenta anche in google quindi il problema è proprio nell’esportazione da woocommerce [https://snipboard.io/Oe0oyl.jpg](https://snipboard.io/Oe0oyl.jpg) [https://snipboard.io/UWqxvi.jpg](https://snipboard.io/UWqxvi.jpg) - This reply was modified 2 years, 4 months ago by [erbenda](https://wordpress.org/support/users/hellsbrigade/). * Plugin Support [wpnomad a11n](https://wordpress.org/support/users/wpnomad/) * (@wpnomad) * [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/3/#post-17316856) * Hi there, * > today I tried google shetts and I was able to see that the problem is also > present there. if you remove the check on the screen the problem also appears > in google so the problem is precisely in the export from woocommerce * We checked on our end but we’re not able to replicate this behaviour. This could be due to many reasons — including how the database of your site is setup (encoded) and/or effect of other plugins during the export. * Could you try temporarily disabling all other plugins except WooCommerce on your site, set the theme to a default theme like Storefront and then perform and export and see if it comes out correctly? * Thread Starter [erbenda](https://wordpress.org/support/users/hellsbrigade/) * (@hellsbrigade) * [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/3/#post-17317129) * anche disabilitando tutti i plugin in modalità staging il file viene esportato come da screen [https://snipboard.io/oXP4bM.jpg](https://snipboard.io/oXP4bM.jpg) quindi non dipende dai plugin * Plugin Support [wpnomad a11n](https://wordpress.org/support/users/wpnomad/) * (@wpnomad) * [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/3/#post-17319613) * Hi there, * As mentioned in the last reply, plugins are one aspect that could affect the export, the other aspects being database and server setup itself. * Could you try setting up some of your products on a free trial of [https://woo.com/express/](https://woo.com/express/), and then export to check? * Thread Starter [erbenda](https://wordpress.org/support/users/hellsbrigade/) * (@hellsbrigade) * [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/3/#post-17319640) * Ho eseguito anche la prova [https://woo.com/express/](https://woo.com/express/), and then export to check? e confermo che il problema si presenta anche lì come si vede dallo screen [https://snipboard.io/riBD6z.jpg](https://snipboard.io/riBD6z.jpg) quindi è un problema di woocommerce non capisco che prove abbiate eseguito voi per dire che non lo da avete impostato il valore in € il separatore dei decimali con la , e delle migliaia con il . come prevede la misurazione italiana? eseguite queste configurazioni anche voi se volete vi inoltro il file esportato da woo. com/express * [Ramona – a11n](https://wordpress.org/support/users/namona/) * (@namona) * [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/3/#post-17331275) * Hi, * Let’s see if I understand what you mean: - You have the following decimal separator settings: [https://d.pr/i/UX3kVV](https://d.pr/i/UX3kVV) - You have product price that looks like this: `12,4` [https://d.pr/i/nOooNX](https://d.pr/i/nOooNX) - You have product weight and dimensions that look like this: `12,4`: [https://d.pr/i/hbTvX8](https://d.pr/i/hbTvX8) - You export this product, and look at the CSV. The price correctly has a `,` separator, but the dimensions are now using `.` : [https://d.pr/i/wWhMJt](https://d.pr/i/wWhMJt) * Is this what you were trying to explain? * Can you share more details on the problem this causes for you? I imported the CSV back that has the `12.4` weight instead of `12,4` but the weight imported okay afterwards, showing `,` as the separator: [https://d.pr/i/zarZYW](https://d.pr/i/zarZYW) * Do you experience a different behavior? * Thread Starter [erbenda](https://wordpress.org/support/users/hellsbrigade/) * (@hellsbrigade) * [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/3/#post-17334918) * il problema è durante l’esportazione come si può vedere dagli screen allegati in precedenza ad esempio esportando un peso che sul sito mi riporta 1,2 durante l’esportazione diventa **‘1.2 **inserisce **‘** prima di alcuni valori volendo posso ricaricare il csv per voi - This reply was modified 2 years, 4 months ago by [erbenda](https://wordpress.org/support/users/hellsbrigade/). Viewing 15 replies - 31 through 45 (of 58 total) [←](https://wordpress.org/support/topic/problema-csv/page/2/?output_format=md) [1](https://wordpress.org/support/topic/problema-csv/?output_format=md) [2](https://wordpress.org/support/topic/problema-csv/page/2/?output_format=md) 3 [4](https://wordpress.org/support/topic/problema-csv/page/4/?output_format=md) [→](https://wordpress.org/support/topic/problema-csv/page/4/?output_format=md) The topic ‘problema csv’ is closed to new replies. * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504) * [WooCommerce](https://wordpress.org/plugins/woocommerce/) * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq) * [Support Threads](https://wordpress.org/support/plugin/woocommerce/) * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/) * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/) * 58 replies * 11 participants * Last reply from: [anastas10s](https://wordpress.org/support/users/anastas10s/) * Last activity: [2 years, 2 months ago](https://wordpress.org/support/topic/problema-csv/page/4/#post-17456840) * Status: resolved