importing a spreadsheet

importing a spreadsheet

Are there restrictions to importing data from a spreadsheet? I am importing a spreadsheet from Google Sheets which has multiple tabs. On the import, certain tabs are missing columns. Does data generated from a formula not import? Are there other types of data that do not import?
Scott