If you're having trouble opening CSVs with Excel, you're not alone. This article can help you get up and running.
Seeing Messy Data in Excel?
It’s likely a known, regional formatting issue. The file is almost certainly ok. To test this assertion, let's troubleshoot with 3 quick questions. If you can answer No to any of them, try the steps below.
-
Can I open all other Crescat CSVs in Excel without issues?
-
Is my device set to a region that uses periods as decimal points (e.g.,
100,000.00
)? -
Am I using File > Import, rather than double-clicking the file or using Open?
Use "Import" Instead of "Open"
This works for most users. Rather than double-clicking the file or using Open from the file menu, use File > Import instead—it handles regional settings more reliably.
Try a Different Spreadsheet App
Excel behaves differently across versions and setups, so importing may not be effective without additional configuration. Here’s what to try next:
-
Google Sheets – This nearly always works.
-
Excel Online – Don't want to use your google account? The web-based Excel may avoid regional issues, but user feedback is limited here because our users often try Google Sheets first, which typically resolves it.
The Google Sheets Method
Open a blank/desired spreadsheet, and once inside, click Import.
Then select the Upload option in the pop-up that appears (If that is most relevant) and upload your file.
If Google Sheets Fixes it
Then the file is fine, but Excel is misreading the format (likely using the wrong delimiter). You can investigate Excel-specific settings online, or stick with Google Sheets.
If Google Sheets Didn't Manage Either
Now it's likely the CSV itself has a problem. Reach out to support via the Help menu in the upper-right corner of Crescat.
Report an Issue will help you notify Support.