Sometimes, I just find it easier to use Excel when I'm organizing data to add to Quickbase.
In this example, I copied some notes I had into an Excel spreadsheet so that I could organize them before adding them as records to Quickbase.
Rather than saving the file and importing the file to Quickbase, I often prefer a quicker route using the clipboard.
This is true whether I'm adding a single record or thousands of records.
Steps:
1. Prep your data in Excel (add the field names to the first row to minimize issues)
2. Copy the data using Ctrl + C (⌘ + C if using a Mac)
3. Navigate to the tabel where the data will be imported
4. From the table's home page, click on the 3 dots in the upper right corner
5. Select "Import/Export"
6. Select "Import into a table from clipboard"
7. Click in the big empty box and paste using Ctrl + V (⌘ + V if using a Mac)
8. Click "Import Data..."
9. Verify your data looks correct with the right headers and fields selected
10. If everything looks good press "Import"
Caution: If your data has commas in it you may have issues with this import method as the comma will be treated as a delimiter and the data will be split over additional fields. If this is true for much of your data, the better option is to import from a file. If you only have a few commas you can circumvent the issue by placing quotations around the entire value for that field.
For more Quickbase Tips, Tricks, and Tutorials in your inbox – subscribe today! https://www.quickbasejunkie.com/sign-up
#quickbase #quickbasejunkie #database #nocode #shorts #quickbaseimport
🔥🔥🔥 FREE TOOLBOX🔥🔥🔥
Get The Action Button – 50+ Actions & URL Components EXPLAINED!
https://quickbasejunkie.com/toolbox
Feeling like a Junkie? Subscribe Now!
https://youtube.com/c/QuickBaseJunkie...
LET'S CONNECT!
LinkedIn ➤ / quickbasejunkie
Instagram ➤ / quickbasejunkie
Facebook ➤ https://fb.me/quickbasejunkie
Quick Base Junkie ➤ https://quickbasejunkie.com
Learn More About Quickbase @ https://quickbase.com
© Quick Base Junkie
COPYRIGHT NOTICE: The content, title, description, and specific ways in which the information in this video is organized, documented, and presented are the creative property of Quick Base Junkie. For use in any medium attribution is required, for questions or use permission, contact me @ https://quickbasejunkie.com/contact.
On this page of the site you can watch the video online Import from Clipboard in Quickbase with a duration of hours minute second in good quality, which was uploaded by the user Quick Base Junkie 07 September 2023, share the link with friends and acquaintances, this video has already been watched 151 times on youtube and it was liked by 5 viewers. Enjoy your viewing!