2 Data Handling

Data-Handling

ASCII Importing

• FAQ-409 How do I turn off sparklines when importing ASCII files?
• FAQ-410 How can I save ASCII import options to my template?
• FAQ-411 What is the difference between ASCII import and the Import Wizard?
• FAQ-412 How do I customize Drag and Drop and File Open for various import file types?
• FAQ-413 How do I import multiple data files with the same format?
• FAQ-414 How do I import data from the clipboard or from a web page?
• FAQ-415 How do I double-click to open ASCII files in Origin?
• FAQ-416 How do I extract Long Names and Units from same header rows when importing ASCII?
• FAQ-809 How do I import multiple ASCII files directly as the same matrix sheet and different objects?
• FAQ-919 ASCII Import filters or import options saved to a sheet fail after upgrading to Origin 2018
• FAQ-1067 How can I paste strings into Origin and not have it split strings across columns?
• FAQ-1154 How to import columns of Excel or ASCII data that look like numbers in the source file but need to be treated as Categorical?

Database Import

• FAQ-418 How do I open and manipulate a MySQL Database inside Origin?
• FAQ-419 Can I import data from a database and save and re-use queries?
• FAQ-794 How do I import date data from database?
• FAQ-800 How to set up the SQL?

Digitizer

• FAQ-421 How do I digitize an image to get data from it?

Import Data

• FAQ-423 How do I retrieve and use variables extracted from file name and header?
• FAQ-424 How do I import custom date and time data?
• FAQ-425 How to skip string when testing non-numeric in Import Wizard dialog?
• FAQ-427 How to import data from other Origin project?
• FAQ-428 How to run LabTalk script after import?
• FAQ-870 How to extract file name without extension to column comments?
• FAQ-969 What’s the difference between "Save Import setting to Sheet" and "save to <sheet>" in the import dialog?
• FAQ-988 How do I add cell formula in column label row during data importing?
• FAQ-995 Data: Connect to Web Fails to Import Data from Certain URLs in Windows 7
• FAQ-1008 How to resolve possible loss of precision when importing date time data?
• FAQ-1020 Is there a difference between Connect and Import?
• FAQ-1034 How to not use Data connector when drag and drop data into Origin?
• FAQ-1053 How to allow changing data when data connector is used?
• FAQ-1066 How do I copy and paste date-time data from MS Excel?
• FAQ-1080 I used a Data Connector to import data but when I reopen my project, the data is missing
• FAQ-1110 What should I do if Origin crashes when pasting link from Excel?
• FAQ-1155 How to import multiple files to a sheet and separate each file with an empty column?
• FAQ-1163 How do I add a file extension to a Data Connector?
• FAQ-1173 How to copy and paste comma separated data into Origin?
• FAQ-1181 Why my Connect to Web/Cloud menu grey out?
• FAQ-1182 How to import Eastern/Central European characters?
• FAQ-1217 How to import large integers and not show in scientific notation?
• FAQ-1223 How to create a Google client_id to make use of Origin’s Google Drive Cloud tool?
• FAQ-1235 Why am I pasting the wrong data from Origin into Excel?

Image Handling

• FAQ-431 Why does my Imported Image display as just black?

Importing Third Party Formats

• FAQ-433 How to Paste Excel or Plain Text Data into an Origin Worksheet and Set Column Labels
• FAQ-434 What is the Sampling Interval header row?
• FAQ-435 How to import/export data from/to MATLAB Workspace ?
• FAQ-436 Can Origin import the MATLAB file with structure data?
• FAQ-437 Can Origin import certain columns from different Excel sheets?
• FAQ-438 How can I transpose variable when importing data from MATLAB?
• FAQ-970 What do I do if there is an error while importing an SPC file?
• FAQ-993 When I paste my Excel time data into Origin, Origin displays 12/30/2019
• FAQ-1134 How to remove DDE links in a project?

Matrix Manipulation

• FAQ-459 How do I add, arrange, and view multiple matrix objects in one matrix window?
• FAQ-460 How do I convert a worksheet with matrix style data to Matrix or X Y Z?
• FAQ-461 How do I normalize a data matrix?
• FAQ-462 What is the difference between data matrix and image matrix?
• FAQ-1106 How to merge multiple NetCDF files into one?

Origin Project Files

• FAQ-464 How can I recover a damaged Origin file?
• FAQ-465 How do I package multiple Origin files to share with a colleague?
• FAQ-466 Is there an auto save feature for projects?
• FAQ-467 Are older-version Origin files compatible with newer versions of Origin?
• FAQ-468 My Origin project file (OPJ) is very slow to work with. How can I improve this
• FAQ-839 What should I do when Origin becomes slower as more data is imported?
• FAQ-927 Is there some way to convert the new OPJU file format into the older OPJ format?
• FAQ-974 How do I display Degrees, Minutes and Seconds in Origin?
• FAQ-1014 What Can I do to Reduce the Size of My Origin Project?

