When opening up a csv directly into Excel it recognizes Gift Cards as being numbers but by default it only supports number formats up to 11 digits. This can result in numbers longer than 11 digits appearing incorrectly, i.e.
As such to see numbers with over 11 digits the cells need to be formatted as text. To do this please follow the following instructions.
1. Save the downloaded / supplied csv to a location on your desktop.
2. Open a new Excel document (do not double click the saved csv) and perform the following actions.
a. Click the Data tab, click From Text.
b. Find the csv on your filesystem and click import.
c. In the first step of the import Wizard select whether the csv has header row.
d. In the second step of the import Wizard select Comma (ensure no other checkboxes are marked).
e. In the last step of the import Wizard click on the column header of any columns with numbers greater than 11 digits and click the Text radio button.
f. Click finish and you should see the data in the sheet correctly presented.
3. You can then save the file as you wish (even as an excel document as you have now specified the format of these columns as text).
** Hint a csv (comma-separated values) is a text file. If you were to open a text editor (such as notepad) you can open a csv directly from here (i.e. File > Open). This will show you the raw data without any program formatting and allow you to check what you see in excel is accurate.