When downloading reports from Orion pages, the files are saved in .xlsx format. The extra apostrophe (') appearing in certain columns is not a bug but a default behavior in Excel for handling string values.
- Why This Happens:
- Excel automatically adds an apostrophe before text-formatted values to ensure proper data interpretation.
- This does not affect calculations or data integrity but may be visible when editing cells.
- How to Remove the Extra Apostrophe:
- Open the downloaded .xlsx file in Excel.
- Click File > Save As and select .csv as the file format.
- Close the file and reopen the newly saved .csv file.
- Once saved as a .csv, the extra apostrophe will no longer appear in the columns when viewed.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article