Accessing reports in Google Sheets
An easily accessible and freely available option is Google Sheets, found in the resource pack enabled when creating a Gmail account.
To access your spreadsheet, click on the Google app icon
Select the Sheets option
In the folder icon choose the option Uploads
Browse your file
Click Open
As Google integrates all of its tools, more visual items like emojis will open more easily
Converting reports in Microsoft Excel
⚠️ This conversion can only be done through Excel for computers because the version for cell phones and tablets does not have this function.
Open your file in Excel
Select the first column
In the header choose the menu Data
Click on the Text to Columns tab and a window with 3 steps will appear:
Keep Delimited selected on first page
Change from Tab to Comma on second page
Select the Text option on the third
Click on Finish to preview the new formatting
My worksheet displayed symbols instead of letters
Depending on the formatting used in the online catalog, some data will not be recognized by Excel.
To avoid these errors, open Excel
Create a new blank workbook
In the header click on Data
On the Get External Data tab, select Get Text Data
Choose your file
Click Import
A window with 3 steps will appear:
Keep Delimited selected on the first page and make sure the selected file source is 65001 : Unicode (UTF-8)
Change from Tab to Comma on second page
Keep the General option on the third
Click on Finish to preview the new formatting
