You cannot copy & paste into grid edit. Using the import tool; you need to either a) match each and every field into the correct QuickBase field by checking each selection (use the checkbox to turn off 1st Row is Field Name) so that you can see what the column heading is from your spreadsheet and then match that column to the correct field in the table.
The other option is to extract from QuickBase a report containing the fields that you plan on importing back to QuickBase. Remember to include the [Record ID#] or Key Field of the table.
Then copy/paste your info into the exported spreadsheet in the right columns. Then when you do your Import; the fields should automatically align themselves correctly (you should ALWAYS visually validate) before clicking IMPORT. If you don't do this, your data will either a) go into the wrong columns (which is a problem), b) not import because the field types are different and c) overwrite existing data which you then cannot undo.
Use the Import/Export window and always visually check each column heading is being imported to the correct column in QuickBase.
