Sometimes, Excel can modify data, particularly long campaign IDs. This is a known issue with Excel, not the GivePanel Report Builder or Export to CSV. If you notice changes in your Excel sheet, such as unusual characters or altered data, here’s how to fix it.
Quick Fix:
Open Excel and go to the Data tab.
Under Get External Data, click on From Text and select the CSV file exported from GivePanel.
In the wizard that appears, set the data type for each column. For the Campaign ID column, make sure to choose Text to avoid Excel misreading the data.
Why This Happens:
Facebook campaign IDs are often longer than 15 characters. By default, Excel can truncate or alter these IDs, such as replacing the last character with a zero, which can sometimes make the data unusable.
Solutions:
Use alternative spreadsheet software (e.g., Numbers on Mac) that doesn't have this issue.
Configure Excel correctly to read long IDs as text, preventing data corruption.
We’re working on a permanent fix, but this method will prevent Excel from changing your data.