Question Locked

What is the best practice for Formatting .CSV imported to excel doc?

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I export a portion of a database as a .csv and then bring it into Excel, format it, and provide the completed spread sheet to a superior weekly.

What is the best way to automate the formatting of the spreadsheet? I tweak all of the column widths, word wrap, data types and then format the data as a table for sorting and filtering.

2 replies

by markp24

Hi you can use a macro, bvscript even an app called autoIT. all these should be ale to do what your asking.

This discussion is closed to new replies.