Oct 24, 2020 07:55 AM
How can I export a view in a tab-delimited format? CSV messes with columns that have commas within them, like product titles and product descriptions.
I tried searching the forums here and asking about how to make CSV work, but then it occurred to me that a tab-delimited format might be the solution. The online marketplace I work with does accept those.
Copy/pasting won’t work because (a) we have to update everyday and (b) some marketplaces [like Amazon] have over 150 fields to fill [setting up formulas to fill many of them].
Oct 24, 2020 08:21 AM
You should be able to open, use, or import the CSV file into whatever app that you want, and it should interpret & display & handle the data just fine. The extra commas should not cause any problems. Are you specifically having a problem with a specific app?
.
Oct 24, 2020 10:53 AM
I downloaded a file in CSV format from Homebase software (specifically designed for booksellers) and it broke a number of cells apart because they had commas within. I’m fixing this in Excel and plan to copy/paste each column/field one at a time into Airtable. But I’m worried that when I download the CSV from Airtable, I’ll have the same problem again. And I’ll be needing to send updates to Amazon and other online marketplaces everyday.
Oct 24, 2020 03:13 PM
It’s possible that Homebase isn’t generating the CSV file correctly, because normally those extra commas shouldn’t be a problem. For example, if you download a CSV file from Airtable with commas in your fields, it opens up just fine in Excel or Google Sheets or other apps.
Oct 24, 2020 05:10 PM
Oh, fingers crossed that’s the case! I’ll be ready to test the theory tomorrow and I’ll report back with the results. Thanks, Scott!