I’m having difficulty importing data into existing worksheet, and using the Merge Matching Rows option.
Seems like whatever options I pick, it will always duplicate my imports:
no matter what i do, it keeps appending the imported data to the bottom.
I’ve tried using different Merge matching rows.
I’ve checked / unchecked skip the import of those rows
I’ve deleted the data and started with a fresh import
I find the Column Mapping to be very strict as well. My CSV import columns don’t exactly match my sheet. I had to rearrange my sheet to better match my CSV file.
When I was first using it, I couldn’t get the mappings to work correctly. If there was a column in my CSV file that I didn’t want to map in my sheet, I had to offset it to get it to match.
and other ideas?
if i have time this week, i’ll create a test sheet that i will try with fewer columns to test, and if i have the same results, i can share that base with you.