Easily Copy Filtered Rows to a New Table Without Manual Mapping | Clay

Easily Copy Filtered Rows to a New Table Without Manual Mapping

hey there, looking for help 🙂 I want to add the filtered rows in a filtered table, to a new table. export/import as CSV did not work. I know I can use "write to other table", but that would require me to lable every single column name first, to then map it? i just need a simple way to copy a the filtered rows (158) into a blank new sheet, without manually inputting 30 column names

8 comments

Channeled
APP
·
·
To copy your filtered rows into a new blank sheet without manually inputting column names, you can use our "write to table" feature. Here's how: 1. Create a new blank table in your workbook. 2. In your filtered table, click "Add Column" > "Write to table". 3. Select your Clay account if not already selected. 4. Choose the new blank table as your destination. 5. Enter "/" to skip list selection. 6. Map your columns by selecting the source columns and matching them to the destination columns. This will automatically create the columns in the new table. 7. Click "Save" to run the operation. This process will copy your filtered rows (158) to the new table, creating the necessary columns without manual input. If you prefer, you can also use the "Import" feature: 1. Export your filtered data as a CSV. 2. In Clay, click "Actions" > "Import" > "Import Companies From a CSV". 3. Upload your CSV file. 4. Choose "Create New Table" and click "Import".
Sources: Write to Other Table | Documentation | Clay University Import a File Write to Other Table | Documentation | Clay University
Julia K.
·
·
also trie creating some array format/list format via formular, but there it seems I'd also need to mention each column individially?
Channeled
APP
·
·
You can easily copy your filtered rows to a new blank sheet using our "write to table" feature without manually inputting column names. Here's how: 1. Create a new blank table in your workbook. 2. In your filtered table, click "Add Column" > "Write to table". 3. Select your Clay account if not already selected. 4. Choose the new blank table as your destination. 5. Enter "/" to skip list selection. 6. Map your columns by selecting the source columns. This will automatically create the columns in the new table. 7. Click "Save" to run the operation. This process will copy your 158 filtered rows to the new table, creating the necessary columns automatically. Alternatively, you can use the Import feature: 1. Export your filtered data as a CSV. 2. In Clay, click "Actions" > "Import" > "Import Companies From a CSV". 3. Upload your CSV file. 4. Choose "Create New Table" and click "Import". Both methods will transfer your data without manual column input.
Sources: Write to Other Table | Documentation | Clay University Import a File
👀1
Julia K.
·
·
I tried the CSV option...but the import stopped halfway through, for some reason it did not work (maybe weird column headers or so, not sure)
Channeled
APP
·
·
We can use our "write to table" feature to copy your filtered rows without manually inputting column names. Here's how: 1. Create a new blank table in your workbook. 2. In your filtered table, click "Add Column" > "Write to table". 3. Select your Clay account if not already chosen. 4. Choose the new blank table as your destination. 5. Enter "/" to skip list selection. 6. Map your columns by selecting the source columns. This will automatically create the columns in the new table. 7. Click "Save" to run the operation. This process will copy your 158 filtered rows to the new table, creating the necessary columns automatically without manual input.
Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University
Summiya B.
·
·
refresh your page and download as csv and then upload into a new table
Bo (.
·
·
Hey, Can you let me know what went wrong with the CSV export? It should usually work without issues. Try refreshing the table and exporting again—sometimes that clears it up. If it’s still not working, I can help figure out a smoother option. You can also do a hard refresh: Mac:Chrome and/or Firefox = Press Cmd + Shift + R Safari = Press Cmd + Option + R PC:Chrome, Firefox, Microsoft Edge = Press Ctrl + F5
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.