Forum Discussion

jaycnz188's avatar
jaycnz188
Copper Contributor
May 29, 2023

Blank .csv upload to SharePoint issue.

Hello all, I have a very simple document library where I am trying to store .csv files that we receive monthly. When I tried to upload some .csv files to test (using real previous months), I found...
Document Library
SharePoint Online
NikolinoDE's avatar
NikolinoDE
Gold Contributor
May 30, 2023

jaycnz188 

If you are experiencing issues with .csv files becoming blank or not opening correctly after uploading them to a document library in SharePoint Online, there are a few potential reasons and solutions you can explore:

  1. File Format: Ensure that the .csv files you are uploading are in the correct format and encoding. Check that the files are saved as comma-separated values and that the data is properly structured with each field separated by a comma. Also, confirm that the encoding of the file is compatible with SharePoint Online, such as UTF-8 or ANSI.

  2. File Size Limitations: SharePoint Online has limitations on the maximum file size that can be uploaded. If your .csv files exceed these limits, it may cause issues during the upload process or result in a blank file. Verify that the file size of your .csv files is within the allowed limits.

  3. Special Characters or Formatting: Check if the .csv files contain any special characters, unsupported formatting, or formulas that may be causing issues during the upload process. Remove any special characters or unsupported formatting and ensure that the file only contains plain text or values.

  4. Column Mapping: When uploading the .csv files, make sure that the column mapping is correctly configured. SharePoint Online attempts to map the columns in the .csv file to the columns in the document library. If there is a mismatch or ambiguity in the column mapping, it could lead to unexpected behavior or blank files. Verify that the column mapping is accurate during the upload process.

  5. Test with Different .csv Files: Try uploading different .csv files to the document library to see if the issue persists. This can help determine if the problem is specific to certain files or if it's a more general issue.

  6. Check SharePoint Online Settings: Review the settings and configurations of your SharePoint Online environment. Ensure that there are no customizations, restrictions, or limitations that could be causing the issue. You may need to consult with your SharePoint administrator or IT support team for assistance in checking the SharePoint settings.

Resources