Importing Excel file and keeping all formulas and data


#1

Hey guys, Is this possible and how to do it? The CSV format loses the formulas. And copying and pasting loses the formulas.


#2

'Taint going to happen: The spreadsheet metaphor for Airtable is an excellent elevator pitch for the product, but an RDBMS is not a spreadsheet. For one thing, a spreadsheet operates in a flat, 2D environment, where the relative positioning of cells can have a meaning. Such relationships must be explicitly defined in Airtable as the result of some sort of logical data model. I’m not saying you can’t reimplement an Excel spreadsheet in Airtable — sometimes — but you will probably have to reengineer and reimplement the logic, rather than import it whole-cloth…