Help

Importing Excel file and keeping all formulas and data

Topic Labels: ImportingExporting
2797 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Yuliya_Raquel
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1

'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…