Forum Discussion

JessicaAdkins's avatar
JessicaAdkins
Qrew Cadet
9 years ago

Is there any way to copy data from an Excel file and paste it in the Grid Edit report?

I am attempting to copy data from an Excel file and past it into the Grid Edit report. I know you can manually click each field and edit data in the grid edit, but I thought at one point, you could pa...
Grid edit
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
5 years ago
Often-times, copy/pasting from Excel introduces hidden/special characters into your Quick Base, so there's that. Aside from this, I know it doesn't solve for every scenario, but is this spreadsheet something that you could setup to be used as the basis of a Sync table or an Import? Even if you import too much data into a dummy table and then have a way - whether manual or automated with Pipelines - to pull just the data you want into your actual records might be a solution.

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
MartinSuske1's avatar
MartinSuske1
Qrew Member
4 years ago
Just came across that issue too and it seems to be a feature of the grid edit function to not allow external clipboard data to be inserted. I had no problems copying the same data into other QB fields.

I cannot understand the restriction though. Seems quite common to insert data from other sources in a data grid. Validation could be implemented for special types.

Giving every user the possibility to upload/merge data or build individual pipelines for that purpose would be worse for me.

Edit:
I just learned about the "Paste Special" function that can be called from the context menu of a cell in grid edit mode. I guess that'll solve my issue.
​

------------------------------
Martin Suske
------------------------------