Title: problema csv
Last modified: November 27, 2023
---
# problema csv
* Resolved [erbenda](https://wordpress.org/support/users/hellsbrigade/)
* (@hellsbrigade)
* [2 years, 4 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%2F2%2F%3Foutput_format%3Dmd&locale=en_US)
to see the link]_
Viewing 15 replies - 16 through 30 (of 58 total)
[←](https://wordpress.org/support/topic/problema-csv/?output_format=md) [1](https://wordpress.org/support/topic/problema-csv/?output_format=md)
2 [3](https://wordpress.org/support/topic/problema-csv/page/3/?output_format=md)
[4](https://wordpress.org/support/topic/problema-csv/page/4/?output_format=md) [→](https://wordpress.org/support/topic/problema-csv/page/3/?output_format=md)
* Thread Starter [erbenda](https://wordpress.org/support/users/hellsbrigade/)
* (@hellsbrigade)
* [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/2/#post-17254379)
* leggendo il post sarebbe stato inutile questa risposta in quanto ho fornito il
report completo e verificato anche con Google sheets e il fatto che si indichi
di utilizzare un altro programma vuol dire che si risponde senza leggere tutto
il post.
* [Mirko P.](https://wordpress.org/support/users/rainfallnixfig/)
* (@rainfallnixfig)
* [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/2/#post-17254581)
* Ciao Fabio
I’d like to take a look at the sample CSV but it’s [expired or deleted](https://ibb.co/Jm0Kvd6).
Can you please share a new CSV (making sure it doesn’t expire) with just the
product having the issue, so that I can test it out with different software and
see if I can replicate it?
* You can use a cloud solution such as [Google Drive](https://www.google.com/drive/)
or [Dropbox](https://www.dropbox.com/it/).
* Thank you for your cooperation.
* Thread Starter [erbenda](https://wordpress.org/support/users/hellsbrigade/)
* (@hellsbrigade)
* [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/2/#post-17254690)
* [https://we.tl/t-cvlCiQzYfC](https://we.tl/t-cvlCiQzYfC) il link è ancora valido
- This reply was modified 2 years, 4 months ago by [erbenda](https://wordpress.org/support/users/hellsbrigade/).
* [anastas10s](https://wordpress.org/support/users/anastas10s/)
* (@anastas10s)
* [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/2/#post-17256480)
* Hi there [@hellsbrigade](https://wordpress.org/support/users/hellsbrigade/) 👋
* As I was able to download, inspect, and verify all is good with the CSV file
earlier on, I’d like to take a step back, and take another look at the original
inquiry:
* > “Good morning, I would like to know why the exported CSV file generates anomalies
> such as indicating a value ‘4.2 instead of 4.2 for weight or counting 1kg as
> 100kg if opened with the default language set to Italian. However, if opened
> with the default language set to English, the problem occurs with prices.”
* Gut feeling, this is probably to do with the way the machine you’re currently
utilizing is set up. To clarify, the responses [here](https://wordpress.org/support/topic/problema-csv/#post-17244496),
[here](https://wordpress.org/support/topic/problema-csv/#post-17247025), and
[here](https://wordpress.org/support/topic/problema-csv/#post-17251455) include
code (as showcased in the screenshot below), that might be complicating things,
undesirably.
* 
* Direct link to image: [https://snipboard.io/EHB3q1.jpg](https://snipboard.io/EHB3q1.jpg)
* How possible is to try with a different machine (desktop, laptop, tablet, mobile
phone), and see if the issue persists, or otherwise?
* Looking forward to hearing from you!
* Thread Starter [erbenda](https://wordpress.org/support/users/hellsbrigade/)
* (@hellsbrigade)
* [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/2/#post-17257433)
* quello indicato nello screen ” Link diretto all’immagine: [https://snipboard.io/EHB3q](https://snipboard.io/EHB3q1.jpg)
potrebbe essere semplicemente un fattore di traduttore di edge invece il problema
del file non è imputabile a quello ma al file csv stesso [https://snipboard.io/cJANK5.jpg](https://snipboard.io/cJANK5.jpg)
- This reply was modified 2 years, 4 months ago by [erbenda](https://wordpress.org/support/users/hellsbrigade/).
- This reply was modified 2 years, 4 months ago by [erbenda](https://wordpress.org/support/users/hellsbrigade/).
- This reply was modified 2 years, 4 months ago by [erbenda](https://wordpress.org/support/users/hellsbrigade/).
- This reply was modified 2 years, 4 months ago by [erbenda](https://wordpress.org/support/users/hellsbrigade/).
* Thread Starter [erbenda](https://wordpress.org/support/users/hellsbrigade/)
* (@hellsbrigade)
* [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/2/#post-17257515)
* come si può vedere dagli screen questo è il file che io ho riscaricato dallo
stesso link fornito ecco come appare con apertura in italiano [https://snipboard.io/fiqHO9.jpg](https://snipboard.io/fiqHO9.jpg)
questo è quello che compare [https://snipboard.io/ZcgxuX.jpg](https://snipboard.io/ZcgxuX.jpg)
* [Mirko P.](https://wordpress.org/support/users/rainfallnixfig/)
* (@rainfallnixfig)
* [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/2/#post-17257690)
* Hi [@hellsbrigade](https://wordpress.org/support/users/hellsbrigade/)
* I imported the CSV file in [Google Sheets](https://www.google.com/sheets/about/)
but I can’t replicate the `‘5.4` you see under “Peso (kg). This leads me to believe
it’s a problem with the application you’re using.
* **Google Sheets**
* 
* _Full size: [https://i.vgy.me/fuIuKi.png](https://i.vgy.me/fuIuKi.png)_
* Test with a different device or spreadsheet program. More likely this is due
to a misconfiguration or the software not being up to date.
* Feel free to reach out of you have any questions.
* Thread Starter [erbenda](https://wordpress.org/support/users/hellsbrigade/)
* (@hellsbrigade)
* [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/2/#post-17257807)
* il problema si presenta con openoffice libreoffice oltre che con office2022
* [Saif](https://wordpress.org/support/users/babylon1999/)
* (@babylon1999)
* [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/2/#post-17258730)
* Hello [@hellsbrigade](https://wordpress.org/support/users/hellsbrigade/),
* > the problem occurs with openoffice libreoffice as well as office2022
* Thanks for the update!
I suggest using an alternative CSV viewer. My colleagues
and I have already demonstrated this doesn’t happen with [Google Sheets](https://www.google.com/sheets/about/),
but you can also use other options like [Microsoft Excel](https://www.microsoft.com/en-us/microsoft-365/excel)(
the online version is free). :)Let us know if you have any other questions!
* Thread Starter [erbenda](https://wordpress.org/support/users/hellsbrigade/)
* (@hellsbrigade)
* [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/2/#post-17259204)
* ” il problema si presenta con openoffice libreoffice oltre che con** office2022
è microsoft excel** “
* Plugin Support [Shameem – a11n](https://wordpress.org/support/users/shameemreza/)
* (@shameemreza)
* [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/2/#post-17260427)
* Hi [@hellsbrigade](https://wordpress.org/support/users/hellsbrigade/),
* This could be due to the way these applications are interpreting the CSV file.
You could try changing the import settings of your CSV file in these applications.
For instance, in Excel, you can select “Data” > “From Text” and then specify
the delimiter and encoding.
* If the issue persists, I suggest you try using [Google Sheets](https://www.google.com/sheets/about/)
to edit your CSV file.
* Please let us know if you need further assistance. We’re here to help!
* Thread Starter [erbenda](https://wordpress.org/support/users/hellsbrigade/)
* (@hellsbrigade)
* [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/2/#post-17260484)
* dato che tutti avete provato senza mai provare quello che io ho indicato immagino
che non ci sia la volontà di capire il problema in quanto se io importo con la,
voglio poter esportare con la , nel peso e non con il . in quanto dovrei convertire
tutti i file csv giornalmente in quanto WooCommerce sul singolo prodotto nel
peso richiede il . invece nei csv è ininfluente vorrei capire come sia possibile
ciò
* Plugin Support [Shameem – a11n](https://wordpress.org/support/users/shameemreza/)
* (@shameemreza)
* [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/2/#post-17260597)
* Hi [@hellsbrigade](https://wordpress.org/support/users/hellsbrigade/)
* WooCommerce, by default, uses periods (.) as decimal separators in product weights.
If your CSV files are using commas (,), you might encounter issues during the
import process.
* However, you can change the decimal separator while importing from CSV. While
importing using the WooComerce import option, click on “Show Advanced Settings”
and change the CSV Delimiter to (,) if that is your preference.
* 
* Direct link: [https://gifyu.com/image/SiExO](https://gifyu.com/image/SiExO)
* If still the issue still continues, I recommend using WP All in All import, Product
CSV Import Suite, or [Import Export Suite for WooCommerce](https://woo.com/products/import-export-suite-for-woocommerce)
plugin. These plugins provide an advanced option to import, merge, and export
products and variations to and from WooCommerce using a CSV file.
* I hope this resolves your issue. Let us know how that goes.
* Thread Starter [erbenda](https://wordpress.org/support/users/hellsbrigade/)
* (@hellsbrigade)
* [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/2/#post-17260609)
* questa soluzione non è funzionale in quanto riconoscerà tutti i . come separatori
quindi anche quelli nelle descrizioni invece il plugin or [Import Export Suite for WooCommerce](https://woo.com/products/import-export-suite-for-woocommerce)
plugin non esporta tutti i campi di WooCommerce senza acquistare la versione
a pagamento gli altri non li conosco
* Plugin Support [Feten L. a11n](https://wordpress.org/support/users/fetenlakhal/)
* (@fetenlakhal)
* [2 years, 4 months ago](https://wordpress.org/support/topic/problema-csv/page/2/#post-17274241)
* Hi there!
* Thank you for your patience.
* I want to take a step back and ask if it’s possible to send us a video showing
how you export the products and what you see when you open the downloaded CSV
file. (The video you shared doesn’t show the downloaded CSV file.)
* 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?
* Finally, please note that you can change the decimal separator in WooCommerce
> Settings > General: [https://d.pr/i/UgJg1h](https://d.pr/i/UgJg1h)
Viewing 15 replies - 16 through 30 (of 58 total)
[←](https://wordpress.org/support/topic/problema-csv/?output_format=md) [1](https://wordpress.org/support/topic/problema-csv/?output_format=md)
2 [3](https://wordpress.org/support/topic/problema-csv/page/3/?output_format=md)
[4](https://wordpress.org/support/topic/problema-csv/page/4/?output_format=md) [→](https://wordpress.org/support/topic/problema-csv/page/3/?output_format=md)
The topic ‘problema csv’ is closed to new replies.
* 
* [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, 1 month ago](https://wordpress.org/support/topic/problema-csv/page/4/#post-17456840)
* Status: resolved