When preparing a bulk upload (e.g. adding labels to fundraisers), you may notice that some Campaign IDs appear incorrect or shortened after opening your export in Excel.
This is a common Excel behaviour and not an issue with GivePanel.
Why this happens
Facebook fundraiser Campaign IDs are long numerical values (typically 15–16 digits).
When opened in Excel, these can be automatically converted into scientific notation (e.g. 6.28E+14) or rounded, causing some digits to be replaced with zeros. This corrupts the original value.
Because Campaign IDs are used to match bulk uploads such as labels to the correct fundraiser, this can prevent bulk uploads from working as expected.
How to fix this
The easiest way to resolve this is by using the Fundraiser Page Link (URL) to recover the correct Campaign ID.
Since URLs are treated as text, Excel does not modify them when opening your fundraiser list in excel.
Step by step
Export your fundraiser list from GivePanel
Keep the following column:
Page Link (this is required)
Add your new bulk upload column (e.g. Label if you're adding labels to fundraiser records)
Insert a new column to the left of the Page Link column
(this is where the Repaired Campaign ID will go)For example:
Column A: Repaired Campaign ID (new column)
Column B: Page Link
Column C: Label
In the first row of your new column (e.g. A2), add the formula: =RIGHT(B2,LEN(B2)-25)
The formula will pull the campaign ID from the fundraising page url in the column located to the right
Drag the formula down to apply it to all rows
Use this new column as your Campaign ID column when uploading
Important notes
This method works for Facebook fundraisers only, as the Campaign ID is included in the URL. Excel does not have this issue with JustGiving Fundraiser IDs
Instagram fundraisers cannot be fixed this way, as the Campaign ID is not present in the URL