Published Last updated Written and reviewed by the Resale Intelligence team
On this page
System CSV files are UTF-8, so Thai shows correctly in Excel. Text that could act as a formula starts with an apostrophe; set IMEI columns to text.
Files you export from the system, including reports, import problem files and the full store export, open in Excel or Google Sheets. Here is what to know before you open them.
Thai text shows as gibberish
The system's CSV files are encoded as UTF-8 and carry a marker that tells Excel so. Usually a double-click opens them correctly. If the text still looks garbled, open the file through Data → From Text/CSV and choose UTF-8 as the encoding.
An apostrophe in front of some text
Text that starts with = + - or @ gets an apostrophe in front, so Excel does not treat it as a formula; a formula hidden in data can be used to attack a computer. Don't remove the apostrophe to make the cell work as a formula. Money amounts never get the apostrophe, so they still add up normally.
IMEIs turn into strange numbers
Excel often shows long numbers in a short scientific form, and saving back to CSV can damage them. Before you edit or save, format the IMEI and serial number columns as text.
Percentages in reports
The Excel version of a report already formats percentages. The CSV version stores them as ratios, so format the column as a percentage yourself.
Keep the files safe
The full store export and customer files hold personal data. Keep them on a password-protected computer, delete them when you no longer need them, and don't forward them by chat. See Export all your store data.