I tried to import a CSV file and failed to import correctly. How can I fix it so that it imports?
There are many potential reasons why your CSV file failed to import correctly. You can begin to troubleshoot your issue by first looking for any error messages that are shown during import and for any clear issues with your sheet after import (if some data imports).
Here are some steps to troubleshoot file import issues.
Keep in mind that the CSV file format has no hard rules or data validation so it’s fairly common for CSV files to have errors. You can save any plain text file as a .csv even if it has invalid CSV content or formatting. The Row Zero file importer attempts to detect and account for these errors, but some errors will cause your file to fail to parse or open correctly. Here’s more info on common CSV errors and how to solve them.