# Questions? We have answers. ## Search ### Best practices for formatting CSV files [Best practices for formatting CSV files](https://support.mindbridge.ai/hc/en-us/articles/21079552648855-Best-practices-for-formatting-CSV-files) ### Data formatting tips and tricks [Data formatting tips and tricks](https://support.mindbridge.ai/hc/en-us/articles/360058191873-Data-formatting-tips-and-tricks) ### Best practices: Before submitting a data formatting request [Best practices: Before submitting a data formatting request](https://support.mindbridge.ai/hc/en-us/articles/1500011252782-Best-practices-Before-submitting-a-data-formatting-request) ### Data Formatting Guide: The Basics [Data Formatting Guide: The Basics](https://support.mindbridge.ai/hc/en-us/articles/1500007438162-Data-Formatting-Guide-The-Basics) ### Data Formatting Guide: Data Requirements [Data Formatting Guide: Data Requirements](https://support.mindbridge.ai/hc/en-us/articles/1500007417741-Data-Formatting-Guide-Data-Requirements) ### Data Formatting Guide: Automate repetitive tasks in Excel Power Query [Data Formatting Guide: Automate repetitive tasks in Excel Power Query](https://support.mindbridge.ai/hc/en-us/articles/6316571770007-Data-Formatting-Guide-Automate-repetitive-tasks-in-Excel-Power-Query) ### Data Formatting Guide: Tools and Resources [Data Formatting Guide: Tools and Resources](https://support.mindbridge.ai/hc/en-us/articles/1500007411522-Data-Formatting-Guide-Tools-and-Resources) ### Data Formatting Guide: Consolidating Duplicate Trial Balance Accounts [Data Formatting Guide: Consolidating Duplicate Trial Balance Accounts](https://support.mindbridge.ai/hc/en-us/articles/1500007439741-Data-Formatting-Guide-Consolidating-Duplicate-Trial-Balance-Accounts) ### Data Formatting Guide: Excel Quick Reference [Data Formatting Guide: Excel Quick Reference](https://support.mindbridge.ai/hc/en-us/articles/1500008298641-Data-Formatting-Guide-Excel-Quick-Reference) ### Data Formatting Guide: Flipping signs for a range of accounts or based on condition(s) [Data Formatting Guide: Flipping signs for a range of accounts or based on condition(s)](https://support.mindbridge.ai/hc/en-us/articles/1500008308421-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: Looking up and Retrieving Data from Another File](https://support.mindbridge.ai/hc/en-us/articles/1500008310321-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: Simple degrouping of multiple columns, fill in blank account numbers (common QuickBooks example)](https://support.mindbridge.ai/hc/en-us/articles/4407673272471-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: Ungrouping and Checking Imbalance](https://support.mindbridge.ai/hc/en-us/articles/1500008295681-Data-Formatting-Guide-Ungrouping-and-Checking-Imbalance) ### Data Formatting Guide: Ungroup and split account numbers and descriptions [Data Formatting Guide: Ungroup and split account numbers and descriptions](https://support.mindbridge.ai/hc/en-us/articles/1500008138042-Data-Formatting-Guide-Ungroup-and-split-account-numbers-and-descriptions) ### Converting dates into the appropriate format [Converting dates into the appropriate format](https://support.mindbridge.ai/hc/en-us/articles/360056329514-Converting-dates-into-the-appropriate-format) ### Convert negative credit values into positives [Convert negative credit values into positives](https://support.mindbridge.ai/hc/en-us/articles/360058191933-Convert-negative-credit-values-into-positives) ### Converting Debit and Credit Columns to Numbers in Excel [Converting Debit and Credit Columns to Numbers in Excel](https://support.mindbridge.ai/hc/en-us/articles/360058191913-Converting-Debit-and-Credit-Columns-to-Numbers-in-Excel) ### Converting Text Files (delimited or fixed width) to Excel [Converting Text Files (delimited or fixed width) to Excel](https://support.mindbridge.ai/hc/en-us/articles/1500009844861-Converting-Text-Files-delimited-or-fixed-width-to-Excel) ### Convert character delimited text files to Excel format [Convert character delimited text files to Excel format](https://support.mindbridge.ai/hc/en-us/articles/4419776540055-Convert-character-delimited-text-files-to-Excel-format) ### Extracting account and account description information in Excel [Extracting account and account description information in Excel](https://support.mindbridge.ai/hc/en-us/articles/360056329534-Extracting-account-and-account-description-information-in-Excel) ### Separating cell data in Excel [Separating cell data in Excel](https://support.mindbridge.ai/hc/en-us/articles/360056329554-Separating-cell-data-in-Excel) ### The difference between a file that can be formatted and a file that can't [The difference between a file that can be formatted and a file that can't](https://support.mindbridge.ai/hc/en-us/articles/1500009458421-The-difference-between-a-file-that-can-be-formatted-and-a-file-that-can-t) ### Ungroup and split: Extract complex patterns [Ungroup and split: Extract complex patterns](https://support.mindbridge.ai/hc/en-us/articles/1500008146382-Ungroup-and-split-Extract-complex-patterns) ## GDPdU Files ### Formatting GDPdU: Zero Opening Balance Entries for Revenue and Expenses Accounts [Formatting GDPdU: Zero Opening Balance Entries for Revenue and Expenses Accounts](https://support.mindbridge.ai/hc/en-us/articles/17141119229079-Formatting-GDPdU-Zero-Opening-Balance-Entries-for-Revenue-and-Expenses-Accounts) ### Formatting GDPdU: Running a Pre-Analysis Completeness Check [Formatting GDPdU: Running a Pre-Analysis Completeness Check](https://support.mindbridge.ai/hc/en-us/articles/16972200699415-Formatting-GDPdU-Running-a-Pre-Analysis-Completeness-Check) ### Formatting GDPdU: Identifying and Resolving Flip Accounts in the Trial Balance [Formatting GDPdU: Identifying and Resolving Flip Accounts in the Trial Balance](https://support.mindbridge.ai/hc/en-us/articles/16744737330071-Formatting-GDPdU-Identifying-and-Resolving-Flip-Accounts-in-the-Trial-Balance) ### Formatting GDPdU: Identifying and Removing Opening Balance Entries in the General Ledger [Formatting GDPdU: Identifying and Removing Opening Balance Entries in the General Ledger](https://support.mindbridge.ai/hc/en-us/articles/16744334787351-Formatting-GDPdU-Identifying-and-Removing-Opening-Balance-Entries-in-the-General-Ledger) ### Formatting GDPdU: Identifying D & K / Sub Ledger Accounts [Formatting GDPdU: Identifying D & K / Sub Ledger Accounts](https://support.mindbridge.ai/hc/en-us/articles/16638783169943-Formatting-GDPdU-Identifying-D-K-Sub-Ledger-Accounts) ### Formatting GDPdU: How do GDPdU Files Work? [Formatting GDPdU: How do GDPdU Files Work?](https://support.mindbridge.ai/hc/en-us/articles/16638376071831-Formatting-GDPdU-How-do-GDPdU-Files-Work) ### Formatting GDPdU: Data Checklist [Formatting GDPdU: Data Checklist](https://support.mindbridge.ai/hc/en-us/articles/15436750846359-Formatting-GDPdU-Data-Checklist) ## Data validation ### Data Validation: Abnormally large cells [Data Validation: Abnormally large cells](https://support.mindbridge.ai/hc/en-us/articles/4403614264855-Data-Validation-Abnormally-large-cells) ### Data Validation: Special characters that must be escaped [Data Validation: Special characters that must be escaped](https://support.mindbridge.ai/hc/en-us/articles/4403614226839-Data-Validation-Special-characters-that-must-be-escaped) ### Data Validation: Consistent number of columns [Data Validation: Consistent number of columns](https://support.mindbridge.ai/hc/en-us/articles/4403627680663-Data-Validation-Consistent-number-of-columns) ### Data validation: Date formats [Data validation: Date formats](https://support.mindbridge.ai/hc/en-us/articles/4403515913495-Data-validation-Date-formats) ### Data Validation: Why a general ledger must contain at least one numeric column [Data Validation: Why a general ledger must contain at least one numeric column](https://support.mindbridge.ai/hc/en-us/articles/4403506872471-Data-Validation-Why-a-general-ledger-must-contain-at-least-one-numeric-column)