Forum Discussion
Need to convert a text file to Excel - not the typical comma delineated file
I have a text file that needs to be converted to Excel however the text is grouped in a fashion that Excel doesn't not convert into columns but exactly as it appears in the text file. The text content looks like this. I added an underscore before 'name' to differenciate each group of text. How can I import to Excel where the text before each : becomes the column heading?
_name: All Company
id: 0
type: internal
privacy_setting: public
state: active
approximate_messages_count: 6
last_message_at: 2014-06-12 09:52:27.259000062 +00:00
o365_connected: false
group_admins: All Yammer Verified admins
member_counts:
internal: 24565
external: 0
uploaded_file_counts:
yammer_files: 0
sharepoint_files: 0
66069:
__name: Marine Matter
id: 66069
type: internal
privacy_setting: public
state: deleted
approximate_messages_count: 70
last_message_at: 2015-10-30 08:31:43.069999000 Z
o365_connected: false
group_admins:
with_o365_creation_rights: []
without_o365_creation_rights: []
member_counts:
internal: 0
external: 0
uploaded_file_counts:
yammer_files: 0
sharepoint_files: 0
89528:
_name: Summers Lab
id: 89528
type: internal
privacy_setting: public
state: deleted
approximate_messages_count: 10
last_message_at: 2012-10-01 11:00:22.418401000 Z
o365_connected: false
group_admins:
with_o365_creation_rights: []
without_o365_creation_rights: []
member_counts:
internal: 0
external: 0
uploaded_file_counts:
yammer_files: 0
sharepoint_files: 0
89758:
_name: Pilot Group
id: 89758
type: internal
privacy_setting: public
state: active
approximate_messages_count: 16
last_message_at: 2011-07-04 09:46:24.989397000 Z
o365_connected: false
group_admins:
with_o365_creation_rights: []
without_o365_creation_rights: []
member_counts:
internal: 0
external: 0
uploaded_file_counts:
yammer_files: 1
sharepoint_files: 0
90435: