Creating separate sheet for a vendor to feed into my report.


I have a single sheet that holds all of my Data for numerous reports tailored for whoever is working in it.

I have a vendor that works on our projects but has some other independent projects and he doesn't want to have to have two different "trackers". Currently they use Excel of course.

Can I take their excel spreadsheet and dump into Smartsheet and then just pull from their sheet for updates to mine as long as the Primary Column and other column names are the same?