How can I convert Consumer Expenditure Survey Text data tables into Excel format?
The Consumer Expenditure Survey data tables in Text format can be converted into an EXCEL spread sheet by taking the following steps: • Highlight and copy the Text data table. • Paste the copied table into an Excel spreadsheet. • Highlight the column that the data were pasted in. • In the “Data” menu in Excel, select “Text to Columns” option. • Choose “fixed width” in the text to columns wizard. • Column dividers should default to the appropriate column positions. If not, click on the places you want the columns to be located. • Select finish.
