How to Import an Excel Spreadsheet Into Access With a Macro. If you ever wanted to click a magic button and make complex business tasks happen automatically, macros can make that wish come true.

Displaying values on a map chart is more meaningful than handing someone a sheet of data. Thanks to Microsoft Excel's Geography data type, creating a map chart is easier than you might think.

Learn how to control Excel worksheets with spin buttons, scrollbars, option buttons, and checkboxes.

A nice Excel sheet looks fine and you can import basic graphics into the spreadsheet itself but with InDesign you can create an entire template that surrounds the spreadsheet.

Reader A3sthetix points us toward BatchGeo, a smart spreadsheet-to-Google-Map conversion tool. I was faced with the daunting task of mapping over a hundred addresses to a map today.