Check out this video showing how to link Microsoft Excel spreadsheets that contain data and equations to a SolidWorks model. The two different methods of linking presented both use a design table. This is very useful if you have done a lot of calculations within Excel and want a way to use them in a model without having to manually put them in.
I hope this video has been helpful in showing how to link spreadsheets to SolidWorks.
Ian Jutras