Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Importing Excel file and keeping all formulas and data

Topic Labels: ImportingExporting
3016 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
W_Vann_Hall
13 - Mars
13 - Mars

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