To save the file in Excel format, choose Save As, go to the dropdown menu under File Format, and select Excel Workbook (.xlsx) Select the Finish button, and you will be taken to your file converted to Excel.Note that MindBridge is now supporting more and more date formats, including dd-mm-yy and mm-dd-yy that Excel will often convert to the wrong date, so some date columns without 4 digit years will also need to imported as Text.For example, 0439.120 would be converted to 439.12 unless the column is converted to Text format. However, if you would like to keep the text exactly as shown, such as keeping all leading and trailing 0s in account numbers, select Text for the column, because if an account number contains only numbers and "." (period/decimal character), Excel will interpret it as a number and remove leading 0s as well as 0s at the end if there is a "." in the account number.The default is General, which will allow Excel to guess the format and convert it to the corresponding type. The next screen lets you specify the data type of each column, as well as indicate if a column should not be imported ("Do not import column (Skip)").For files delimited by a character not listed, type the character in the box in the Other: option Next, select the character used as a delimiter, for example, Tab for tab-delimited files.If your data is delimited, make sure the Delimited radio button is selected (see the next section for instructions for fixed-width format text files): You will be taken to the Text Import Wizard.You might need to select to display text files or all files *.* Delimited Text Files
Open Excel and choose to open a document directly from Excel (press Ctrl-O on PC or ⌘O on Mac). However, we realize that you might want to view your files in Excel for your own analyses outside of MindBridge, and for this reason, we provide instructions here on how to convert a delimited or fixed-width text file to Excel.
It is not possible to convert to an ingestible Excel file if there are more than 1048576 rows. It is important to note that MindBridge reads these delimited text files very well, and it is not at all necessary to convert them to Excel format for ingestion. Note: CSV files are a special case of delimited text files, with, (comma) being the delimiter.
0 kommentar(er)
