Jump to content

Importing 13F statements into Excel


beerbaron

Recommended Posts

Try saving the 13f as a text file.  Open the text file with Excel and the text import wizard should open automatically.  In step one choose fixed width and click next.  In step two you can select each column width. If you drop down into the body of the report it is easier to "surround" your data with a column.  When you click next the import wizard skips over step three and the spread sheet opens.  If you are careful when selecting your columns it will save editing time later. 

 

woltac

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...