beerbaron Posted July 21, 2011 Share Posted July 21, 2011 I've been trying to import SEC 13F statements into Excel. Anybody tried it, so far Excel won't recognize the data as a table... BeerBaron Link to comment Share on other sites More sharing options...
woltac Posted July 21, 2011 Share Posted July 21, 2011 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now