Workbook and Worksheet

• FAQ-348 How do I add or edit Name and Comments in the worksheet?
• FAQ-454 How to print Origin graph or worksheet to a PostScript file?
• FAQ-471 How to avoid the input data string converting to a numerical value automatically in the worksheet?
• FAQ-472 How to set the date format if the data is not consistent with the desired display format?
• FAQ-473 What formatting capabilities are available for the worksheet?
• FAQ-474 How do I edit and format text in merged cells?
• FAQ-475 How do I resize width/height of multiple columns/rows in a worksheet?
• FAQ-476 Can I control what header rows to display in a worksheet?
• FAQ-477 How to add supercripts, subscripts, and special characters in tables and worksheets?
• FAQ-478 How do I set up my worksheet to be always m x n cells?
• FAQ-479 What is a Sparkline and how do I customize it?
• FAQ-480 What is the difference between embedding and linking a graph in a worksheet cell
• FAQ-481 How do I copy data with column label rows?
• FAQ-482 How do I copy data with maximum precision?
• FAQ-483 How do I copy the column formula?
• FAQ-484 Why does Origin assign Types for Columns and how do I work with column types?
• FAQ-485 Where is the X data associated with my Y column?
• FAQ-486 What should I do if the text label size on a worksheet created in Origin 8.5 appears much bigger when opening in later version?
• FAQ-489 How can I easily identify a particular worksheet within a workbook that contains many?
• FAQ-662 How do I join two worksheets
• FAQ-913 How to apply format to multiple worksheets
• FAQ-973 How to disable editing of the cells in worksheet?
• FAQ-989 How to display number as 10 000 instead of 10000?
• FAQ-1009 How to extract unmasked data to a new worksheet?
• FAQ-1025 Why does the embedded graph disappear or show partially in current worksheet?
• FAQ-1052 Origin worksheets used to display truncated content as ### pound signs. What changed?
• FAQ-1069 How do I align column numbers on the decimal character?
• FAQ-1101 How to set a row as begin of my data?
• FAQ-1137 How to insert image to a cell note
• FAQ-1216 What’s the best way to copy paste my data into Origin?

Curve Handling

• FAQ-494 How do I find the average of multiple columns or data plots?
• FAQ-495 How do I further process or plot results contained in report sheet tables?
• FAQ-961 How to get the difference or sum of two curves?

Set Column Values / Cell Formula

• FAQ-497 How do I use a parameter row or worksheet variable in the Set Column Values dialog?
• FAQ-498 How do I use analysis results in the Set Values dialog?
• FAQ-499 How do I auto fill cells with data?
• FAQ-690 Two Quick Examples of Set Values dialog
• FAQ-692 How to set values of a subrange?
• FAQ-847 Why are my column formulas not updating when I insert or delete columns?
• FAQ-849 Can I turn off or selectively control use of spreadsheet cell notation in my workbooks?
• FAQ-871 Does Origin have a "IF" function?
• FAQ-939 Is there a way to disable cell formulas in my project?
• FAQ-941 Why are my cell formulas not working?
• FAQ-1011 Why i and I in equations give different results?
• FAQ-1042 How to show formulas in worksheet cells?
• FAQ-1043 How do I know the categorical values if I set a column as categorical?
• FAQ-1144 How do I Autofill my rows or columns with data?
• FAQ-1215 Cell Formula in Origin

Worksheet Data Manipulation

• FAQ-500 How do I sort my data?
• FAQ-502 How do I link one worksheet cell to another?
• FAQ-503 Is there a way to extract data from a worksheet based on conditions?
• FAQ-504 How do I reduce XY or XYZ dataset?
• FAQ-616 What are the different methods to calculate average value in Origin?
• FAQ-623 How do I find the minimum or maximum value in a dataset?
• FAQ-783 Can I select (and hide) worksheet columns by label or index?
• FAQ-784 How can I use comma as decimal mark and use semicolon as function arguments separator in formula and script?
• FAQ-806 How do I find the closest date/time value in a dataset?
• FAQ-820 How to work with large datasets in Origin?
• FAQ-827 How to mask data points on box chart?
• FAQ-862 How do I update a data filter when I make changes to my data?
• FAQ-863 How do I update a data filter during batch operations?
• FAQ-864 How do I save filter results so that I can do further graphing and analysis?
• FAQ-935 How to get the average value of every 5 points?
• FAQ-936 How do I Convert a Unix Timestamp to an Origin Date?
• FAQ-962 How to transpose one column data to one row data?
• FAQ-975 How do I use hexadecimal values in my data sheet?
• FAQ-1050 Does Origin have a tool like MS Excel's Text to Columns Wizard?
• FAQ-1107 How to merge separate date and time columns into one column?
• FAQ-1186 How to insert one row for every certain number of rows?