Skip to main content
MindBridge AI
Submit a request
Sign in
Questions? We have answers.
Search
MindBridge: English (US)
Get started
Import files
Formatting data
Formatting data
Converting Text Files (delimited or fixed width) to Excel
Promoted article
Best practices for formatting CSV files
Data formatting tips and tricks
Best practices: Before submitting a data formatting request
Best practices: Large files
Data Formatting Guide: The Basics
Data Formatting Guide: Data Requirements
Data Formatting Guide: Automate repetitive tasks in Excel Power Query
Data Formatting Guide: Tools and Resources
Data Formatting Guide: Consolidating Duplicate Trial Balance Accounts
Data Formatting Guide: Excel Quick Reference
Data Formatting Guide: Flipping signs for a range of accounts or based on condition(s)
Data Formatting Guide: Looking up and Retrieving Data from Another File
Data Formatting Guide: Simple degrouping of multiple columns, fill in blank account numbers (common QuickBooks example)
Data Formatting Guide: Ungrouping and Checking Imbalance
Data Formatting Guide: Ungroup and split account numbers and descriptions
Converting dates into the appropriate format
Convert negative credit values into positives
Converting Debit and Credit Columns to Numbers in Excel
Convert character delimited text files to Excel format
Extracting account and account description information in Excel
Separating cell data in Excel
The difference between a file that can be formatted and a file that can't
Ungroup and split: Extract complex patterns
See all 24 articles