Why We Use Formulas
We add a special formula (="VALUE") to your CSV exports to protect your data. This ensures:
ZIP codes keep their leading zeros (00501 stays 00501)
Long numbers don't turn into scientific notation
Phone numbers stay properly formatted
Your data uploads exactly as you entered it
This is normal and working correctly. When data uploads to dialers or CRMs, only the actual value transfers - not the formula.
For Google Sheets Users
Import Your File Correctly
Open Google Sheets
Click File > Import
Select your CSV file
Important: Keep "Convert text to numbers, dates, and formulas" CHECKED ✓
Click Import data
That's it! Your data will display correctly with all formatting preserved.
For Excel Users
Good news! Just open the file normally - it works perfectly.
Double-click the CSV file, or
Open it from within Excel
Your data will display correctly with all formatting preserved.
Common Questions
Q: Will the formula show up in my dialer/CRM?
A: No, only the actual values upload to your systems.
Q: Can I edit the data?
A: Yes, just maintain the formula format for any new entries that need protection.
Quick Troubleshooting
If something looks wrong:
Google Sheets: Make sure you used File > Import (not just opened the file)
Excel: The file should work fine when opened normally
Still having issues?: Contact support Monday thru Friday, 10am to 6pm EST, or use our SkipMatrix AI chat for 24/7 support
Remember: The formula wrapper (="VALUE") is there to protect your data. It ensures what you upload is exactly what gets delivered, with no unwanted changes.