quadratic icon indicating copy to clipboard operation
quadratic copied to clipboard

Published 20 hours ago • verified publisher icon quadratichq

.CSV import fails if there is a description row

Open luke-quadratic opened this issue 1 year ago • 3 comments

It's not uncommon for .CSV format to have a row that is a description right after the sheet title. In this case the .CSV import is getting cut off. E.g. the following .CSV should show up as column names and data, instead it will just import as the column names and the description (date range in this case). CleanShot 2024-01-08 at 13 25 00@2x

luke-quadratic avatar Jan 08 '24 20:01 luke-quadratic

Without an import UI, I don't think we can properly handle this case. If there was an import UI, we could ask for the row number to start importing from, which could address this issue.

ddimaria avatar Jan 08 '24 20:01 ddimaria

Noted, popping down to low prio in that case since the return on time seems relatively low. @ddimaria

luke-quadratic avatar Jan 08 '24 21:01 luke-quadratic

I think it should just import the description into a cell on the second line. Then the data starting the row before that. No need for a import UI

davidkircos avatar Jan 08 '24 22:01 davidkircos

reopen if any users run into issues around edge case CSVs, original case appears fixed

luke-quadratic avatar May 30 '24 19:05 luke-quadratic