Search the Community
Showing results for tags 'spreadsheet'.
Found 3 results
I have information stored in a spreadsheet which I would like to import/place into a table in a note. I have tried copy/paste, copy and paste tab delimited file, copy and paste comma delimited, pure text, rtf and .doc but all of the data always pastes into one cell. There appears to be mo import command available. Any idea how I could accomplish the import? Thanks, Jim
If I posted about this already, I apologise. If I didn't post it before I also apologise. If someone else suggested it here, I'm sorry that I'm now taking credit for finding it. In fact let's just start off with me being really, really, really sorry and move on. Then, on a happier note.. I liked Transpose, because it was, until very recently, a database to which you could add structured information, and process and display it online in various ways. It's now closed down, but I found a new contender. Airtable. Which is a spreadsheet to which you can add data. It's also a relational database - you can link new facts to stuff you already know - and a calendar (if you have dates in there somewhere) and a KanBan chart of items sorted by various options. In fact it's quite a little powerhouse of collaboration and connectability which I'm initially using for one project as a trial. Too much information for detail, but Transpose Airtable* would mean (forinstance) that if I was arranging meetings throughout the year on different subjects at different venues, I could have one database of venues, one database of subjects, and one database of details and dates, linking to the relevant subjects and venues so I don't have to keep entering the same information over and over for each event. I can share the Calendar view with my customers so they know what's coming up in their area, and if they sign up with one or other venue I can use their sign-up form (created in Airtable) to look-up or populate their customer record for my information later. I can use the KanBan view to keep me on track with support material for each event. It looks really good. Obviously do your own due diligence before you invest hours setting up your own system, and (just for information) I get all my data together in Evernote before I set it up in Airtable and they support Zapier, so I should be able to arrange to copy details across rather than enter it twice. It's an app worth Evernoting, even if you don't need it now. (Just to confirm - I have no connection with them!) PS Evernote - the relational database thing is what they call 'transcopy' in Wikis, where you show some or all the content of one note as part of another. If only Evernote did that sort of thing I wouldn't need to use third-party software... * PPS - Oops.