SoldEazy Help and Support
Home » Categories » 12 Frequently Asked Questions

I’m using Microsoft Office Excel/ WPS Number software to open a CSV file, but there are scrambled characters in it/ long number displayed in scientific notation/ 0 before text format number got removed,what should I do?

Article Number: 587 | Rating: Unrated | Last Updated: Thu, May 9, 2019 5:48 PM
I'm using Microsoft Office Excel/ WPS Number
software to open a CSV file, but there are scrambled
characters in it/ long number displayed in scientific
notation/ 0 before text format number got
removed,what should I do?

 

I'm using Microsoft Office Excel/ WPS Number  software to open a CSV file, but there are scrambled  characters in it/ long number displayed in scientific  notation/ 0 before text format number got  removed,what should I do?
  1. Disadvantages when using Microsoft Excel
    • Special characters cannot be shown correctly
      eg, Germany letter ä will be scrambled in excel
    • Long numbers displayed in scientific notation  
      eg, 6230000000000 being displayed as 6.23E+12
    • 0 before text format number got removed  
      eg, New Jersey has a zip code of 08201，Microsoft excel tends to remove the "0" in the front automatically, and makes it a useless number "8201"
  2. How to open and edit csv file correctly
    • Download and install Apache OpenOffice set/ LibreOffice set
      Please go to the official website to download and install
      https://www.openoffice.org/download/
      https://www.libreoffice.org/download/download/
    • Use OpenOffice Calc/ LibreOffice Calc to csv file 
      Right click on the csv file, select "open file" section, select "OpenOffice Calc" 

      Every time OpenOffice Calc/ LibreOffice Calc opens a csv file, it will ask how you want to process the csv file, if the csv file is downloaded from SoldEazy, please use the settings like below

    • Set OpenOffice Calc/ LibreOffice Calc as default software to open a csv file
      Right click on csv file, choose "open file" section, then choose "other softwares"

      Select "OpenOffice Calc"/ "LibreOffice Calc" as the software used to open file and check the "open all .csv files with this program" and confirm

***Fin***
Posted : - Wed, Apr 17, 2019 12:07 PM. This article has been viewed 5273 times.
Filed Under: 12 Frequently Asked Questions
0 (0)
Article Rating (No Votes)
Rate this article
Attachments
There are no attachments for this article.
Related Articles RSS Feed
How to turn off ’Click & Collect’ in Australia site
Viewed 2095 times since Wed, Jul 29, 2020
What is eGD? How to set the eGD? Why my listing have a green eGD label?
Viewed 9913 times since Fri, Jul 24, 2020
My listing is associated a fitment table, now it’s gone, what happened?
Viewed 3148 times since Mon, Sep 24, 2018
Why did the system return "Fail to get product information" when importing compatibility fitment table from an eBay listing of other sellers?
Viewed 2598 times since Tue, Dec 11, 2018
Introduction of Promoted Listings
Viewed 2839 times since Fri, Jul 20, 2018
Have set up schedule correctly and assigneddatasheets to schedule, but not all of themare listed successfully?
Viewed 2467 times since Mon, Aug 6, 2018
I just registered an account, but cannot log in, cannot "forgot password", then failed to "resend verification email" or "resend verification text"
Viewed 14231 times since Wed, Apr 25, 2018
About "Second Chance Offer"
Viewed 13478 times since Mon, Nov 23, 2020
What Does the Tag “Sold as a special offer” Mean from eBay Sales Record?
Viewed 31148 times since Tue, Jul 10, 2018
How to successfully remove all country/region from the "exclusion list" (ExcludeShiptToLocations) in a listing
Viewed 794 times since Wed, Mar 8, 2023