Skip to main content

Importing Excel file and keeping all formulas and data

  • February 8, 2019
  • 1 reply
  • 78 views
Y

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

W
Forum|alt.badge.img+5
  • W_Vann_Hall
  • Inspiring
  • February 8, 2019

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

M
Terms & ConditionsAccessibility statement