Why aren't columns from my spreadsheet uploading into the grid?

The most common reason why columns from a spreadsheet are not uploading into the grid properly when using 'Fill From Spreadsheet' is that the column headers in the spreadsheet do not match the column headers in the RFP grid. If the headers match exactly, this will ensure that the data from your spreadsheet gets uploaded without any issues.  

Note: The order of the columns does not matter.

Additional steps can be taken to ensure that the data in your spreadsheet gets uploaded with ease.
  • When possible, copy everything and paste as a value.
  • Select everything and choose the General format.
  • ‚ÄčLastly, save as a .XLS or .XLSX.

Did you find this article helpful?