Guides and Tutorials
To help you navigate through how to use Instics and learn about our great features, we've developed easy-to-follow guides and tutorials for you to access at any time. Select what you would like to learn about!
Getting Started
- What is Instics?
Instics is the world's easiest spreadsheet. Instics was designed from the ground up for powerful analysis that's easy to use.
- How does Instics work?
Instics uses an advanced automation algorithm that automatically analyzes spreadsheets in seconds. Our technology takes care of complex and repetitive tasks like making graphs, formulas, and pivot tables. That means that you get to spend more time on important work and less time on tedious spreadsheet tasks.
- Where can I see sample spreadsheets?
We have created several sample spreadsheets to show how Instics works. If you're not sure where to start, we recommend checking out the Expense Tracker.
- How can I get help?
We'd be happy to help! Please feel free to contact us with any questions that you have.
Creating
- How can I create a new Instics spreadsheet?
- Click New on the left.
- Click Sheet in the drop-down menu.
- Click New on the left.
- How can I upload a spreadsheet from my computer?
- Click the Upload button on the left.
- Choose a spreadsheet file to upload.
- Click the Upload button on the left.
- Can I upload spreadsheets using drag-and-drop?
Yes! Instics supports drag-and-drop uploads. Simply drag a file from your computer and drop it into an Instics folder to upload it.
- What types of spreadsheets can be uploaded?
Instics supports many different types of spreadsheets for upload, including:
- Microsoft Excel (.xls, .xlsx)
- OpenDocument Spreadsheet (.ods)
- Comma separated values (.csv)
You can also copy and paste your existing spreadsheets into Instics.
If you encounter problems while uploading your spreadsheets, please contact us and we'd be happy to help.
Editing
- How can I copy and paste?
Instics supports copy and paste using standard keyboard shortcuts. You can also copy and paste to and from other spreadsheets like Microsoft Excel.
- To copy, press Ctrl+C (⌘+C on Mac).
- To paste, press Ctrl+V (⌘+V on Mac).
- How can I undo my last change?
Instics supports undo using standard keyboard shortcuts. You can also undo from the history tab.
- To undo, press Ctrl+Z (⌘+Z on Mac).
- How can I insert rows (or columns)?
- Click the row header on the left (or column header at the top).
- Click Insert at the top.
- An empty row (or column) will be inserted.
- Click the row header on the left (or column header at the top).
- How can I delete rows (or columns)?
- Click the row header on the left (or column header at the top).
- Click Delete at the top.
- The row (or column) will be deleted.
- Click the row header on the left (or column header at the top).
- How can I freeze columns?
Instics lets you freeze the first column, column A, so it will always stay visible as you scroll through your data.
- Click the column header at the top.
- Click Freeze at the top.
- The column will be frozen.
- Click the column header at the top.
Printing
- How can I print a spreadsheet?
- Click the Share button on the right.
- Click PDF document (.pdf) under Print.
- Click the Share button on the right.
Datatypes
- What are datatypes?
The datatype setting controls the types of graphs and statistics that Instics creates. For example, when the Date datatype is used, Instics will create date-based graphs like monthly totals and averages.
Usually Instics can automatically detect the right datatype to use. However, the datatype can also be customized in the sheet settings.
If you are not sure which datatype to use, please contact us and we'd be happy to help.
- What is the ID datatype?
The ID datatype is used for numbers that should be treated as names rather than used for calculations. For example:
- ID number
- Invoice number
- SKU
- ZIP code
- Tracking number
- What is a gauge datatype?
A gauge datatype is used for numbers that cannot be added together. For example:
- Account balance
- Temperature
- Speed
- Averages
- How can I change datatypes?
Every column in an Instics spreadsheet has a datatype setting that can be changed.
- Click the Settings button on the right.
- Click the drop-down menu next to the column name under Datatypes.
- Click the Settings button on the right.
Graphs
- How can I change the title of a graph?
- Click the graph on the right.
- Click the title at the top.
- Click the graph on the right.
Downloading
- How can I download a spreadsheet to my computer?
- Click the Share button on the right.
- Click CSV file (.csv) under Download.
- Click the Share button on the right.
- What limitations do downloaded spreadsheets have?
Spreadsheets downloaded from Instics will not include advanced Instics features like graphs, statistics, and history. The downloaded files will contain only the data table and will not be updated automatically.
For the best sharing experience, we recommend sharing the link to the online spreadsheet.
- How can I download a graph to my computer?
- Click the graph on the right.
- Click the Sharing button at the top.
- Click PNG image (.png) under Download.
- What limitations do downloaded graphs have?
Graphs downloaded from Instics will not include advanced Instics features like automatic high-quality scaling and interactive tooltips. The downloaded files will contain only a static image and will not be updated automatically.
For the best sharing experience, we recommend sharing the link to the online graph or embedding the graph on your web site.
Formulas
- How can I use Instics formulas?
Instics formulas let you perform calculations with your data. For example, you can add columns together to get a total or divide columns to get a ratio.
- Click the column menu button of an empty column.
- Click Formula in the drop-down menu.
- Click the column menu button of an empty column.
- What are examples of Instics formulas?
- To add columns together, enter B+C+D.
- To divide columns, enter B/C.
- To multiply columns, enter B*C.
- You can use parentheses like (B+C)/2.
Mobile Devices
- Can I use Instics on my mobile device (smartphone, tablet)?
Yes! Instics is optimized for mobile devices. To use Instics on your mobile device, simply go to instics.com and log in.
Account
- How can I change my e-mail address?
- Click your name at the top right.
- Click Settings in the drop-down menu.
- Click change next to Email.
- Click your name at the top right.
- How can I change my password?
- Click your name at the top right.
- Click Settings in the drop-down menu.
- Click change next to Password.
- Click your name at the top right.
Billing
- When does my free trial end?
Your free trial ends 30 days after you signed up for Instics. To see the trial end date:
- Click your name at the top right.
- Find the trial end date in the drop-down menu.
- Click your name at the top right.
- How can I change my credit card information?
- Click your name at the top right.
- Click Settings in the drop-down menu.
- Click change next to Payment method.
- Click your name at the top right.
- How can I cancel my subscription?
- Click your name at the top right.
- Click Settings in the drop-down menu.
- Click change next to Subscription status.
- Click your name at the top right.
- What happens after I cancel my subscription?
After canceling, you can continue using Instics until the end of your monthly subscription. After your subscription ends, you will no longer be able to access your Instics account.
Support
- What if I need more assistance?
We'd be happy to help! Please feel free to contact us with any questions that you have.
- Click the graph on the right.